Transportable tablespace should do this – but you would need to make the
tablespace read-only for a bit, or get it from a backup.
Mike Tefft
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Rich J
Sent: Thursday, November 17, 2016 8:51 AM
To: Oracle L <oracle-l@xxxxxxxxxxxxx>
Subject: Block copy a table to another DB
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