want to move unused space from one tablespace to another
Hi Guru's,
I want to move "UNDOTBS1" tablespace space into "STAGING" tablespace. Below are the details about my tablespace's.
Please advise me..
SQL> select tablespace_name,sum(bytes/1024/1024/1024) from dba_free_space group
by tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024/1024)
------------------------------ -------------------------
UNDOTBS1 41.6907349
SYSAUX 4.5043335
TARGET 29.2967529
USERS 4.30792236
SYSTEM 4.88604736
STAGING 30.4182129
6 rows selected.
SQL> select tablespace_name,sum(bytes/1024/1024/1024) from dba_segments group by
tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024/1024)
------------------------------ -------------------------
SYSAUX 1.28656006
UNDOTBS1 .074707031
USERS 2.68048096
SYSTEM .738830566
STAGING 118.768677