Problems when importing on NT

Hi!

I'm attempting to migrating my database from Unix to NT.

In Unix, my tablespaces are in '/u02/oradata/SID/rbs01.dbf'...
But in NT I've got my DataBase in 'd:\orant\'.

I succeed in export on Unix (I created a 'devexport.dmp' file), but
when trying to import on NT, I get this error:

----//----
Connected to: Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

Export file created by EXPORT:V08.00.04 via conventional path
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "RBS" DATAFILE '/u02/oradata/SID/rbs01.dbf' SIZE 15728640"
" DEFAULT STORAGE (INITIAL 131072 NEXT 131072 MINEXTENTS 2 MAXEXTENTS "
"121 PCTINCREASE 0) ONLINE PERMANENT"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/u02/oradata/SID/rbs01.dbf'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
....
....

Could anybody give any suggestion?

Thank you very much

In the NT DB you have to create tablespaces with the same names as they have in the UNIX DB.

Thank you very much for answering.

+ I create a database on my NT server.

+ I create the tablespaces with THE SAME NAME as the Unix Originals.

create tablespace SAMENAME datafile 'd:\foo\foo.dbf' size
10m autoextend on next 5m maxsize 50m;

+ And d:\foo\foo.dbf ? Must it be the same as Unix?

+ And the size? Must it be similar?

Thank you very much...

try your import with the ignore=y option.

precreate the tablespace and then import objects

wait a sec, Seems like the oracle version on Unix and NT are different. ? Have u checked that up ?

Thank you very much for answering again.

You are right, Unix version is 8.0.4 and NT version is 8.0.5.

Is it VERY important??? Wich are the risks???

AFAIK, export from v 8.0.4 and import into v8.0.5 shouldn't be a problem. As this was a forward progress..

Sam

Hi!

Thank you very much for answering.

Checking my Unix DB, I see:

TablespaceName | Datafile
=====================
NAME /foo/database/wm_eles_.dat
NAME /foo/database/wm_erels_.dat
NAME /foo/database/wm_files_.dat
NAME /foo/database/wm_frels_.dat
NAME /foo/database/wm_infos_.dat

How can I mirror it on my NT box?

create tablespace....

TIA

The export does a logical export and not the physical. So you don't have to worry about file struecture. Instead, go ahead and create the appropriate tablespaces with whatever the file names you like and then do the import with ignore=Y. That would get all your data imported into.

Sam

Check whether you have sufficient space to create the files

regards

Hi guys, I've got another problem.

After doing 'imp80 parfile=mypar.par 2>mylog.log' (including 'ignore=y'), I got this warning, and my NT tables are EMPTY:

----//---------
Export file created by EXPORT:V08.00.04 via conventional path
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('SID.WORLD','HP900"
"0/800-7.0-8.0.0'); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 40:
PLS-00302: component 'QUEUE_IMPORT_CHECK' must be declared
ORA-06550: line 1, column 9:
PL/SQL: Statement ignored
. . importing table "DEF$_AQCALL" 0 rows imported

...

ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
. . importing table "REP$_AUD_COLUMN" 0 rows imported
. . importing table "REP$_COL_GROUP" 0 rows imported

...

About to enable constraints...
Import terminated successfully with warnings.
----------------------//-------------------

Any suggestion?

You need to run the $ORACLE_HOME/rdbms/admin/catrep.sql
to create the necessary replication objects. Then run the import.

Sam