Interested to Buy Any Domain ? << Click Here >> for more details...
What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)
- 3 Answers
- 5378 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What are advantages fo Stored Procedures?
How to add another datafile to a tablespace?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What do you understand by database schema and what does it hold?
What is index in Oracle?
How to select an oracle system id (sid)?
how to retrieve data from different tables ,place this data in different excel worksheets.
What is truncate oracle?
Is postgres faster than oracle?
How can we delete duplicate rows in a table?
Explain the dml?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Oracle General 
