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

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Wed, 13 Jul 2005 07:24:36 -0700 (PDT)
Message-ID: <20050713142436.24858.qmail@web60823.mail.yahoo.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.

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

Received on Wed Jul 13 2005 - 09:26:52 CDT