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;

Was this article helpful?

Related Articles

Leave a Comment