Doubts

[ale2006]

Environment Information: Oracle 9i
* version of Oracle: 9.1.2
* Operating system: Win2003

Personal, good morning.
I received a dump to matter, but. There are several files, eg:

Select all

Dump001.dmp 
Dump002.dmp 
Dump003.dmp

How do I import?
Should I use Usuario SYS or System?

I did so, but it did not work:

Select all

imp SYSTEM/SENHA@PROD.LOCAL.COM.BR file=c:\DUMP\DUMP001.dmp log=impbanco.log ignore=y full=y

appeared the following error message:

Select all

IMP-00058: Erro Oracle: 1045 encontrado 
ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon deniedNome do usuário: 
Senha:

Any help will be very useful.
Thanks.
Stay with God !!!

[ale2006]

I noticed that if I gave a Grant Create Session to System, this error stopped happening, but accused the invalid export file dump:
Observer:

Select all

IMP-00010: não é um arquivo de exportação válido; falha na verificação do cabeçalho 
IMP-00000: Importação encerrada com êxito 

[elidias7]

Good afternoon.

You can carry out the following checks.

* DMP was created in the same version where are you trying to realize, for example 10g for 10g?
For it may be that he was created in a 10G version and you are trying to import at 9i.

* DMP was created by EXPORT or DATA PUMP?

* The way this DMP was divided, you will need to put everyone at the time of importing with all these files



Anything poses aí

Hugs,

[ale2006]

Good afternoon Eli.

So, I verified that the export was generated at 10G and I was making Imp Pro 9i.
I installed 10g, I import and started working, but I'm now receiving an error ORA000001: UNIQUE CONSTRAINT VIOLATED.

I do not understand why this mistake, my bank was completely Empty, all data should be imported .....

You could tell me the porque of this error:
Thank you !!!!

[elidias7]

Speak Ale!

Are you doing the import full?

places the parameters ignore=y

Hugs,