Hallo
i make export and import of Oracle8i and get one of my trigger invalid in the imported database. During the import process the trigger was compiled but with warnings (IMP-00041):
PLS-00201: Identifier 'xxxsequence' muss be declared
xxxtrigger TRIGGER 2 18 4
PL/SQL: SQL Statement ignored

I make a select of this xxxsequence in the trigger. The user that makes the import has all rights for xxxsequence. I think that it may be occurs because of the import order:
first compile the trigger than the sequence...

My question: do you know that problem? Is there may another explaination? Or can I turn the import order in some way?

Thank you for any help

ip