Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 6997 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
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?
What are the steps you will take to improve performance of a poor performing query?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
who owns the operating system files created by the utl_file package?
what is ora 24313?what is the procedure to exclude that error?
what functionality does oracle provide to secure sensitive information?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What the different components in replication and what is their use? : sql server DBA
what are the performance views in an oracle rac environment?
What would you do with an "in-doubt" distributed transaction?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can a session indicate its interest in receiving alerts?
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?
