Re: ORA-30510 while doing full database import ??

aaa <mccdba_at_yahoo.com> wrote in news:db38a501d0t_at_drn.newsguy.com:

> We have ORACLE 9.2.0.6 on Redhat LINUX AS 3.4. while we doing "full
> database import" there has ORA-30510 come out. I searched Metalink
> and Google, but not found much information. The error messages on
> import are:
>
> . importing OUTLN's objects into OUTLN
> . importing SYSTEM's objects into SYSTEM
> . importing TKOWNER's objects into TKOWNER
> IMP-00017: following statement failed with ORACLE error 30510:
> "CREATE TRIGGER "TKOWNER".TRIG_DONOTANALYZE before analyze on schema
> decla" "re begin if sys.dictionary_obj_name = 'MYWTKEMPLOYEE' then
> raise_ap" "plication_error(-20101, 'Do Not ANALYZE
> MYWTKEMPLOYEE'); end if; end; "
> IMP-00003: ORACLE error 30510 encountered
> ORA-30510: system triggers cannot be defined on the schema of SYS user
> . importing SYS's objects into SYS
> . importing TKOWNER's objects into TKOWNER
> About to enable constraints...
> Import terminated successfully with warnings.
>
>

30510, 00000, "system triggers cannot be defined on the schema of SYS user"

// *Cause:  An attempt was made to define a system trigger on the schema of
//          SYS user. This type of trigger is not supported currently.
// *Action: Do not attempt to create a system trigger defined on the
//          schema of SYS user.