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
>>> <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
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: [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: Joan Hsieh
> 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: Mike Lanteigne
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:
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).
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3211.1700" name=GENERATOR></HEAD>
<BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV>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.
</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Never had any classes just picked it up. When needed some help, asked
our developers who went to the classes.</DIV>
<DIV> </DIV>
<DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland Regional
Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216)
781-4204<BR><BR>>>> <[EMAIL PROTECTED]> 2/1/01 10:32:17 AM
>>><BR>Mike,<BR><BR> Does PeopleSoft have database
training, Yes. Will it help you with Oracle,<BR>NO WAY IN HELL!.
PeopleSoft uses Sql*Server in their development & training. <BR>They also
don't do anything outside of the PeopleTools suite. Therefore,
for<BR>database sizing, performance tuning, backup & recovery, etc...
Your on your<BR>own. To PeopleSoft a "database" is equal to a schema,
although they don't<BR>really like, but do accept, having more than one schema
inside one database<BR>instance. I do recommend the following PeopleSoft
classes though, PeopleTools I<BR>& II (this is the basic stuff),
Configuration & Administration (configuration<BR>pertains to the Application
server from BEA & the process scheduler), Upgrade &<BR>Data Management
workshop (really gets into the upgrade process which is very<BR>involved).
If possible you should also take a PeopleCode class.<BR><BR>Dick
Goulet<BR><BR>____________________Reply Separator____________________<BR>Author:
"Mike Lanteigne"
<[EMAIL PROTECTED]><BR>Date: 2/1/2001
6:48 AM<BR><BR>Hi Joan,<BR><BR>I'm starting a job soon supporting a database
holding PeopleSoft data, so I<BR>was looking for a heads up on what I should
expect. 'PeopleSoft Training' --<BR>See, I didn't know they had specific
PeopleSoft database training, so that's<BR>good to know.<BR><BR>I'll look at the
places you suggested, Thanks<BR><BR>Mike<BR><BR><BR>----- Original Message
-----<BR>To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]><BR>Sent: Wednesday, January 31, 2001 1:37
PM<BR><BR><BR>> Mike,<BR>><BR>> I do have a lot information. I've been
working for peoplesoft/oracle dba<BR>for<BR>> 2 years and got all the
peoplesoft training. What kind of information you<BR>> want? If you just want
basic information. IOUG has a peoplesoft sig group,<BR>> they have a lot of
papers for all HR and FR. Peoplesoft customer<BR>connection<BR>> has tons of
info for a oracle dba too.<BR>><BR>> Joan<BR>><BR>> -----Original
Message-----<BR>> Lanteigne<BR>> Sent: Wednesday, January 31, 2001 12:21
PM<BR>> To: Multiple recipients of list ORACLE-L<BR>><BR>><BR>>
Hello all,<BR>><BR>> I was wondering if anyone has info or leads in the
particulars of managing<BR>> an Oracle database supporting PeopleSoft. Oracle
version 7.3.<BR>><BR>> Thanks<BR>><BR>>
Mike<BR>><BR>><BR>><BR>><BR>><BR>><BR>> --<BR>> Please
see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com</A><BR>> --<BR>>
Author: Mike Lanteigne<BR>> INET: [EMAIL PROTECTED]<BR>><BR>>
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051<BR>> San Diego, California
-- Public Internet access / Mailing Lists<BR>>
--------------------------------------------------------------------<BR>> To
REMOVE yourself from this mailing list, send an E-Mail message<BR>> to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>> the
message BODY, include a line containing: UNSUB ORACLE-L<BR>> (or the name of
mailing list you want to be removed from). You may<BR>> also send the
HELP command for other information (like subscribing).<BR>><BR>>
--<BR>> Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com</A><BR>> --<BR>>
Author: Joan Hsieh<BR>> INET:
[EMAIL PROTECTED]<BR>><BR>> Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051<BR>>
San Diego, California -- Public
Internet access / Mailing Lists<BR>>
--------------------------------------------------------------------<BR>> To
REMOVE yourself from this mailing list, send an E-Mail message<BR>> to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>> the
message BODY, include a line containing: UNSUB ORACLE-L<BR>> (or the name of
mailing list you want to be removed from). You may<BR>> also send the
HELP command for other information (like subscribing).<BR><BR>-- <BR>Please see
the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author: Mike
Lanteigne<BR> INET: [EMAIL PROTECTED]<BR><BR>Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San
Diego, California -- Public Internet
access / Mailing
Lists<BR>--------------------------------------------------------------------<BR>To
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list
you want to be removed from). You may<BR>also send the HELP command for
other information (like subscribing).<BR>-- <BR>Please see the official ORACLE-L
FAQ: <A href="http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author:
<BR> INET: [EMAIL PROTECTED]<BR><BR>Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San
Diego, California -- Public Internet
access / Mailing
Lists<BR>--------------------------------------------------------------------<BR>To
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list
you want to be removed from). You may<BR>also send the HELP command for
other information (like subscribing).<BR></DIV></BODY></HTML>
