| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> replace logical exp-imp with transportable tablespace
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 25 2004 - 03:02:04 CDT
 |
 |