Datadump Import Fails with ORA-65021: illegal use of SHARING clause
Hi,
We have an environment with Application Root Container with 2 Application PDD's. We have taken an export of Application Root Container and trying to import the same in our local environment with a similar structure. While Importing, Table import fails with following Error.
for e.g.
ORA-39083: Object type TABLE:"FCUBSUSR"."CSTM_AWI_TRANSFER_ROUTE" failed to create with error:ORA-65021: illegal use of SHARING clause
We are importing a sys user with Schemas value set. I request some advice on this regard.
Kindly help.