U can use To_LOB(long_col) to convert long to Clob/BLOB. OraCop
--- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > > How may LONG , LON RAW be Converted to CLOB or LOB ? > Which is Better ? > > Thanks > > -----Original Message----- > Sent: Tuesday, November 26, 2002 9:24 PM > To: Multiple recipients of list ORACLE-L > > > > Thanks all for the suggestions. I think I'll take a > look at COPY and the > PL/SQL options since I've used them before, and C & > Perl are not in my > repertoire, I'm ashamed to say ;) To shed a little > more light on the > requirement, I'm researching the best (subjective) > way to convert > dictionsry-managed TS's to locally-managed in an > 8.1.7.3, Tru64 hosted DB > running SAP R/3. The convert-in-place procedure > [dbms_space_admin.tablespace_migrate_to_local] does > not change extent > management for the segment. > > Jared, I'd consider converting them, but SAP is a > little posessive of their > Clusters/Pools. > > Mike H. > > -----Original Message----- > Sent: Monday, November 25, 2002 6:39 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > > > Mike, > > Conner pointed out that you could use C. > > You can also use Perl with DBI and DBD::Oracle if > you like, and have > someone there that can use it. > > Why not just convert them to CLOB and LOB? > > Jared > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/25/2002 07:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: LONG's > > > OK, so you can't CTAS on tables with LONG or LONG > RAW columns, and now I > find out that the same restriction exists on Alter > Table ... Move. So, > is there any other option to move these tables from > one tablespace to > another without exp/imp or converting them to LOB? > > Thanks, > Mike > > This transmission is intended only for use by the > addressee(s) named > herein and may contain information that is > proprietary, confidential > and/or legally privileged. If you are not the > intended recipient, you are > hereby notified that any disclosure, copying, > distribution, or use of the > information contained herein (including any reliance > thereon) is STRICTLY > PROHIBITED. If you received this transmission in > error, please immediately > contact the sender and destroy the material in its > entirety, whether in > electronic or hard copy format. Thank you. > > > > +******+ > This transmission is intended only for use by the > addressee(s) named herein and may contain > information that is proprietary, confidential and/or > legally privileged. If you are not the intended > recipient, you are hereby notified that any > disclosure, copying, distribution, or use of the > information contained herein (including any reliance > thereon) is STRICTLY PROHIBITED. If you received > this transmission in error, please immediately > contact the sender and destroy the material in its > entirety, whether in electronic or hard copy format. > Thank you. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hand, Michael T > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
