Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bringing together two different databases (with different schemes) into one database
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_at_yahoo.de> a écrit dans le message de news:
1115118724.026195.306960_at_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
>
Received on Tue May 03 2005 - 10:00:28 CDT