The practice shows how to use index compression on import operations.
Before starting any new practice, refer to the Practices Environment recommendations.
Step 1 : Set up the environment
HRschema. Change the password string in the command to your password.
Verify that the
HR.EMPLOYEEStable is not using compression and owns indexes that are not using compression.
Create a directory for Oracle Data Pump dumpfiles.
Step 2 : Export the table
HR.EMPLOYEEStable. Ignore any Database Vault warning.
Step 3 : Import the table using the compression parameters
Drop the table in
Import the table using the index compression and the table compression parameters.
Verify that the imported table is using compression and that its indexes also use compression.
Why is the primary key index not compressed?