question about database integration

[oracle_dba]

Hello,

I am new to this whole database integration and would like to get any help on this !

Can anyone answer these questions:

1) What are the different approaches for database integration ?
2) What to look for before deciding which approach to take ?
3) Any references/ books that might help

Thank you for your help
neil

[mojaveson]

What exactly do you mean by database integration? Integration with what? Need some more specifics to be able to comment. What do you have now and what is the end product you want to wind up with?

[oracle_dba]

well we have multiple oracle databases and we want to merge it all in one if possible

thanks,
neil

[harman_deep]

Well..by the term you say merging many datbases into one...
I feel you want actually many schemas of databases into one.

So just create one brand new oracle instance and dataase.
Take the export of all the schemas of all databases and then import all these exports into one oracle database under different schemas...

So EXPORT-IMPORT utility is what you are looking for ...It is command line utility that will help you....