select distinct object_type,owner
from dba_segments
where tablespace_name='&TABLESPACE_NAME';
create tablespace with BIGFILE datafile.
AND MAKE IT DEFAULT DATABASE TABLESPACE.
through expdp export tablespace.
expdp userid/pwd DIRECTORY=data DUMPFILE=user TABLESPACES=users
DROP TABLESPACE TBS_NAME INCLUDING CONTENTS AND DATAFILES
impdp userid/pwd DIRECTORY=DATA DUMPFILE=USER [B]REMAP_TABLESPACE=OLD_TBS_NAME:NEW_TBS_NAME
select distinct object_type,owner
from dba_segments
where tablespace_name='&TABLESPACE_NAME';