{表領域、データファイル}表領域を削除

 

https://docs.oracle.com/cd/F19136_01/admin/managing-tablespaces.html#GUID-4EB483A2-2E04-4047-8885-F5396876D0EB

sqlplus system/oracle@pdb11

select * from dba_data_files;
select * from dba_temp_files;
select * from dba_tablespaces;
select * from v$tablespace;

drop tablespace tbsa including contents and datafiles;
drop tablespace tbsb including contents and datafiles;
drop tablespace tbsc including contents and datafiles;
drop tablespace tbsd including contents and datafiles;
drop tablespace tbse including contents and datafiles;
drop tablespace tbsf including contents and datafiles;
drop tablespace tbsg including contents and datafiles;
drop tablespace tbsh including contents and datafiles;
drop tablespace tbsi including contents and datafiles;
drop tablespace tbsj including contents and datafiles;

drop tablespace tempa including contents and datafiles;
drop tablespace undoa including contents and datafiles;

drop tablespace tbsk including contents and datafiles;
drop tablespace tbsl including contents and datafiles;