What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)
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 |
types of indexes and the rationale behind choosing a particular index for a situation.
How many categories of data types?
What are the differences between char and varchar2 in oracle?
What is the use of oracle?
Can we write dml statement in function in oracle?
Explain index?
does the query needs a hint to access a materialized view?
Can the default values be assigned to actual parameters?
How data locks are respected in oracle?
How to turn on or off recycle bin for the session?
what is the difference between substr and instr function in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?