In this case what happens to the lob locators. Will it create new lob locators in the new database the table is copied to?
-----Original Message-----
>From: Avinoam Gabay <oracledba-ezmlmshield-x41507856.[Email address protected]
>Sent: Feb 27, 2006 11:36 AM
>To: LazyDBA Discussion <[Email address protected]
>Subject: RE: CLOB to a CLOB- need help.
>
>you can copy by
>create table as select
>via Db Link.
>but you cant do any operation on the remote clob
>
>Avinoam
>Discount Bank Ltd
>
>
>________________________________
>
>מאת: Edwards Ed [mailto:oracledba-ezmlmshield-x83430647.[Email address protected]
>נשלח: ב 27/02/2006 18:29
>אל: LazyDBA Discussion
>נושא: 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
>
>
>
>**********************************************************************************************
>IMPORTANT: The contents of this email and any attachments are confidential. They are intended for the
>named recipient(s) only.
>If you have received this email in error, please notify the system manager or the sender immediately and do
>not disclose the contents to anyone or make copies thereof.
>*** eSafe scanned this email for viruses, vandals, and malicious content. ***
>**********************************************************************************************
>
>
>--------
>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