Hello,
I need to replicate an Oracle 9i database installed on Unix enviroment to an Oracle 10 XE installed in a Windows xp enviroment. I have installed the Oracle XE version correctly int the xp machine.
Then I try to do this:
imp system/systempwd full=y data=mydata.dmp log=import.log
but I have the following problems:
...
IMP-00017: la siguiente sentencia ha fallado con el error 1119 de ORACLE :
"CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE '/opt/oracle/ora"
"data/IVOTIN/undotbs01.dbf' SIZE 1240M AUTOEXTEND ON NEXT 5242880 MAX"
"SIZE 32767M EXTENT MANAGEMENT LOCAL "
IMP-00003: se ha encontrado un error 1119 de ORACLE
ORA-01119: error al crear el archivo de base de datos '/opt/oracle/oradata/IVOTIN/undotbs01.dbf'
ORA-27040: error de creación de archivo, no se ha podido crear
OSD-04002: no se ha podido abrir el archivo
O/S-Error: (OS 3) El sistema no puede hallar la ruta especificada.
IMP-00015: la siguiente sentencia ha fallado porque el objeto ya existe:
"CREATE TABLESPACE "SYSAUX" BLOCKSIZE 8192 DATAFILE '/opt/oracle/oradata/IV"
"OTIN/sysaux01.dbf' SIZE 513802240 AUTOEXTEND ON NEXT 10485760 MAXSIZ"
"E 32767M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT S"
"PACE MANAGEMENT AUTO"
...
Logs are in spanish, but I hope you can understand them with error numbers. Basically, the system cannot find paths for creating datafiles and cannot create objects because they still exist...
I hope you can help me.
Thank you very much and excuse my bad english.
Regards