To generate a table space processing statement

Select ' CREATE tablespace ' | | V.tablespace_name | |
' datafile ' E:\ORADATA\GISAP\ ' | | V.tablespace_name | |
'. DBF ' SIZE 8M
Autoextend on NEXT 8M MAXSIZE Unlimited
LOGGING
ONLINE
Permanent
EXTENT MANAGEMENT Local Autoallocate
SEGMENT space MANAGEMENT AUTO; ' As to create a table space,
' CREATE tablespace ' | | V.tablespace_name | |
' INDEX
DataFile ' E:\ORADATA\GISAP\ ' | | V.tablespace_name | |
' INDEX. DBF ' SIZE 8M
Autoextend on NEXT 8M MAXSIZE Unlimited
LOGGING
ONLINE
Permanent
EXTENT MANAGEMENT Local Autoallocate
SEGMENT space MANAGEMENT AUTO; ' As to create an index table space,
' Drop tablespace ' | | V.tablespace_name | |
' including contents and datafiles; ' As delete tablespace,
' Drop tablespace ' | | V.tablespace_name | |
' INDEX including contents and datafiles; ' As deletes the index table space,
' Alter user GISAP quota unlimited on ' | | V.tablespace_name | | '; ' Authorize the form's air tone,
' Alter user GISAP quota unlimited on ' | | V.tablespace_name | |
' Index; ' Authorize the Index table space
From (SELECT DISTINCT t.table_name, T.tablespace_name
From All_tab_partitions T
WHERE t.table_owner = ' Gisap '
and t.table_name not like '%bin% ') V

Use this statement to isolate table partitions that are used by those tables.