Title: RE: Export question on excluding certain schema

Also, by default, in Oracle 8.1.6 MDSYS and CTXSYS are already excluded from the export, so no editing of catexp.sql is needed to do what the original poster wanted to do.

# grep MDSYS $ORACLE_HOME/rdbms/admin/catexp.sql  
        u$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
             u.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
              u1$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
             'ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
             ue$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
             s$.owner not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
      AND  u.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')

> -----Original Message-----
> From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
>
> The answer is: Yes.
> You will need to edit catexp.sql to rebuild internal view to exclude
> interested owner#.
>
> -----Original Message-----
> Is it possible to exclude certain sys type schema when we do
> export? We are
> (will be) migrating from 8161 to 9201 and would like to
> exclude MDSYS and
> CTXSYS from (8161) export.

Reply via email to