Database Centre
This blog is to share and exchange information related to databases
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment