Monday, November 29, 2010

DDL of Indexes without Storage Parameters

Taking DDL's of indexes is always a good habit before any export/import activity. But we get lot of parameters along with create statements, like storage parameters etc which we may not need them to run after the completion of import. So we can remove them before running the import by running the following statements.


EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',FALSE);
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'TABLESPACE',FALSE);
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'SEGMENT_ATTRIBUTES',FALSE);

No comments:

Post a Comment