RE: Question for Peoplesoft DBAs

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Mon, 4 Dec 2000 14:07:47 -0500
Message-Id: <10700.123556@fatcity.com>

You are better off doing this through PeopleTools. PeopleSoft keeps its own data dictionary (just seen as regular data tables to Oracle). If you make the change directly through Oracle, the PS data dictionary will be out of sync with the Oracle data dictionary. Under most circumstances, this won't cause any major hassles. However there are some situations (i.e. PS upgrades) where your changes could be lost if the application is not aware of them.

Henry

-----Original Message-----
From: dmeng_at_focal.com [mailto:dmeng_at_focal.com] Sent: Monday, December 04, 2000 12:45 PM To: Multiple recipients of list ORACLE-L Subject: Question for Peoplesoft DBAs

PS DBAs,
I have a real 'dummy-level' question for you: I just took over a new PS database and I noticed some tables already have 51 extents after only a few days. I am trying to increase the next extent size. While I know how to do this in Oracle, I am not sure if this should be done via PeopleTools or via svrmgrl. If I have to use PeopleTools, where do I do that from? What kind of operations can be done via svrmgrl and what can only be done via People Tools?

Dennis Meng
Database Administrator
Focal Communications
847-954-8328

--

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

Author:
INET: dmeng_at_focal.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). Received on Mon Dec 04 2000 - 13:07:47 CST