RE: SAP R3 and Locally Managed Tablespaces

I am working with Peoplesoft now. It is easy enough to change tablespace description in Peoplesoft DD to LMT, change tablespace assignment for specific tables etc. I am going soon to implement LMT on 8.1.7 and also move part of insexes to different index tablespace. There is no problems with future upgrade if changes made in the Peoplesoft DD. Also I think that it was done pretty smart - description of objects in Peoplesoft DD and generation of DDL and SQL statements from this DD.

Alex Hillman

-----Original Message-----
Sent: Friday, July 06, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L

Jared,

I can't say that I have used LMT's with our SAP installation, however, I constantly modify storage parameters, and I really don't see a difference. That being said, I know how much of a control-freak SAP is. The problem is that SAP puts tables/indexes in certain tablespaces based on functionality.

For example, the BTABD tablespace contains all transaction, heavy I/O tables, while the STABD tablespace contains all master data and transparent tables, etc. So if you organize LMT's based on size/storage characteristics, you would have to have multiple BTABD, STABD, etc. tablespaces. That would be the only thing I can see SAP being nervous about. In order to do table reorgs, I do this in the sense that I have a BTABD and a BTAB2D tablespace that I reorg the table to/from. Sorry if you already knew all this, but maybe others would benefit.

Jim

>
> In working with our SAP consultant, I've discovered that SAP may not
> yet support the use of LMT's on Oracle. Yes I know that SAP should
> not really care about this, but SAP seems to care about a number of
> things that would be best left to the DBA.
>
> Does anyone have experience with SAP and LMT's?
>
> TIA
>
> Jared
>
>
> --
> 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 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
>

-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
jhawkins_at_memc.com (work)
jhawkins_at_primary.net (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  INET: jhawkins_at_primary.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).