Database Administration (MOSC)

MOSC Banner

Reorganize tablespace with Datapump

edited Feb 4, 2015 11:25AM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi,

I have a tablespace with a very large amount of free space at the end that I would like to free up.  I cannot alter the tablespace to reduce the size because there is one extent in the area still in use.  I have identified the table holding the extent.  I the past I have used alter move to relocate these, but this table contains a lob column so that won’t work.  So, I will need to use expdp/impdp.  Here is what I believe I need to do:

Export the table:

expdp %uid%/%pwd% dumpfile=%dfl% directory=%dir% tables=DMKR_ASLINE.CMIRES_LBYD

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