What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
Answer Posted / guest
Temporary Tablespace is in generally used for sorting
purpose while Permanent tablespace is used to sore
permanent objects
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What is the default fill factor value? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the importance of a recovery model? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What happens on checkpoint? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
which background process invoke at the time of upgradation tell me???
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is dbcc? : sql server DBA
what do you understand by fine-grained auditing?
what is logical system in sap basis