Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is a Tablespace?

Answer Posted / javeed_mj

An Oracle database consists of one or more logical storage
units called tablespaces, which collectivley store all of
the database's data.

Each tablespace in an ORACLE database consists of one or
more files called datafiles, which are physical structures
that conform with the operating system in which Oracle is
running.

For Example::: A simple Oracle Database have one tablespace
and one datafile

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does the on-delete-cascade statement work?

1163


What is the difference between primary key and unique key and foreign key in oracle?

1035


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2246


Explain what are the type of synonyms?

1185


There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2085


Give the various exception types.

1040


Why use resource manager in Oracle?

1172


Is a rollback possible to any savepoint?

1153


What are the four Oracle system processes that must always be up and running for the database to be useable?

1051


How to select some columns from a table in oracle?

1170


How do I connect to oracle?

1080


What is oracle rownum?

1016


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1088


What is the difference between sharding and partitioning?

1038


What is a Garbage Collection? and what is full recursive Garbage collection?

2956