Re: Question for Peoplesoft DBAs

Dennis,

If you change it through peopleTools, then it will effect all the new scripts for creating tables.
Go to peopletools -> utility -> use -> ddl model defaults -> you will see a panal choose platform id =2 (means oracle database)-> click ok -> change next parameter there.

If you just want change one table definition, just change it through oracle. but keep in mind, everything you changed in oracle not through peoplesoft, you will lost all the changes after you do ps upgrade.

dmeng_at_focal.com wrote:
>
> 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:50:17 CST