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

What are the differences between lov and list item?

552


What are the differences between date and timestamp in oracle?

549


What are data pump export and import modes?

602


What is merge statement used for?

561


Difference between hot backup vs. Cold backup?

602






How to turn on or off recycle bin for the instance?

597


How do I spool in oracle?

529


How to add a new column to an existing table in oracle?

576


Can multiple cursors being opened at the same time?

602


What are the tools for Oracle ?

597


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1651


How to rename an existing table?

605


List out the components of logical database structure of oracle database.

575


What do you understand by a database object?

577


Explain the use of file option in exp command.

592