Database Administration (MOSC)

MOSC Banner

Reorganize tablespace with data type LONG / LONG RAW

edited Nov 13, 2012 6:19PM in Database Administration (MOSC) 2 commentsAnswered

We have a TABLESPACES with 3.8TB of space allocated, 700GB used, more than 3TB free and need to free space, but we have more than 400 tables with data type LONG / LONG RAW. We are currently doing the following tablespace reorganization method:

1. we did a RMAN backup (NOARCHIVELOG)
2. create an export file with expdp (we have already executed)

$ expdp system directory=eliminar7 dumpfile=exp_APPS_TS_TX_DATA_%U.dmp \
logfile=exp_APPS_TS_TX_DATA.log TABLESPACES=APPS_TS_TX_DATA PARALLEL=4 filesize=100G

3. Remove the tablespace APPS_TS_TX_DATA (can not delete)
4. Import all objects using: impdp TABLESPACES = APPS_TS_TX_DATA

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