OraFAQ Forum: SQL & PL/SQL » Need help in copying CLOB data over DBlink

Home » SQL & PL/SQL » SQL & PL/SQL » Need help in copying CLOB data over DBlink (Oracle 9i on Windows)

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

Need help in copying CLOB data over DBlink [message #315311]

Mon, 21 April 2008 01:10

ak_sunil
Messages: 2
Registered: June 2007
Location: Bangalore

Junior Member

HI,

We have a requirement where in i have to copy the contents of a table over DB link. This table has 6 CLOB fields. i have to copy the data for 0.35 million records. Since it is not possible to copy the CLOB columns directly , i want someone to help me with this. This is a highly critical activity which i need to do asap.

Thanks

Report message to a moderator

Re: Need help in copying CLOB data over DBlink [message #315352 is a reply to message #315311]

Mon, 21 April 2008 04:54

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Quote:

Did I use Google? Even if your question hasn't been answered here, chances are that on other websites someone already has posted an answer.

http://www.orafaq.com/forum/t/88153/0/

Check this link. Atleast it gives you an idea how to do it. How did I find it ? It's very simple. There is a search engine called google and typed exactly your text and in the first page i got the clue what I am looking for. So I believe from next time onwards you will try to utilise the search facility.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:52297289480186

Regards

Raj

[Updated on: Mon, 21 April 2008 04:54]

Report message to a moderator

Re: Need help in copying CLOB data over DBlink [message #315407 is a reply to message #315311]

Mon, 21 April 2008 07:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

ak_sunil wrote on Mon, 21 April 2008 02:10

Since it is not possible to copy the CLOB columns directly , i want someone to help me with this.

Your title says "Need help in copying CLOB data over DBlink", but then you profess that it isn't possible ??

Why are you saying it isn't possible ??

Report message to a moderator

Previous Topic:	rows missing for a date
Next Topic:	Getting Log information in PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 08:45:33 CST 2024