Hello,

What is the default behaviour of the dependency objects especially triggers when the table is renamed and and imported into a new tablespace.

Let's say I have table called 'ORIG_TABLE'.

I exported the table and renamed the table 'ORIG_TABLE' to 'RENAMED_TABLE'.

Now I imported the table with new storage parameters into a different tablespace. I dropped all the indexes on the renamed table (RENAMED_TABLE) and re-created on the newly imported table which is 'ORIG_TABLE'.

I have two triggers on the renamed table 'RENAMED_TABLE'.

My questions are:

What will be the behaviour of the triggers that were there on the table 'RENAMED_TABLE'. I know they will be invalidated once the table is renamed. But If an action is performed on the newly imported table 'ORIG_TABLE' will Oralce automatically recompile the trigger, validate it and then fire the trigger on the new table or will they reference to the renamed table?

Thanks in Advance.