hi all i installed oracle xe on a Windows Xp machine, asked me for a password and i typed: 123
then i have a backup filenamed myback.dmp and imported:
imp 'sys/123 AS SYSDBA' file=myback.dmp full=yes log=implog.log
sample messages: when importing
==============================================================================================================
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER ON "FIERROS" TO "CAPTURA_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CAPTURA_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DELETE ON "FIERROS" TO "CAPTURA_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CAPTURA_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT INSERT ON "FIERROS" TO "CAPTURA_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'CAPTURA_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER ON "FIERROS" TO "SELENE""
ORA-01917: user or role 'PASES_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ON COMMIT REFRESH ON "MUNICIPIOS" TO "PASES_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PASES_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT QUERY REWRITE ON "MUNICIPIOS" TO "PASES_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PASES_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "MUNICIPIOS" TO "PASES_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PASES_FIERROS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UPDATE ON "MUNICIPIOS" TO "PASES_FIERROS""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PASES_FIERROS' does not exist
About to enable constraints...
Import terminated successfully with warnings.
==============================================================================================================
then i ask:
1) how to fix the messages similar to:
ORA-01917: user or role 'PASES_FIERROS' does not exist
ORA-01917: user or role 'CAPTURA_FIERROS' does not exist
any advice?
thanks