Create and drop tablespace in Oracle Database

Create and drop a new tablespace in Oracle DB

Create New tablespace DATA

Create tablespace DATA datafile '/u01/app/oradata/data01.dbf' size 5G autoextend on next 500M;

Create tablespace on ASM diskgroup

Create tablespace DATA datafile '+DATAG' size 5G autoextend on next 500M;

Create big tablespace

CREATE BIGFILE TABLESPACE BIGTS datafile '/u01/app/oradata/bigts01.dbf' size 100G autoextend on NEXT 1G;

Drop tablespace in oracle DB

Drop a tablespace without removing the physical database files.

drop tablespace DATA;

Drop tablespace including the physical datafiles.

drop tablespace DATA including contents and datafiles;

1 thought on “Create and drop tablespace in Oracle Database

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.