Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> newbie - copying from test to production

newbie - copying from test to production

From: Gabo <gabo22003_at_yahoo.com>
Date: 7 Jul 2003 08:03:17 -0700
Message-ID: <2be1853f.0307070703.46cdc7f5@posting.google.com>


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 Received on Mon Jul 07 2003 - 10:03:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US