Re: Re[2]: People Soft dba info

I have been supporting Peoplesoft for 5 years now. Like Dick says, it is NOT written for Oracle and does not use constraints, packages, etc.

It has its own data dictionary which it uses when altering tables. I wrote SQL to repopulate the Peoplesoft dictionary with sizing from the catalog.

Never had any classes just picked it up. When needed some help, asked our developers who went to the classes.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

>>> <dgoulet_at_vicr.com> 2/1/01 10:32:17 AM >>>
Mike,

    Does PeopleSoft have database training, Yes. Will it help you with Oracle, NO WAY IN HELL!. PeopleSoft uses Sql*Server in their development & training. They also don't do anything outside of the PeopleTools suite. Therefore, for database sizing, performance tuning, backup & recovery, etc... Your on your own. To PeopleSoft a "database" is equal to a schema, although they don't really like, but do accept, having more than one schema inside one database instance. I do recommend the following PeopleSoft classes though, PeopleTools I & II (this is the basic stuff), Configuration & Administration (configuration pertains to the Application server from BEA & the process scheduler), Upgrade & Data Management workshop (really gets into the upgrade process which is very involved). If possible you should also take a PeopleCode class.

Dick Goulet

____________________Reply Separator____________________
Author: "Mike Lanteigne" <mikel_at_shec.com>
Date:       2/1/2001 6:48 AM

Hi Joan,

I'm starting a job soon supporting a database holding PeopleSoft data, so I was looking for a heads up on what I should expect. 'PeopleSoft Training' -- See, I didn't know they had specific PeopleSoft database training, so that's good to know.

I'll look at the places you suggested, Thanks

Mike

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 31, 2001 1:37 PM

> Mike,
>
> I do have a lot information. I've been working for peoplesoft/oracle dba
for
> 2 years and got all the peoplesoft training. What kind of information you
> want? If you just want basic information. IOUG has a peoplesoft sig group,
> they have a lot of papers for all HR and FR. Peoplesoft customer
connection
> has tons of info for a oracle dba too.
>
> Joan
>
> -----Original Message-----
> Lanteigne
> Sent: Wednesday, January 31, 2001 12:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello all,
>
> I was wondering if anyone has info or leads in the particulars of managing
> an Oracle database supporting PeopleSoft. Oracle version 7.3.
>
> Thanks
>
> Mike
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mike Lanteigne
> INET: mikel_at_shec.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: Joan Hsieh
> INET: Joan.Hsieh_at_mirror-image.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: Mike Lanteigne
  INET: mikel_at_shec.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: 
  INET: dgoulet_at_vicr.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).