From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: 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-----
>
href="mailto:[EMAIL PROTECTED]">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.
