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

Last updated on JANUARY 24, 2024

Applies to:

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

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