Re: imp - BLOB - reduce imp time

Hi,
well, for transportable tablespaces you need some downtime, at least make the tablespace read-only.
many times this will not work due to not getting the chance to make it read-only, which for many equals downtime. Still, restoring your database somewhere, and doing the transportable tablespace trick might be faster than exp/imp. Really depends on the size of your database (to be precise the number of rows in the table with BLOB columns).

If the imp only takes two hours, it's probably not worth investigating other options.

Karsten Received on Thu Jun 16 2005 - 13:57:11 CDT