Oracle: Create/drop tablespace

PHOTO EMBED

Mon Aug 29 2022 18:43:04 GMT+0000 (Coordinated Universal Time)

Saved by @marcopinero #sql

DROP TABLESPACE MYSPACENAME INCLUDING contents;

CREATE TABLESPACE MYSPACENAME 
   DATAFILE 'ts1_filename.dbf' 
   SIZE 2000m 
   autoextend on NEXT 1000m maxsize unlimited;
   
 alter tablespace MYSPACENAME coalesce;
content_copyCOPY