O'Reilly logo

PeopleSoft for the Oracle DBA by David Kurtz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

C H A P T E R  6

PeopleSoft DDL

So far, I have described how the PeopleSoft and Oracle data dictionaries are related, and how the specification of keys on PeopleSoft records controls both the SQL that is generated by the panel processor and the indexes that are built.

This chapter describes how Application Designer dynamically builds DDL statements, and in particular where some of the physical attributes are defined and how these models can be enhanced to handle some, but not all, Oracle features. This chapter also covers additional PeopleTools tables that correspond to parts of the Oracle data dictionary.

PeopleSoft DDL and the DBA

DBAs usually have a range of responsibilities, including managing growth and change (capacity planning) and performance ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required