Dropping P6 Professional Database Objects
Manual Oracle Database Configuration > Manual Oracle Database Configuration Overview > Creating the Database Structure for Oracle and Loading Application Data
If you make a mistake or want to recreate the database objects for the P6 Professional database:
- Go to \database\scripts\install\PPM_<release_level> and run the orppm_drop_users.sql script. This will drop admuser, privuser, pubuser, and bgjobuser, and their objects.
- Start over at Creating Users and Tables.
Related Topics
Creating the Database Structure for Oracle and Loading Application Data
Creating the P6 Professional Database Structure
Last Published Tuesday, December 12, 2023