Re: Problems when importing on NT

pre-create the tablespaces ( use the same name for the tablespace but you can use any name(s) for the data files ) on the NT box before importing..Import will try to recreate the tablespaces if they do not exist, and, obviously, your NT directory structure is quite different...

ernesto.moreno_at_POR_FAVOR_NO_SPAM_katamail.com (Ernesto) wrote:

>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
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Thu Sep 13 2001 - 11:39:45 CDT