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

Answer Posted / tanoy guhasarkar

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 ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

833


What happens to the data files if a tablespace is dropped?

809


What is system global area (sga) in oracle?

779


What are dml statements in oracle?

810


How to fetch the row which has the max value for a column?

761


Can you have more than one content canvas view attached with a window ?

2056


various types of hints and their usage

2385


What the is the diff between local index and global index. give some example.

1379


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

867


How do I limit the number of oracle database connections generated by weblogic server?

815


defination of bitmap index

1814


What is index-organized table in Oracle?

789


Difference between varchar and varchar2 data types?

860


types of indexes and the rationale behind choosing a particular index for a situation.

2249


Please explain joins in oracle?

813