Hi Luigi
I am also working on similar kind of project. The approach we are following is export/import. But in our case we need to import only structure then data will be inserted using db links at later stage.
I have done some experiments with the approach and it seems to be pretty fine. I tried in 10gr1 and r2. Followed the general approach. Created a new database in 10g. Modified sizes of UNDO,TEMP and USERS tablespaces. Then extracted all the tablespace creation statements by running import with
show=Y and created the tablespaces.
Then check your tnsnames.ora to include entries for all the remote databases, so that db links are created successfully and then materialized views, if any, there are.
Also check from the log generated with show=Y, if any user is using TEMP tablespace as its default tablespace. Create this user manually giving USERS or some appropriate tablespace as default, otherwise import would terminate unsuccessfully while trying to create any such user.
Finally run the import with ignore=Y and look for any errors in the log file. This approach worked pretty fine for me. There were only 7-8 errors in a 80 GB database import.
Do remember to increase sizes of UNDO and redo logs.
Sidhu
http://amardeepsidhu.blogspot.com
The best thing will be, if possible, to try out all this for your case, before making the final decision.
Message was edited by:
Sidhu
