List, Has anybody seen this behavior or know the work around. I am doing a full import into a 9i (9.2.0.1.0) database from an Oracle 8i (8.1.7.4.0) database. The users are not pre-created and anytime it wants to import a user who owns objects it fails and gives:
. importing USER's objects into USER "ALTER SESSION SET CURRENT_SCHEMA= "USER"" IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist IMP-00000: Import terminated unsuccessfully If you stop, manually create the user and assign a default tablespace the import will work until it hits another user who owns objects. I have seen notes on metalink that it might be the user and/or tablespace assignment. Is there a solution for this, besides pre-creating the users in the 9i instance? One note on metalink stated: You will encounter this when using a pre-9.2 dmp file into a 9.2 database. The following should work. 1) import with show=Y log= 2) edit that script and change the tablespaces to an existing tablespace for the create statements 3) pre-create the objects using the above script 4) import with ignore = Y Are you forced to pre-create the users when going from pre-9.2 into 9.2? David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
