-
Problem with Import of Trigger and Sequence Oracle8i
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|