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 an oracle user role?
What is a data dictionary and how can it be created?
What are temporal data types in oracle?
How to start an oracle instance?
Give the constructs of a package, function or a procedure.
Can we create trigger on materialized view in oracle?
Explain the use of record option in exp command.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Why does Oracle not permit the use of PCTUSED with indexes?
How do I call oracle stored procedures that take no parameters?
What is a user account in oracle?
What is the disadvantage of User defind function?
Briefly explain what is literal? Give an example where it can be used?
What is the recommended interval at which to run statspack snapshots, and why?
What is object data modeling?