Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
invalid identifier errors in oracle 10g import
8 views
Skip to first unread message
marty.o...@intergraph.com
Mar 15, 2007, 10:02:12 AM3/15/07
to
I have an application that uses oracle 9i. I have to upgrade this
application to a new version and it will use oracle 10g. This newer
version of my app makes changes to the schema, i.e. I have tables that
have added new columns that were not in the oracle 9i database.
So, I need to import the data from oracle 9i into the oracle 10g db.
After my app loaded, the oracle 10g db user is there and the schema
for the application is there. I am trying to pump the 9i data into
it. I used the imp tool with ignore=y. Some of the data got in
there. But, I'm getting lots of OAR-00904 errors, 'invalid
identifier'. It claims that 'BCEXPORTSTATUS' is an invalid
identifier?? There are numerous different words it claims are invalid
identifiers. I can import the 9i data into a new and clean user that
I create, I just can't import it into a users space that already has
the schema there. Any ideas what I need to do here?
application to a new version and it will use oracle 10g. This newer
version of my app makes changes to the schema, i.e. I have tables that
have added new columns that were not in the oracle 9i database.
So, I need to import the data from oracle 9i into the oracle 10g db.
After my app loaded, the oracle 10g db user is there and the schema
for the application is there. I am trying to pump the 9i data into
it. I used the imp tool with ignore=y. Some of the data got in
there. But, I'm getting lots of OAR-00904 errors, 'invalid
identifier'. It claims that 'BCEXPORTSTATUS' is an invalid
identifier?? There are numerous different words it claims are invalid
identifiers. I can import the 9i data into a new and clean user that
I create, I just can't import it into a users space that already has
the schema there. Any ideas what I need to do here?
0 new messages