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: [EMAIL PROTECTED]
>
> 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: [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).
>
>
--
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO 633376
9636) 474-7832
[EMAIL PROTECTED] (work)
[EMAIL PROTECTED] (home)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim Hawkins
INET: [EMAIL PROTECTED]
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: [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: Hillman, Alex
INET: [EMAIL PROTECTED]
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: [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).
