What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 6036 Views
- I also Faced
- E-Mail Answers
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
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
how can you communicate with operating system files from oracle?
How would you best determine why your MVIEW couldn't FAST REFRESH?
How do you open a cluster administrator? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How to start SQL Server in minimal configuration mode?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How would you go about verifying the network name that the local_listener is currently using?
how can you connect from 10g user to 11g user??
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
when does an alert gets signaled?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
