RE: migrate from 8i to 9i
You must be thinking of something else, I just got thru doing a 9i import of an 8i dmp file. -Original Message- Sent: Thursday, April 11, 2002 12:03 PM 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 > > > > > > Multiple recipients of list ORACLE-L > > @yahoo.com> > > <[EMAIL PROTECTED]> > > Sent by: rootcc: > > > > > 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 sp
RE: migrate from 8i to 9i
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 > > > > > > Multiple recipients of list ORACLE-L > > @yahoo.com> > > <[EMAIL PROTECTED]> > > Sent by: rootcc: > > > > > 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 s
Re: migrate from 8i to 9i
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 > > > > > > Multiple recipients of list ORACLE-L > > @yahoo.com> > > <[EMAIL PROTECTED]> > > Sent by: rootcc: > > > > > 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 othe
Re: migrate from 8i to 9i
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 > > Multiple recipients of list ORACLE-L > @yahoo.com> > <[EMAIL PROTECTED]> > Sent by: rootcc: > > 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).
RE: migrate from 8i to 9i
Ben - For that size, I would go export/import. You will need to do that first anyway to test out 9i. Make a note of how long the entire process takes so you can make sure your business users can give you that much downtime. If you encounter a roadblock, then you can examine the alternatives. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Thanks guys for your replies' My DB is no big about 2.5Gb. Robert, both DB's (8i and 9i ) are on windows 2000. Ben --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > I (perhaps improperly) assumed that by "another > machine" he meant another > platform. In retrospect, this might not have been > the case > > RF > > -Original Message- > Sent: Tuesday, April 09, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > Ben - How large is your database and how long can > you have it unavailable to > production? If your database isn't large and your > users can be off, for > example, a weekend, then the export/import method is > simple and easy. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 2:19 PM > To: Multiple recipients of list 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: DENNIS WILLIAMS > 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: Freeman, Robert > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: migrate from 8i to 9i
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 <[EMAIL PROTECTED]> Sent by: rootcc: 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).
RE: migrate from 8i to 9i
Thanks guys for your replies' My DB is no big about 2.5Gb. Robert, both DB's (8i and 9i ) are on windows 2000. Ben --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > I (perhaps improperly) assumed that by "another > machine" he meant another > platform. In retrospect, this might not have been > the case > > RF > > -Original Message- > Sent: Tuesday, April 09, 2002 3:44 PM > To: Multiple recipients of list ORACLE-L > > > Ben - How large is your database and how long can > you have it unavailable to > production? If your database isn't large and your > users can be off, for > example, a weekend, then the export/import method is > simple and easy. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, April 09, 2002 2:19 PM > To: Multiple recipients of list 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: DENNIS WILLIAMS > 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: Freeman, Robert > 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).
RE: migrate from 8i to 9i
I (perhaps improperly) assumed that by "another machine" he meant another platform. In retrospect, this might not have been the case RF -Original Message- Sent: Tuesday, April 09, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Ben - How large is your database and how long can you have it unavailable to production? If your database isn't large and your users can be off, for example, a weekend, then the export/import method is simple and easy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 2:19 PM To: Multiple recipients of list 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: DENNIS WILLIAMS 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: Freeman, Robert 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).
RE: migrate from 8i to 9i
Ben - How large is your database and how long can you have it unavailable to production? If your database isn't large and your users can be off, for example, a weekend, then the export/import method is simple and easy. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 09, 2002 2:19 PM To: Multiple recipients of list 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: DENNIS WILLIAMS 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).