Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!newsfeed.stanford.edu!cyclone.bc.net!sjc70.webusenet.com!news.webusenet.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: newbie - copying from test to production Date: Mon, 07 Jul 2003 14:30:56 -0700 Organization: EXE Message-ID: <3F09E68F.76C0C694@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <2be1853f.0307070703.46cdc7f5@posting.google.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 31 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237098 Gabo wrote: > Hello, > > I have a production db running Oracle 8.0* and another db running 9i > (the 8 & 91 have the same tables). I would like to make the 9i db my > new production database. How do I get all of the table/record > information from the 8.0 into the 9i...do I need to empty out the 9i > and then export from the 8 and import into the 9i? If I have free TOAD > is there a better way? > > Thanks There is definitely a better way than TOAD though you have included almost no useful information from which someone could help you. Is the data in the 9i database a key violation if you import from 8.0? How much data? How many tables? How much down time can be tolerated. In general I'd just do an export followed by an import or dump the 8.0 to ASCII and bring it in with SQL*Loader but more information is requred to give a definite answer. -- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)