To see this working, head to your live site.

IMPDP different schemas

in Oracle Database Administration

I tried to impdp different schema from 10g to 19c using remap schema but trigger is not import show me a below error.

ORA-39083: Object type TRIGGER:"OPPICS_USR"."JO_NRS_FAILURE_LOG_TGR" failed to create with error:

ORA-00942: table or view does not exist

a table is imported but trigger is not import

2 answers7 replies

9 Comments

Ublut

May 31, 2022

Could you share the parameterization used in impdp and expdp ?

Ublut

Jun 01, 2022

Replying to

I'm meaning probably the PL/SQL inside the trigger code it's mentioning some table/view with old schema

nallamki

Jun 02, 2022

Replying to

@Ublut thats means while creating table should not mention schema name ?

Ublut

Jun 03, 2022

Replying to

@nallamki When you implement a trigger don't put schema on the tables name mentioned in the trigger if these tables belong to the same schema of trigger!

Ublut

May 31, 2022

Hi nallamki,

do you exported the table on which it's implemented this trigger ?

nallamki

May 31, 2022

Replying to

yes

nallamki

May 31, 2022

Replying to

all tables related to trigger are exported and imported excepted trigger