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?
>
> Thank you very much
>
> MIRELLO
You need to precreate your tablespaces.
Run imp with full=y show=y log=<any filename>, copy and paste the create tablespace statements from <any filename> etc.

FYI 8.0.5 has been desupported

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 13 2001 - 10:53:41 CDT