We are using oracle 10.2.0.4.0 on AIX, we are going to perform database reorg activity using expdp & Impdp
we will be taking the backup with full=y & impdp on schema level
How we can export & import the public synonym & dblinks?
Also, How can we expdp & impdp lob segments, as we are having some LOBs of 25-30GB?
Edited by: user10745179 on Apr 2, 2013 7:08 PM
First of all if you just running the expdp/impdp to reorganize the objects there is no need to export the public synonyms or database links. These are only definitions stored in the rdbms dictionary and do not have segments to be reorganized. Unless that is, you actually intend to drop and re-create the database followed by a reload.
If you are going to reorganize tables and indexes have you considered just using alter table move and alter index rebuild for the great majority of your objects? You would need to resort to export/import only for those table with long and long raw columns, which are not supported by alter table move.
Finally I hope you have done the analysis that shows that your system would benefit from performing the reorganizations because on many systems there is little long-term benefit to performing reorganizations.
HTH -- Mark D Powell --
PS - we used to use exp full=y rows=n to capture all DDL and then run imp rows=n ignore=y to bring public synonyms and bring any objects not imported by table/schema specific imports. The datapump utilities have the same kind of ability.
Edited by: Mark D Powell on Apr 2, 2013 7:22 AM