How to do primavera p6 database export (large schema size)

 

Primavera_P6_Database_export How to do primavera p6 database export (Large schema size)

 

 

This section I have explained how to Primavera P6 database export using Oracle data pump utility.  This section is to export larger DB  size. Exporting larger DB takes more time and it export Stat and other data that we don’t need.  I enabled compression and parallel processing On, so the output database dump will be of lesser size and time it takes to export will be less. This is the better option if your database is large. 

 

Note: This Compression and Parallel Options are available only on Oracle Database Enterprise  Editon. Consider the below link if you have Oracle Standard Edition or personal edition:

 

How to export and import Primavera P6 database using Oracle data pump utility

 

Database: Oracle 

 

Export the database: 

 

  • Login as SYSDBA and issue the following command 

 

 

 

  • Exit the SQL Plus and issue the following query 

 

 

 

Import the Oracle Primavera P6 Database: 

 

  • Login as SYSDBA and issue the following command 

 

 

  • Place the database dump files in the directory mentioned above (c:\importdump)   so that import script will pick those dump files from that directory 
  • Go to <P6_HOME>\database\scripts\install\PM_<VERSION> and run the following files . These scripts creates table spaces, users, and grants. 

 

  • Exit the SQL Plus and issue the following query 

 

 

Check for database schema for any invalid DB Objects: 

 

Once you imported the database schemas. Check for any invalid DB objects 

 

  • Login in Oracle database as sys dba 

 

  • Run the below query for invalid database objects and run the output 

 

 

govindan How to do primavera p6 database export (Large schema size)
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
govindan How to do primavera p6 database export (Large schema size)
Connect me
By | 2017-08-09T10:02:09+00:00 April 21st, 2017|Categories: P6|Tags: , |0 Comments
Like us on Facebook.
Connect!