Backup primavera p6 oracle database11/26/2023 ![]() Truncating the PX Tables: If looking to truncate the data from the PX Tables, the following scripts can be used:.Clean_Px_Delete Procedure: Use the CLEAN_PX_DELETE stored procedure to purge obsolete entries in the Px tables. ![]() Connect as admuser to perform this activity.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. You can use the following clean up procedure to clear the obsolete entries in the Px tables. ![]() To avoid operational problems for Oracle Primavera P6, Px (extended schema) table entries are not automatically deleted when you delete data from P6 tables.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |