Add database to existing oracle database

Add database to existing oracle database

Post by sonika_seh » Thu, 30 Sep 2004 05:25:12


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
 
 
 

Add database to existing oracle database

Post by Jim Kenned » Thu, 30 Sep 2004 09:39:44


You are missing a lot of letters in your typing. You might want to put the
data in a schema and not another database. You need to look at the Oracle
Concepts Manual. (otn.oracle.com, documentation)
Jim

 
 
 

Add database to existing oracle database

Post by Daniel Mor » Fri, 01 Oct 2004 13:37:20


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.
--
Daniel A. Morgan
University of Washington
XXXX@XXXXX.COM
(replace 'x' with 'u' to respond)
 
 
 

Add database to existing oracle database

Post by sonika_seh » Wed, 06 Oct 2004 03:28:49

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
 
 
 

Add database to existing oracle database

Post by Turkbea » Wed, 06 Oct 2004 03:36:29


Ask the Oracle DBA of the main server's instance( I imagine it is not you) to handle the Export from your instance and the
Import into the main server's instance...It is not something that an inexperienced user should do without understanding the
basic concepts and the possible ramifications to the existing data in that instance, especially since you will be going from
a higher version to a lower one ( lots of complications can arise)

Sorry, but Oracle is so different from Access that essentially nothing you learned about Access will apply to Oracle.
 
 
 

Add database to existing oracle database

Post by joel-garr » Wed, 06 Oct 2004 08:46:09


You should listen to the others, especially the part about seeing your
DBA. But anyways:

There are often problems using export/import to go from a higher to a
lower version. The problems arise if new features of the higher
version are exported, which is likely if you are using defaults. The
normal thing for a DBA to do is downgrade the higher version
temporarily. But you might not have to. Try this:

In the server database, create all the tablespaces and tables
beforehand, using the proper parameters. Get a book about Oracle if
you don't know the parameters. See the Oracle Utilities manual for
the exp/imp parameters.
Export the schema with compress=N.
Import with ignore=y.
Figure out all the errors and correct them.

This is not the best way to do things, but implicitly assumes only
simple things were migrated from access and you may be able to fumble
through it, learning much.

jg
@home.com is bogus.
It takes one to know one:
http://www.yqcomputer.com/ ,39024675,39124642,00.htm
 
 
 

Add database to existing oracle database

Post by Daniel Mor » Wed, 06 Oct 2004 09:40:29


Export followed by Import using the EXP and IMP utilities.
--
Daniel A. Morgan
University of Washington
XXXX@XXXXX.COM
(replace 'x' with 'u' to respond)
 
 
 

Add database to existing oracle database

Post by rhugg » Wed, 06 Oct 2004 22:06:14


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.
 
 
 

Add database to existing oracle database

Post by Turkbea » Wed, 06 Oct 2004 22:57:43


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