Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMPDP, after import indexes in destination have a smaller size than in the source

Stefan SmitshoekMay 12 2020 — edited May 12 2020

Hi all,

Today we performed a clone of 1 pdb to another pdb.

pdb1 is the source.

pdb2 is the destination.

After the clone finished we did a check to compare the size of the two pdb's.

What was curious was that we discovered that the indexes imported in pdb2 (from pdbs1) were smaller in size then the exact same indexes in pdb2.

For example index a in pdb1 was 2.8gb, the same index in pdb2 was 1.7gb.

The data in the tables was identical.

I was wondering if someone could explain to me why there is a difference in size.

Comments
Post Details
Added on May 12 2020
1 comment
403 views