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
How to convert raw data type into text in oracle? Explain
How to execute a stored program unit?
How to handle a single quote in oracle sql?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is a trigger oracle?
what is IDE,DMV in sql server?
What is oracle thin client?
What is an anonymous block?
How do I find my oracle client driver version?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Can you create a synonym without having a table?
How to download oracle database 10g xe?
What is a parameter file in oracle?
Explain the use of consistent option in exp command.
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?