Home » SQL & PL/SQL » SQL & PL/SQL » How to copy data from remote database to my local system
How to copy data from remote database to my local system [message #36530] Mon, 03 December 2001 05:04 Go to next message
renjith
Messages: 5
Registered: November 2001
Junior Member
Hi All,

How to take data from remote database to in my local
database using through procedure

Thanks in Advance,
Renjith.

----------------------------------------------------------------------

Report message to a moderator

Re: How to copy data from remote database to my local system [message #36531 is a reply to message #36530] Mon, 03 December 2001 05:17 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Method 1)create database link and read data from remote DB and write in local db

Method 2) use export and import

Method 3) spool to text file (table's data) and use sqlloader to load into local DB

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: How delete in cascade the records in the tables when they are in relationship
Next Topic: Trigger to operate on multiple tables, via OR
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 05:07:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.