What is tablespace in oracle? how can we create? how is it manage? . . . T

What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)

Question Posted / ashutosh

3 Answers
5063 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....

Answer / sabari shan

*tablespace is the logical structure of the database.it contains collection of segments. segment contains collection of extents. extent contain collection of oracle blocks.

*Segment: residing space of every object.whenever u create any object one segment will create in the name of object.when the segment created it have no of extents.as a dba we can configure the no of extents when we create the tablespace.

*Extent: Actual space allocation and deallocation will done here.once the extent get filled next extent will create by the oracle server.

*Block: its is basic unit of storage. Here only the actual data will be store.

Is This Answer Correct ?

6 Yes

0 No

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....

Answer / ramya

The Structure of the table is known as tablespace,
create tablespace
users
datafile
‘/ora01/oracle/oradata/booktst_users_01.dbf’
size
50m;
using alter query we can manage the tablesapace

Is This Answer Correct ?

4 Yes

2 No

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....

Answer / s.s.kumar

The Structure of the table is known as tablespace,
create tablespace
users
datafile
‘/ora01/oracle/oradata/booktst_users_01.dbf’
size
50m;
using alter query we can manage the tablesapace

Is This Answer Correct ?

0 Yes

0 No

Post New Answer