Re: LONG's

Can you explain a little about SAP cluster/pool? They are going to put SAP in our system and anything I can learn beforehand will be welcome.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 26, 2002 7:42 PM

> Ah, I missed that it was SAP.
>
> Yeah, they don't like you mucking about with their schema.
>
> I would like to see their cluster/pools go *away*!
>
> They are a major pain at times.
>
> Jared
>
>
>
>
>
> "Hand, Michael T" <HANDM_at_polaroid.com>
> Sent by: root_at_fatcity.com
> 11/26/2002 07:54 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: LONG's
>
>
>
> 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:
> INET: Jared.Still_at_radisys.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: Yechiel Adar
  INET: adar76_at_inter.net.il

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).