Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a TEMPORARY tablespace and a
PERMANENT tablespace?
- 2 Answers
- 7052 Views
- I also Faced
- E-Mail Answers
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 |
How many packages we have in db
what functionality does oracle provide to secure sensitive information?
how does an oracle clusterware manage crs resources?
Which environment variables are absolutely critical in order to run the OUI?
What are the different sql server versions you have worked on? : sql server DBA
Explain the concept of the DUAL table.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
what is difference between user managed backup and rman backup?
Can we take incremental backups in datapump?
What are the steps you will take to improve performance of a poor performing query?
now one user in online.now i want drop him..how do u drop him?
-
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)
