RE: CLOB to a CLOB- need help.

RE: CLOB to a CLOB- need help.

 

  


ThankYou!!!! Edward, John. Appreciate your pointers very much.

John, looks like if you create table without referencing the lob column it will work. I haven't tried it as my table is huge. But, I am going to use the export/import options because I can use plsql with it as I have logic to implement to discard some old data and manipulate some old data. I cannot create a copy of the old table as users enter rows into the old system realtime.

This is what I am going to do-
create a cursor that gets all the old table rows, process each row as per logic needed, determine row to transfer to the new database, then use export import option to export the old clob column data into a file and then import it back into the new clob column.

Excellent! ThankYou! All.

Regards,
Manasa.


-----Original Message-----
>From: Edwards Ed <oracledba-ezmlmshield-x99249430.[Email address protected]
>Sent: Feb 27, 2006 12:22 PM
>To: LazyDBA Discussion <[Email address protected]
>Subject: RE: CLOB to a CLOB- need help.
>
>Below is the info I received from John Reynolds.
>
>I can't reply to the whole group, but I've used this for over a year.
>If you don't explicitly refer to the lob, it will transfer it to via a
>dblink.
>
>insert into [Email address protected]
> select * from electronicdatadeliverable
>
>Thanks,
> John R.
>
>
>
>
>
>
>
>-----Original Message-----
>From: Edwards Ed
>[mailto:oracledba-ezmlmshield-x98271412.[Email address protected]
>Sent: Monday, February 27, 2006 12:21 PM
>To: LazyDBA Discussion
>Subject: RE: CLOB to a CLOB- need help.
>
>
>
>
>
>
>http://www.oracle-base.com/articles/8i/ExportClob.php
>
>
>
>http://www.oracle-base.com/articles/8i/ImportClob.php
>
>
>
>-----Original Message-----
>From: Manasa
>[mailto:oracledba-ezmlmshield-x69643258.[Email address protected]
>Sent: Monday, February 27, 2006 11:59 AM
>To: LazyDBA Discussion
>Subject: RE: CLOB to a CLOB- need help.
>
>
>Hi,
>
>I tried to create a materialized view. And I get the following error-
>
>ORA-22992: cannot use LOB locators selected from remote tables
>
>My confusion about lob locators came true. My biggest doubt was lob locator is sort of like a reference to the actual data in the database. So, how could we copy that locator value from one database to another?
>
>May be I am totally off here.
>
>Thanks,
>Radhika.
>
>
>-----Original Message-----
>>From: Edwards Ed <oracledba-ezmlmshield-x46779964.[Email address protected]
>>Sent: Feb 27, 2006 11:40 AM
>>To: LazyDBA Discussion <[Email address protected]
>>Subject: RE: CLOB to a CLOB- need help.
>>
>>I would get the data over to the applicable database and then do my manipulations.
>>
>>
>>-----Original Message-----
>>From: Manasa
>>[mailto:oracledba-ezmlmshield-x91701069.[Email address protected]
>>Sent: Monday, February 27, 2006 11:37 AM
>>To: LazyDBA Discussion
>>Subject: RE: CLOB to a CLOB- need help.
>>
>>
>>Edward,
>>No- As I have to use plsql as I have to do some manipulations to other columns in the same table. Depending on those I need to get only those rows.
>>Thanks,
>>Manasa.
>>
>>
>>-----Original Message-----
>>>From: Edwards Ed <oracledba-ezmlmshield-x83430647.[Email address protected]
>>>Sent: Feb 27, 2006 11:29 AM
>>>To: LazyDBA Discussion <[Email address protected]
>>>Subject: RE: CLOB to a CLOB- need help.
>>>
>>>Manasa,
>>> Will an export do it?
>>>
>>>
>>>-----Original Message-----
>>>From: Manasa
>>>[mailto:oracledba-ezmlmshield-x38430380.[Email address protected]
>>>Sent: Monday, February 27, 2006 10:52 AM
>>>To: LazyDBA Discussion
>>>Subject: CLOB to a CLOB- need help.
>>>
>>>
>>>Does anybody have a code sample on how to copy a clob column from one database to another datbase.
>>>
>>>ThankYou!
>>>Manasa.
>>>
>>>
>>>--------
>>>website: http://www.LazyDBA.com
>>>Please don't reply to RTFM questions
>>>Oracle documentation is here: http://tahiti.oracle.com
>>>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>>>To subscribe: see http://www.lazydba.com
>>>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>>>
>>>
>>>Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
>>>
>>>
>>>http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
>>>
>>>
>>>--------
>>>website: http://www.LazyDBA.com
>>>Please don't reply to RTFM questions
>>>Oracle documentation is here: http://tahiti.oracle.com
>>>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>>>To subscribe: see http://www.lazydba.com
>>>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>>>
>>
>>
>>
>>--------
>>website: http://www.LazyDBA.com
>>Please don't reply to RTFM questions
>>Oracle documentation is here: http://tahiti.oracle.com
>>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>>To subscribe: see http://www.lazydba.com
>>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>>
>>
>>--------
>>website: http://www.LazyDBA.com
>>Please don't reply to RTFM questions
>>Oracle documentation is here: http://tahiti.oracle.com
>>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>>To subscribe: see http://www.lazydba.com
>>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>>
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page