| Subject | Re: [IBO] How can I copy a table from one database to another |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-02-19T14:06:15Z |
At 10:49 PM 19/02/2006, you wrote:
database1. Then set up the ib_datapump to select from the source
table and insert to the destination table, all done in a
cross-database transaction.
Helen
>I have two tables which are the same in different databases. I wantTIB_Datapump. Create the table in database2 using the metadata from
>to copy the contents of database1.table1 to database2.table1
database1. Then set up the ib_datapump to select from the source
table and insert to the destination table, all done in a
cross-database transaction.
Helen