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



Legal Notices | Your Privacy Rights
Copyright © 1999, 2023

Last Published Thursday, January 12, 2023