My Oracle Support Banner

Agile Database Schema Dmp Filesize Gets Smaller After Import and Export (Doc ID 2768294.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Goal

Imported and exported Agile database schema using the standard utility, and see the dmp file size is smaller than the one which was imported even though the import and export looks successful.
What is the reason of this, and is there any impact?

Here is the steps performed:
1. From %ORACLE_BASE%\admin\{SID}\create, run recreateagile utility to refresh Agile database schema
2. Import agile database schema dmp file using agile9impdp utility
3. Import completes
4. Run agile9_check.sql, and confirm there are no ERROR reported
5. Run agile9expdp to export the Agile database schema to dmp file
6. Compare the dmp file size between the dmp imported in step 2 and dmp exported in step 5. The file size of the exported dmp file is smaller than the imported dmp file

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.