Does anyone knows how to import Data Archive object from one DB to another?

Hi @LucyWang ,

The export/import options are only generate the definitions and will not move any data. To move your archive object s from one DB to the another, i would look at using Oracle transportable tablespace option as the archive tables are usually stored in its own tablespace (i.e. IFSAPP_ARCHIVE_DATA). 

Cheers

Hi Sajith,

Thanks for the reply!

It is Data archive Object Definition that I want to export/import from one DB to another. The export generates <object>.ins code, but after “importing” the code (runningthe code in sqlplus)  into the new DB, I do not see the data archive object in this DB.

Lucy Wang

Hi @LucyWang ,

Did you export the storage option as well? This is the one that has the object definitions.

cheers

Again thank you for the reply, but the option only works if destination is Oracle Table. I have destination NONE.

Lucy

Problem solved!

Running <object>.ins does work just not right away. The object showed up after couple hours (maybe much sooner), I just did not bother to check.

Case closed!

Lucy