Home » Other » General » COPY COMMAND in Pl/sql (ORACLE 10G)
COPY COMMAND in Pl/sql [message #542212] Sun, 05 February 2012 23:15 Go to next message
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
Re: COPY COMMAND in Pl/sql [message #542215 is a reply to message #542212] Sun, 05 February 2012 23:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
expdp & impdp
Re: COPY COMMAND in Pl/sql [message #542223 is a reply to message #542212] Mon, 06 February 2012 00:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or directly impdp with network_link option.

Regards
Michelt
Re: COPY COMMAND in Pl/sql [message #542242 is a reply to message #542215] Mon, 06 February 2012 01:01 Go to previous messageGo to next message
ORA_KRISH
Messages: 38
Registered: March 2011
Location: chennai
Member
great thanks for the reply, it works

regards

krish
Re: COPY COMMAND in Pl/sql [message #542244 is a reply to message #542223] Mon, 06 February 2012 01:08 Go to previous message
ORA_KRISH
Messages: 38
Registered: March 2011
Location: chennai
Member
Hi, it works thanks for the reply


regards

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


Current Time: Fri Mar 29 10:18:59 CDT 2024