Reorganize tablespace with data type LONG / LONG RAW
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
0