OraFAQ Forum: Precompilers, OCI & OCCI » Transferring data between two databases

Home » Developer & Programmer » Precompilers, OCI & OCCI » Transferring data between two databases (Oracle 10.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Transferring data between two databases [message #398873]

Sat, 18 April 2009 21:20

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.

Report message to a moderator

Re: Transferring data between two databases [message #398874 is a reply to message #398873]

Sat, 18 April 2009 22:03

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

Report message to a moderator

Re: Transferring data between two databases [message #398930 is a reply to message #398873]

Sun, 19 April 2009 19:01

oracle123
Messages: 56
Registered: March 2009

Member

Blackswan,

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

Thanks,
Scott.

Report message to a moderator

Re: Transferring data between two databases [message #398931 is a reply to message #398873]

Sun, 19 April 2009 20:11

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)

Report message to a moderator

Re: Transferring data between two databases [message #398941 is a reply to message #398873]

Sun, 19 April 2009 22:31

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 26 21:49:55 CDT 2025