Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> newbie - copying from test to production
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