Home » Developer & Programmer » Precompilers, OCI & OCCI » Transferring data between two databases (Oracle 10.2)
Transferring data between two databases [message #398873] Sat, 18 April 2009 21:20 Go to next message
oracle123
Messages: 56
Registered: March 2009
Member
Hi All,

I am current using Pro*C to upload data from a flat file to database.

Now I have to transfer information(data) between databases. As a rookie, I do not know an efficient of way doing it. Please guide me with an efficient way.

Thanks,
Scott.

Re: Transferring data between two databases [message #398874 is a reply to message #398873] Sat, 18 April 2009 22:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>upload data from a flat file to database.
http://www.orafaq.com/wiki/SQL*Loader_FAQ
Re: Transferring data between two databases [message #398930 is a reply to message #398873] Sun, 19 April 2009 19:01 Go to previous messageGo to next message
oracle123
Messages: 56
Registered: March 2009
Member
Blackswan,

I want to transfer data between databases not from flat file to database.

Thanks,
Scott.
Re: Transferring data between two databases [message #398931 is a reply to message #398873] Sun, 19 April 2009 20:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.


>I want to transfer data between databases
Then use Database Link (DBLINK)
Re: Transferring data between two databases [message #398941 is a reply to message #398873] Sun, 19 April 2009 22:31 Go to previous message
oracle123
Messages: 56
Registered: March 2009
Member
Blackswan,

I did go through the posting guidelines and did not know where I did the mistake in my post. Anyways thanks for your reply.

- Scott.
Previous Topic: ORA-01002: fetch out of sequence
Next Topic: bind variavles,OCI API obndrv()
Goto Forum:
  


Current Time: Thu Mar 28 11:11:23 CDT 2024