Re: Problems when importing on NT

"Ernesto" <ernesto.moreno_at_POR_FAVOR_NO_SPAM_katamail.com> wrote in message news:3ba0cdc7.683928417_at_news.sarenet.es...
> 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?
>

Yes: manually create the relevant tablespaces yourself, and then try importing. Import will not attempt to re-create the tablespaces with their hard-coded unix paths, and will instead get on with the business of creating tables and inserting data into them.

Provided the *tablespace* names are identical across the different platforms, Import won't give a damn about where physically the associated data files are stored.

Regards
HJR
> Thank you very much
>
> MIRELLO
Received on Thu Sep 13 2001 - 15:25:58 CDT