What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)
Answer Posted / 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 |
Post New Answer View All Answers
What is the usage of analyze command in oracle?
What are the attributes of cursor?
List out the difference between commit, rollback, and savepoint?
Explain about functional dependency and its relation with table design?
How to convert csv to table in oracle?
How do we get field details of a table?
Explain the different normalization forms?
What is the quickest way to export a table to a flat file?
How is it different from a normal table?
What is a trace file and how is it created in oracle?
What is a table index in oracle?
How to write a left outer join with the where clause in oracle?
How to retrieve the count of updated rows?
Explain index?
Explain how you would restore a database using RMAN to Point in Time?