Posts Tagged ‘ alter tablespace ’

Creating, Dropping and Altering Tablespace using SQL Commands in Oracle

You can create Tablespace using this SQL Command.


create tablespace table_space_name
datafile '/app/oracle/product/11.2.0/oradata/practiceab/table_space_test.dbf' size 100k
autoextend on next 10m maxsize 300m;

To drop any Tablespace in Oracle use this following query.


DROP TABLESPACE table_space_name
INCLUDING CONTENTS AND DATAFILES
CASCADE CONSTRAINTS;

Continue reading

Advertisements
Advertisements