Some Important Commands

SQL > select property_name||' '||property_value from database_properties;

SQL > select name from v$datafile;

SQL > select name from v$tempfile;

SQL > SELECT tablespace_name||' '||file_name||' '||(bytes/1024)/1024 FROM dba_data_files;

SQL > SELECT tablespace_name||' '||file_name||' '||(bytes/1024)/1024 FROM dba_temp_files;

SQL > create temporary tablespace temp1 tempfile '/u02/clonedb/oradata/cdb1/temp01.dbf' size 50m;

SQL > ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp1;

SQL > DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES;