Dropping P6 EPPM Database Objects for Oracle

You can drop the P6 EPPM database objects from your database if you make a mistake during database setup or want to recreate your database structure.

To drop the database objects for the P6 EPPM database:

  1. Go to \database\scripts\install\PM_<release_level> and run the orpm_drop_users.sql script. This will drop admuser, privuser, pubuser, bgjobuser, and PxRptUser and their objects.
  2. Start over at Creating Users and Tables for Oracle.

Related Topics

Creating the Database Structure for Oracle and Loading Application Data

Creating the P6 EPPM Database Structure for Oracle


Last Published Tuesday, November 28, 2023