What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is oracle an operator?

533


What is the difference between sharding and replication?

475


How to rename an index in oracle?

614


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3868


Can we write insert statement in function in oracle?

533






What is an oracle table?

555


what is the scripts in data base?

1601


How to handle a single quote in oracle sql?

593


What is bulk copy or bcp in oracle?

606


what is IDE,DMV in sql server?

2244


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1807


How many categories of data types?

570


How to create a table interactively?

556


How many types of tables supported by oracle?

578


How to define a procedure inside another procedure?

542