Re: [Q] ORA-30510 while doing full database import ??

according to metablink, you can just re-create the trigger after the import.  Raj

 On 7/13/05, dba1 mcc <mccdba1_at_yahoo.com> wrote:
>
> We have ORACLE 9.2.0.6 <http://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.
>
>
> any ideal?
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l