Dropping P6 EPPM Database Objects for Oracle

Contents

If you make a mistake or want to recreate the database objects for the P6 EPPM database:

1. Go to \database\scripts\install\PM_08_03_00 and execute the orpm_drop_users.sql script. This will drop admuser, privuser, pubuser, bgjobuser, and PxRptUser and their objects.
2. Go to \database\scripts\install\PPM_08_03_00 and execute the orppm_drop_users.sql script. This will drop admuser, privuser, pubuser, and bgjobuser, and their objects.
3. Start over at Creating Users and Tables for Oracle.