Re: Add database to existing oracle database

sonika_sehrawat_at_yahoo.com (sonika) wrote in message news:<709618ea.0409281225.1a09da58_at_posting.google.com>...
> Hi experts,
>
> I am new in oracle.I migrated one database from ms-access to oracle 9i
> using oracle migration utility on my local machine.But now i need to
> add this oracle database from my local machine to existing main
> database oracle 8i on main server.Pls. tell how i can add this
> database from my machine to main server.
> I think i can use export/import utility.But i never used this utility
> before, pls. tell what should i need to do.And if export/import is
> good way to migrate database pls. explain me in steps.
>
> I'll really appreciate your kind help.
> Pls. reply me soon, it's urgent!!!
>
> Thanks..so much
> Sonika

If feasible, I would just export your database and then import it into a specific schema in your existing database. (I am assuming your database is small since you did this migration on your workstation)

Also, you have already done the 'migration' so now you are merely moving data around. Received on Tue Oct 05 2004 - 08:06:14 CDT