| Subject | Re: [IBO] Using the Data Pump | 
|---|---|
| Author | Helen Borrie | 
| Post date | 2004-03-06T05:04:08Z | 
At 04:41 AM 6/03/2004 +0000, you wrote:
You have two databases, two statements one transaction.
Source database:
Statement: select.................
prepare
Destination
Insert...... (or execute statement if it's a SP)
check mappings
possibly massage
prepare
Transaction: commit
Helen
            >The data pump appears straight forward. Double click and fill in thePrepare? (both statements)
>statements for the source and destination. However, when I do this the
>statements don't persist. What might I be missing?
You have two databases, two statements one transaction.
Source database:
Statement: select.................
prepare
Destination
Insert...... (or execute statement if it's a SP)
check mappings
possibly massage
prepare
Transaction: commit
Helen