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
Where do you find the default index fill factor and how to change it? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What is fill factor? : sql server DBA
What is the default fill factor value? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
how can you initialize log miner?
what are the performance views in an oracle rac environment?
What are statistics, under what circumstances they go out of date, how do you update them?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What are the commands used in dcl? : sql server DBA