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
- 5212 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 |
How can I create database in oracle?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
how can we write trigger in trigger???????? can we write one trigger on two table???
Is oracle an operator?
Can objects of the same schema reside in different tablespace?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Tell me New Feature of Oracle 10g?
Does rowid change in oracle?
How to call a trigger inside a stored procedure?Give an example.
Explain the use of owner option in exp command.
List the types of joins used in writing subqueries?
3. Display all the client numbers in the ORDER table. Remove duplicates.
Oracle General 
