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: 49
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: 3227
Registered: January 2009
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: 49
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: 3227
Registered: January 2009
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: 49
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: Sun Nov 8 13:43:39 CST 2009

Total time taken to generate the page: 0.02013 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.