How To Separate The Content Repository Schema And Project Management Schema From A Single Database (Doc ID 1086475.1)

Last updated on JUNE 30, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version: 6.2 to 7.0 - Release: 6.2 to 7.0
Information in this document applies to any platform.

Goal

How to separate a Content Repository Schema and Project Management Schema from a single database.

Prior to running any script below, a backup of the database should be made. If you are unsure how to back up your database, do not proceed with the execution of any script. Contact your database administrator, your database vendor, or refer to one of the following solutions for assistance in backing up your database before executing any of the scripts:
  • If using an Oracle Database: <Document 907089.1>
  • If using a SQL Database: <Document 905825.1>
Also, ensure that you are familiar with the process of restoring the backup copy of the database in case you need to do so.

For execution of any script below, the following is recommended:

For Oracle:
Log into the instance using SQLPlus or equivalent with the administrative user for the schema (for example: admuser)

For SQL Server 2005 or SQL Express:
Launch SQL Server Management Studio and login with SQL Authentication as SA

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms