Database Utilities (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center