Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: LONG's

Re: LONG's

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 28 Nov 2002 16:43:37 -0800
Message-ID: <F001.0050EC20.20021128164337@fatcity.com>

Imagine 5 tables, all with the same 4 column concatenated primary key. Yes, it gets ugly early.

Now, create a table with those 4 columns, and one additional column, which happens to be a LONG RAW.

Take all of the data for each table, *except* for the Pk columns, compress it with some unknown algorithm, and stuff it all into the single LONG RAW column. Do this for all 5 tables.

There you have it, a performance sucking, impossible to get at, pile of barnyard droppings.

You *can* get at the data, but only through ABAP, SAP's own version of COBOL.

Fortunately, most tables are not stored this way.

Unfortunately, the one you really need usually is.

Take a look at the SAPR3.RFBLG table.

Re your install: You *will* need SAP consultants.

If you are a DBA, they *will* assume you are an evil entity and do everything they can to circumvent you.

They *will* know a lot about SAP, but not nearly as much about Oracle as they think they do.

Jared

On Thursday 28 November 2002 07:28, Yechiel Adar wrote:
> 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: Jared Still
  INET: jkstill_at_cybcon.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 Thu Nov 28 2002 - 18:43:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US