What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kranthi
Permanent tablespace is used to store permanent objects etc
temporary tablespace is used for sorting
| Is This Answer Correct ? | 0 Yes | 0 No |
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What is the default port no on which sql server listens? : sql server DBA
What is the dataguard background process??
How would you go about verifying the network name that the local_listener is currently using?
what r the types of backup?
what is ora 24313?what is the procedure to exclude that error?
How can you control the amount of free space in your index pages? : sql server DBA
Give the stages of instance startup to a usable state where normal users may access it.
what is the use of ocr?
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
what is incremental checkpoint?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)