Also import with ignore=y and you will not get the error message when it
tries to recreate a preexisting tablespace.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"TurkBear" <noone_at_nowhere.com> wrote in message
news:66o1qtcp7a06ku2uh77sgebt31t49rhoeu_at_4ax.com...
>
> 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 Fri Sep 14 2001 - 03:02:04 CDT
