Skip to main content
Product:
Oracle Primavera P6

PX Tables Clean Up Procedure

To avoid operational problems for Oracle Primavera P6, Px (extended schema) table entries are not automatically deleted when you delete data from P6 tables.

You can use the following clean up procedure to clear the obsolete entries in the Px tables. This does not pose any data issues as users will be looking at the data through the Px views which are joins from the PMDB and the Px tables, therefore if the data is not in the PMDB it will not show in the Px views and consequently the enterprise report.

  1. Connect as admuser to perform this activity
  2. Clean_Px_Delete Procedure: Use the CLEAN_PX_DELETE stored procedure to purge obsolete entries in the Px tables
  3. Truncating the PX Tables: If looking to truncate the data from the PX Tables, the following scripts can be used:
    • If using an Oracle RDBMS:
      • Browse to the following location on the Database media:
        • If r8.2, \P6_R82\p6suite\database\scripts\install\PM_08_02_00
      • Run the following script: orpm_trunc_px_tables.sql
  4. After completing the above steps, publication services must be run for data to be accessible for PX reporting.

What Our Clients Say

"Beth is absolutely wonderful to work with! I appreciate her patience and professionalism. It’s a relief to know I can count on her to respond and be a life line for us as we continue to learn the system. She is truly top notch."

Eastbound Mechanical

"I wanted to let you know Dan did a great job. He has a vast amount of knowledge, and I feel very fortunate to be working with him."

H.F. (Mechanical Contractor)

"We appreciate Tim and all of his excellent support."

M.J. (Manufacturing Firm)

"Kristen is a very valuable resource for us!"

LCI-Lineberger Construction Inc.

"I want to let you know how grateful we are for Robert Pacheco’s assistance. He was able to meet with me and discuss the issue promptly and complete the fix within a short amount of time. He is surely an asset, and we are thankful to have such a great resource."

Marques General Engineering, Inc.

"Greg is terrific, and I’m so excited to have a better resource! I have him working on several projects now with many more to come."

Progressive Plumbing

"Michael and Matthew have exceeded my needs and expectations. I get help same day 95% of the time, which is very important in my business at times. They are professional and courteous 100% of the time. Zero complaints."

Mitchell Brothers

"It’s a pleasure working with Robert. He's very patient, knowledgeable and goes far beyond to help with any issues we have as a company or as an individual."

HL Contractors

"The level of service CDP provides is exceptional and always far exceeded my expectations. You can quote me on that!"

The Wesson Group LLC

"He did a great job online and an equally great job in person. We’re enjoying working with our new Spectrum Viewpoint accounting software."

Chambliss & Rabil Contractors, Inc.

"Thank you for your assistance/responsiveness to assist us in getting P6 back online so quickly today. We appreciate all the support you provide."

M.J. (Manufacturing Firm)