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
- 5256 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 |
7. Repeat query (7) but also display all clients who have never ordered anything.
What are different Oracle database objects?
Is it possible to enter only time value into a column of a table in sql?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Difference between inner join vs where ?
How to rename an index in oracle?
What are advantages of dateset in datastage?
Write a syntax for update query in oracle?
Why use resource manager in Oracle?
difference between procedures and function?
What is a package in oracle?
How to rollback the current transaction in oracle?
Oracle General 
