If that new box is a sand box, I would just play to see if exp of 8i can be imported in 9i.
-----Original Message----- Sent: Thursday, April 11, 2002 10:03 AM To: Multiple recipients of list ORACLE-L I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot connect to 8i database and 9i IMP cannot read 8i EXP dmp file. --- Kader Ben <[EMAIL PROTECTED]> wrote: > Thanks I'm thinking about this idea, > > > Ben > > --- [EMAIL PROTECTED] wrote: > > > > I'm assuming that you're creating a 9i database on > > the new machine when you > > install Oracle. > > > > I find it useful to pre-create the tablespaces > (and > > users) on the new > > database, rather than let the import do that. > This > > gives you more control > > over where datafiles end up and do some clearup on > > unneeded users, etc. > > > > > > > > > > > > > Kader Ben > > > > > <kaderb To: > > Multiple recipients of list ORACLE-L > > @yahoo.com> > > <[EMAIL PROTECTED]> > > Sent by: root cc: > > > > > Subject: > > > migrate from 8i to 9i > > > > > > > 04/09/2002 > > > > > 03:18 PM > > > > > Please > > > > > respond to > > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > > > > > Hi friends, > > > > I need your advise on the following question. > I > > have DB on 8i and I want create new one on another > > machine with 9i. > > I thought do the following steps: > > > > 1 - Install oracle 9i on a new machine > > 2 - make full export of the 8i DB > > 3 - import it on the new one (9i) > > > > So before I proceed I need your input. Am I > correct > > with these steps? There is something wrong? > > > > Many thanks for you, > > > > Kader > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Tax Center - online filing with TurboTax > > http://taxes.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Kader Ben > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).