Re: Add database to existing oracle database

rhugga_at_yahoo.com (Keg) wrote:

>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.

No, actually . Sonika is not merely moving data around, but downgrading from a v 9.2 to a v 8.1 - it is not that simple..( for instance the EXP and IMP need to be done with the 8.1 utilities ( assuming Sonika has access to them and knows how, while running them on the server, to connect to the instance on the local box - is it even running the listener? Some local-only instances do not)). Received on Tue Oct 05 2004 - 08:57:43 CDT