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

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 Go to previous messageGo to next message
BlackSwan
Messages: 26757
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...
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 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

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 17 14:01:49 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.