Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: gabo22003@yahoo.com (Gabo)
Newsgroups: comp.databases.oracle.server
Subject: newbie - copying from test to production
Date: 7 Jul 2003 08:03:17 -0700
Organization: http://groups.google.com/
Lines: 10
Message-ID: <2be1853f.0307070703.46cdc7f5@posting.google.com>
NNTP-Posting-Host: 152.2.182.154
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057590197 26094 127.0.0.1 (7 Jul 2003 15:03:17 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 15:03:17 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237063

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