PeopleSoft - PeopleTools tables and the system catalog posted by
Babu Kunwar
What is the relationship between PeopleTools tables and the system catalog in
Oracle?
In PeopleSoft database PSVIEWTEXT and in Oracle Database DBA_Views is similar as
both of them is used to perform the same function. It shows per row view.
In PeopleSoft database PSKEYDEFN and in Oracle Database DBA_IND_COLUMN is having
the same function i.e.: one row per column in INDEX.
In PeopleSoft database PSRECFIELD and in Oracle Database DBA_TAB_COLUMN is used
for per column in table or in view.
In PeopleSoft database PSERCDEFN and in Oracle Database DBA_TABLES is used for
per row table or view in database.
Integrating the valid used authentication: In PeopleSoft database PSOPRDEFN and
in Oracle Database DBA_USERS.
|
