• Arun Kumar

Tablespace Administration

Create Tablespace



SQL> Create tablespace test_tbs datafile '<df_location>' size 50m;

ADD SPACE TO EXISTING TABLESPACE

  1. Check the current tablespace utilization

  2. Check the data files associated with the tablespace

  3. You can either add a new data file or extend (resize) existing data files


SQL> Alter tablespace add datafile '<df_location>' size 50m;


SQL> Alter database datafile '<df_location>' resize 2G;

Drop Tablespace


SQL> drop tablespace test_tbs including contents and datafiles;


277 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir