Hi Every One , What is the table Space in Oracle Database ?
waiting for answere and thankyou

Answer Posted / shilpa

A tablespace is a logical storage unit within an Oracle
database. It is logical because a tablespace is not visible
in the file system of the machine on which the database
resides. A tablespace, in turn, consists of at least one
datafile which, in turn, are physically located in the file
system of the server. Btw, a datafile belongs to exactly one
tablespace.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is IDE,DMV in sql server?

2492


How to retrieve the count of updated rows?

788


What is an index associated with a constraint?

772


Why does oracle 9i treat an empty string as null?

748


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

831


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2045


Give the various exception types.

747


How to best split csv strings in oracle 9i?

795


What is a sub query? Describe its types?

776


definition of cluster and non-clustered index?

2692


What is partitioned table in Oracle?

842


What is a nested table?

823


Is the After report trigger fired if the report execution fails ?

2699


What is the maximum number of triggers that can be applied to a single table?

779


In which language oracle has been developed?

851