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
[EMAIL PROTECTED]
-----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: [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: MacGregor, Ian A.
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).
