Thursday, July 3, 2008

Copying table from one database instance to another without using dblink

Copy to UserId/Pwd@MyDB
create NewTable(field1)
using select * from temp1;

Here MyDB is the TNS name of your database.
Here there is no need to create DBLink.

No comments: