What is a Tablespace?

Answer Posted / nishi

A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between sap and oracle?

575


What is rich query?

544


How to return top 5 rows in oracle?

550


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

934


When do you get a .pll extension in oracle? Explain its importance

574






How to run the anonymous block again?

595


What is the best way to do multi-row insert in oracle?

563


How to update values on multiple rows in oracle?

602


How do I limit the number of rows returned by an oracle query after ordering?

640


11. Display the client number and name and the client number and name of the person who referred that client.

1921


What is the use of file param in imp command?

646


How to install oracle odbc drivers?

623


Explain the difference between replace() and translate() functions in oracle?

582


Explain the importance of .pll extension in oracle?

555


What privilege is needed for a user to connect to oracle server?

559