Block copy a table to another DB
Date: Thu, 17 Nov 2016 07:50:33 -0600
Message-ID: <b801f1b2a2d54ca564f69e66affb1b20_at_society.servebeer.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 17 2016 - 14:50:33 CET