Why Does The Primary Key Constraint lands in Defalut Tablespace After Import?
Hi,
We have recently moved a schema from Oracle 18x 12.x (Standard Edition) to 19.x Container Database (Pdb) using Expdp and Impdp.
Sorry for I need to correct my DB versions... 12.2.0.1 exact Bundle WINDOWS DB BUNDLE PATCH 12.2.0.1.190416(64bit):29394003
In our source database (18.x 12.x SE) all table index were defined in a separate Tablespace.
But after Import in 19.x (EE) all primary key are in a users Default Tablespace. And rest Indexes are imported in other tablespace like it was defined previously.
Have you ever noticed this kind of phenomenal?
Is there any Explanation for this ?
How we can impose Expdp and Impdp to create Primary key as in the original defined Tablespace?