Reorganize tablespace with Datapump
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