Generate tablespace processing statement

Select 'create tablespace' | V. tablespace_name |
'Datafile' E: \ oradata \ gisap \ '| V. tablespace_name |
'. Dbf'' size 8 m
Autoextend on next 8 m maxsize Unlimited
Logging
Online
Permanent
Extent management local autoallocate
Segment space management auto; 'As creates a tablespace,
'Create tablespace' | V. tablespace_name |
'Index
Datafile ''e: \ oradata \ gisap \ '| V. tablespace_name |
'Index. dbf' size 8 m
Autoextend on next 8 m maxsize Unlimited
Logging
Online
Permanent
Extent management local autoallocate
Segment space management auto; 'As create index tablespace,
'Drop tablespace' | V. tablespace_name |
'Including contents and datafiles; 'as to delete a tablespace,
'Drop tablespace' | V. tablespace_name |
'Index including contents and datafiles; 'As deletes the index tablespace,
'Alter user gisap quota unlimited on '| V. tablespace_name |'; 'authorizes the void of the table,
'Alter user gisap quota unlimited on '| V. tablespace_name |
'Index; 'authorize the index tablespace
From (select distinct T. table_name, T. tablespace_name
From all_tab_partitions t
Where T. table_owner = 'giap'
And T. table_name not like '% bin %') V

This statement is used to identify tables that use table partitions.