Hey all,
In 11.2.0.3, I have a table with an inline BLOB that's undergone some
house cleaning where half of the total rows (and 2/3 of the blocks) were
logically invalid and have been deleted. As annually scheduled purges
will keep the row count down, this table will not substantially grow. I
want to rebuild this table, more for buffer cache pressure than storage.
I've created and tested the function of a DBMS_REDEFINITION script, so
now I'd like to copy the production table to another DB for final
testing. So, I'll just...copy...hmmmm. Any copy I can think of will
reorganize the target table in the test DB. Since the table's blocks
span nearly all of the tablespace's datafiles, and that tablespace
contains nearly all of the non-system data, the best option I can think
of is an RMAN database restore from backup.
Is there any other way to copy a table block-by-block to retain it's
original size and row fill?
Thanks,
Rich
