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 <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 11/26/2002 07:54 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > 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: [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: > > 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: Jared Still 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).
