Re: newbie - copying from test to production

If the objects are the same, then drop them in your 9i instance and export/import from 8 to 9i. If your database is not too large, then this way shouldn't take too terribly long.

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"