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 |
How to use values from other tables in update statements using oracle?
What is an oracle transaction?
How to define a data source name (dsn) in odbc manager?
What are privileges and grants?
Can we protect our pl/sql source code?
what is Table ?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to export several tables together?
What is tns service name?
List out the types of joins.
Is there an oracle sql query that aggregates multiple rows into one row?
How to store only time; not date and time?