Hi,

I have two Database (Data1 and Data2).

I would like to copy a table from the Database "Data1" to the Database "Data2", how can I do that ?

Thanks for your response

Bruno

Josselin,

> I would like to copy a table from the Database "Data1" to the Database "Data2", how can I do that ?

Use this to create an empty table:

Create table MyTable as select * from Data1.MyTable with no data;

To copy the records as well, use:

Create table GoAdressen as select * from Easymail.Adressen with data;

and execute it in the context of Database Data2.

Uli

Oups, I pasted a wrong line. Here the correct statements:

Use this to create an empty table:

Create table MyTable as select * from Data1.MyTable with no data;

To copy the records as well, use:

Create table MyTable as select * from Data1.MyTable with data;

and execute it in the context of Database Data2.

Uli

Bruno


I'm not sure wether that copies the indices, triggers etc or not. I just looked in the OLH and I can't figure it out from there but I don't think so.

Roy Lambert

Roy,

> I'm not sure wether that copies the indices, triggers etc or not. I just looked in the OLH and I can't figure it out from there but I don't think so.

You are right - it just copies the table, nothing else.

Uli