problem dump "error IMP-00003 / ORA-01435"

[joe69008]

hi everybody,

I have a problem with a dump base with oracle 9i.

I lauch a dump command and i see this error.

IMP-00003: Error ORACLE 1435 met.
ORA-01435: this users don't exist.

but i have create this users before lauch the dump?

Someone have an idea?

thanks you

Best regards

 

[SantaMufasa]

Joe,

If you are doing a table or schema/user import, then, yes, the user must exist prior to your import.

Let us know if creating the user solves your problem.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[joe69008]

I have create a user before but it always show me this error message.

beside, I have a command dump which was working before but since i have reinstall oracle, it doesn't work.

the command i use for doing the dump is :


SQLPLUS SYSTEM/AIX@ORAAIX @e:\Oracle\Command\Forl.sql

--> forl.sql :
CONNECT SYSTEM/AIX@ORAAIX

CREATE ROLE "RVEGA" NOT IDENTIFIED;
GRANT CREATE ANY SEQUENCE TO "RVEGA";
GRANT CREATE ANY VIEW TO "RVEGA";
GRANT DROP ANY SEQUENCE TO "RVEGA";
GRANT DROP ANY VIEW TO "RVEGA";
GRANT CREATE ANY TABLE TO "RVEGA";
GRANT DROP ANY TABLE TO "RVEGA";
GRANT CREATE ANY INDEX TO "RVEGA";
GRANT DROP ANY INDEX TO "RVEGA";
GRANT CREATE ANY PROCEDURE TO "RVEGA";
GRANT DROP ANY PROCEDURE TO "RVEGA";
GRANT CREATE ANY TRIGGER TO "RVEGA";
GRANT DROP ANY TRIGGER TO "RVEGA";

DROP USER VEGA CASCADE;
CREATE USER VEGA IDENTIFIED BY VEGA;
GRANT CONNECT TO VEGA;
GRANT RVEGA TO VEGA;
ALTER USER VEGA QUOTA UNLIMITED ON SYSTEM;
ALTER USER VEGA QUOTA UNLIMITED ON VEGA_DATA;
ALTER USER VEGA QUOTA UNLIMITED ON VEGA_INDX;
COMMIT;
DISCONNECT;
EXIT

IMP SYSTEM/AIX File=e:\Oracle\Dump\export_db_full_AIX.dmp1 FROMUSER=VEGA TOUSER=VEGA LOG=e:\Oracle\Command\Forl.Log

So i think the user VEGA is created automaticaly.

But when the command is execute, i have this message

Import object VEGA in VEGA
"ALTER SESSION SET CURRENT_SCHEMA= "VEGA""
IMP-00003: Error ORACLE 1435 met
ORA-01435: this users don't exist
IMP-00000: import procedure finish with errors

but when i do ALTER SESSION SET CURRENT_SCHEMA= "VEGA" in pl sql plus, it work.

i wish not be too confuse.

Thanks for you help.

 

[SantaMufasa]

CONNECT SYSTEM/AIX@ORAAIX

Notice that you are qualifying which Oracle alias to use, "ORAAIX", but when you go to import, you say:

IMP SYSTEM/AIX ...

Is the import command attempting to connect to the correct Oracle instance?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[joe69008]

thanks a lot for you help, it was that.
thanks again

best regards
bye