Home » RDBMS Server » Server Administration » moving data wiht db_link
moving data wiht db_link [message #56540] Mon, 07 April 2003 11:52 Go to next message
tk
Messages: 6
Registered: May 2002
Junior Member
Could anybody show me(code sample) how to move database from a machine running 7 to 9i using db_link?
Any help greatly appreciated
Thanks,
TK

Report message to a moderator

Re: moving data wiht db_link [message #56560 is a reply to message #56540] Tue, 08 April 2003 16:50 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Suppose you already have the DB link "remotedb" in place, use the

INSERT into local_schema.local_table select * from remotr_schema.remote_table@remotrdb;

COMMIT;

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Rollback segments too small
Next Topic: Getting more REDO - WHY? *** HELP ***
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:42:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.