U can use To_LOB(long_col) to convert long to
Clob/BLOB.
OraCop
- VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> 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: ORACLE-L_at_fatcity.com
> Cc: HANDM_at_polaroid.com
>
>
> 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" <HANDM_at_polaroid.com>
> Sent by: root_at_fatcity.com
> 11/25/2002 07:59 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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: HANDM_at_polaroid.com
>
> 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: ListGuru_at_fatcity.com (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: VIVEK_SHARMA_at_infosys.com
>
> 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: ListGuru_at_fatcity.com (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: oracop_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Nov 26 2002 - 12:17:02 CST
