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: Yechiel Adar 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).
