bringing together two different databases (with different schemes) into one database

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 - 06:12:04 CDT