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 -> Re: Add database to existing oracle database

Re: Add database to existing oracle database

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 04 Oct 2004 17:40:29 -0700
Message-ID: <1096936910.963546@yasure>


sonika wrote:

> Thanks jim and Daniel,
> 
> I'll definitly join some classes, but pls. help me right now..i don't
> know much about oracle, i just started with this project and i
> migrated around 30 tables from ms-access to oracle.And now i need to
> move this schema or tables from my machine to main server.Pls. suggest
> me something..i'll really appreciate your help.
> 
> Thanks,
> Sonika
> 
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1096519118.294868_at_yasure>...
> 

>>sonika wrote:
>>
>>
>>>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
>>
>>The concept of a database in MS Access has no relationship to the
>>concept of a database in Oracle. As Jim suggests ... you need to
>>read the concepts manual and understand how Oracle works.
>>
>>I strongly urge you to sign up for a class.

Export followed by Import using the EXP and IMP utilities.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Oct 04 2004 - 19:40:29 CDT

Original text of this message

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