Hi,

I use Oracle 9i and would like to mix two different databases into one.
These two databases have different tables and views. Each name of a
table or view is unique and does not exist in the other database.
Now I would like to bring them all together into a new database so that
this new database has all the information of the other two databases
(table-descriptions and contents of tables/views).
Also it would be great if this would be possible autimatically at a
special time, i.e. in the night.

If you can help me and have a manual reference, please tell me the URL
because I am really new to Oracle.

Thank you very much,
Dennis

How big the schmeas are in those database? I think export and import
would be a good idea in this case.
Take schema export from one database and import it in the a database
where you want.

For an example,
On database A
exp system/password@tnsname file=username.dmp log=username.log
owner=user_name_which_you_want_to_export direct=y statistics=none

On Database B
Create a similar user and with the exact default tablespace (for
convineance purpose).
Once done with user creation.
imp system/password@tnsname file=username.dmp log=imp_username.log
fromuser=username touser=username statistics=none

once you see 'imported successfully finished without warning', then
analyze the newly imported schema in database B.

For more help, search at http://asktom.oracle.com site.

if you are really sure that none of table has same name :
export from database A
import into database B

use google with "exp imp expdp impdp"

yang


"Dennis" <arbeitend@yahoo.de> a écrit dans le message de news:
1115118724.026195.306960@o13g2000cwo.googlegroups. com...
> Hi,
>
> I use Oracle 9i and would like to mix two different databases into one.
> These two databases have different tables and views. Each name of a
> table or view is unique and does not exist in the other database.
> Now I would like to bring them all together into a new database so that
> this new database has all the information of the other two databases
> (table-descriptions and contents of tables/views).
> Also it would be great if this would be possible autimatically at a
> special time, i.e. in the night.
>
> If you can help me and have a manual reference, please tell me the URL
> because I am really new to Oracle.
>
> Thank you very much,
> Dennis
>

Thank you very much. I tried it and it worked :-)

Dennis

Thank you very much. I tried it and it worked :-)

Dennis