OraFAQ Forum: General » COPY COMMAND in Pl/sql

Home » Other » General » COPY COMMAND in Pl/sql (ORACLE 10G)

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

COPY COMMAND in Pl/sql [message #542212]

Sun, 05 February 2012 23:15

ORA_KRISH
Messages: 38
Registered: March 2011
Location: chennai

Member

hi everyone, i need to transfer single table data from one database to another database, one of the field as clob datatype. so, how to copy to another database. without changing the datatype i need to copy the data to another database, is 't possible?

regards

krish

Report message to a moderator

Re: COPY COMMAND in Pl/sql [message #542215 is a reply to message #542212]

Sun, 05 February 2012 23:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

expdp & impdp

Report message to a moderator

Re: COPY COMMAND in Pl/sql [message #542223 is a reply to message #542212]

Mon, 06 February 2012 00:13

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Or directly impdp with network_link option.

Regards
Michelt

Report message to a moderator

Re: COPY COMMAND in Pl/sql [message #542242 is a reply to message #542215]

Mon, 06 February 2012 01:01

ORA_KRISH
Messages: 38
Registered: March 2011
Location: chennai

Member

great thanks for the reply, it works

regards

krish

Report message to a moderator

Re: COPY COMMAND in Pl/sql [message #542244 is a reply to message #542223]

Mon, 06 February 2012 01:08

ORA_KRISH
Messages: 38
Registered: March 2011
Location: chennai

Member

Hi, it works thanks for the reply

regards

krish

Report message to a moderator

Previous Topic:	ORA 01555 In Oracle 8i
Next Topic:	Licensing for Oracle Client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 04:08:00 CST 2024