What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
Answer Posted / kranthi
Permanent tablespace is used to store permanent objects etc
temporary tablespace is used for sorting
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you go about verifying the network name that the local_listener is currently using?
What are the different ways you can create databases in sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how can you schedule a job in database?
how can you enable flashback feature?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is logical system in sap basis
what functionality does oracle provide to secure sensitive information?
Query processing is slow(eg select query)how will u solve that
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
internal architecture
What are the different types of indexes available in sql server? : sql server DBA
how can you communicate with operating system files from oracle?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the commands you'd issue to show the explain plan for "select * from dual"?