Database Administration (MOSC)

MOSC Banner

want to move unused space from one tablespace to another

edited Feb 24, 2010 5:46PM in Database Administration (MOSC) 4 commentsAnswered
Hi Guru's,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center