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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How do you trace the traffic hitting a sql server? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What types of replication are supported in sql server? : sql server DBA
how can you schedule a job in database?
how can you communicate with operating system files from oracle?
How would you extract DDL of a table without using a GUI tool?
How would you go about verifying the network name that the local_listener is currently using?
How to start SQL Server in minimal configuration mode?
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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA