Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: replace logical exp-imp with transportable tablespace

Re: replace logical exp-imp with transportable tablespace

From: Carel-Jan Engel <>
Date: Mon, 25 Oct 2004 12:17:59 +0200 (CEST)
Message-ID: <>


What OS/version are you on? Do you need to make changes to the 2nd database? If not, you might consider Data Guard Physical Standby.

It allows you to open the 2nd database read-only during the day. At night you put it in managed recovery mode, and it will resync. This can be done through sql-scripts/cron. After sync you put it in R/O mode again.

Extra advantage: You have a standby datbase you can use in case of failure of the primary database.

Regards, Carel-Jan

If you think education is expensive, try ignorance. (Derek Bok) ===

> Hi,
> We have 2 database that need to be in sync every
> night, also 1 database for user transactions while
> sync process is running.
> Current operation is using logical exp-imp and take
> half hour to complete, no manual intervention here.
> But because future space estimation is about 20 times
> more than current, it means at least exp-imp will run
> in 10 hours, and this is untolerable.
> So i try to use transportable tablespace instead, but
> i'm not sure if this can be done everytimes without
> manual intervention (the main reason is because i must
> drop existing tablespace in destination, how if it
> failed??).
> additional info for current exp-imp process:
> - Related tablespace in source db is set to read only
> when exp-imp.
> - Destination db is idle when exp-imp (no users
> connect to it).
> Can transportable tablesplace replace logical exp-imp?
> The main limitation is : no manual intervention
> allowed (except space problem, of course).
> ps: i believe probably someone will suggest
> replication instead of exp-imp. But, i'm sorry,
> because i can't change anything related to application
> (we use 3rd party vendor).
> regards,
> tomi
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail Address AutoComplete - You start. We finish.
> --

Received on Mon Oct 25 2004 - 05:13:27 CDT

Original text of this message