Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-30510 while doing full database import ??

ORA-30510 while doing full database import ??

From: aaa <mccdba_at_yahoo.com>
Date: 13 Jul 2005 07:26:13 -0700
Message-ID: <db38a501d0t@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. Received on Wed Jul 13 2005 - 09:26:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US