RE: SAP R3 and Locally Managed Tablespaces

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Fri, 06 Jul 2001 16:19:16 -0700
Message-ID: <F001.00343AD9.20010706163044@fatcity.com>

I don't know how SAP performs schema changes. If you alter a table in Peoplesoft, a copy is made of that table, the original table is dropped, a new table with the original name is made, the new table is populated from the copy, and the copy is dropped. If the copy is a "permanent" vs. a "temporary" table as defined by Oracle and if the copy is created in the temporary tablespace then that tablespace cannot be locally managed.

In order to have a locally managed temporary tabnlespace you need to "create temporary tablespace", but if you do that, you cannot create any permanent objects in that tablespace. There may be other restrictions as well.

When you move to 8i beware of indexes which have columns sorted in descending order. These are implemented as Function Based Indexes in 8i. You can tell whether an index has a descending column through dba_ind_columns, but for these columns the column name in that table looks like SYS_NC00021$ you need to use dba_ind_expressions to figger the real name of the column.
Anyway they don't work right until 8.1.7.1. Even with 8.1.7.1 you need to grant "query rewrite".

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
Sent: Friday, July 06, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------