Oracle Error 1403 Encountered
1403 encountered HELP PLEASE From: Hans Forbrich Date: Fri, 02 Apr 2004 15:54:49 GMT Message-ID: Kalvin wrote - and wrote, and wrote, unnecessarily to several different Oracle newsgroups: > Hi, > > Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production ... > . exporting cluster definitions > > EXP-00056: ORACLE error 1403 encountered > > ORA-01403: no data found (I'm sure you are aware that ORA-01403 is simply an empty result set. Just a surprise that exp loudly complains about this.) More symptoms please .... does it terminate there or continue? I have not run into this. From basic troubleshooting, a few things to check: -I didn't see the exp header, just the connect to database header. Is it possible that the exp version does not match the database? (IOW, do you have multiple DB versions on the machine?) -During install, were there any obvious errors, especially during building the catalog? -Anything in the Alert.log? -In the background dump directory? Do you have another 9.2.0.4 server machine elsewhere, possibly on a different OS? If yes, could you try exp across the net to this DB ... (quick way of checking whether you have a problem with exp or catalog) /Hans Received on Fri Apr 02 2004 - 09:54:49 CST This message: [ Message body ] Next message: hastenthunder: "Enterprise Manager in 10g" Previous message: Noel: "Re: Resemble script for Oracle database" In reply to: Kalvin: "EXP-00056: ORACLE error 1403 encountered HELP PLEASE" Next in thread: Sybrand Bakker: "Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE" Reply: Sybrand Bakker: "Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE" Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ] Original text of this message HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
HELP PLEASE From: Kalvin Date: Fri, 2 Apr 2004 11:26:00 -0400 Message-ID: <406d86d9$1@dnewserver.firstcom.cl> Hi, Problems start the export: Linux version 2.4.9-e.3 (bhcompile_at_stripples.devel.redhat.com) (gcc version 2.96 20000731 (Red Hat Linux 7.2 2.96-108.1)) #1 Fri May 3 17:02:43 EDT 2002 Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in http://www.orafaq.com/usenet/comp.databases.oracle.server/2004/04/02/0168.htm WE8ISO8859P1 character set and AL16UTF16 NCHAR character set About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting rollback segment definitions . exporting database links . exporting sequence numbers . exporting directory aliases . exporting context http://www.orafaq.com/usenet/comp.databases.oracle.server/2004/04/02/0164.htm namespaces . exporting foreign function library names . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions . exporting system procedural objects and actions . exporting pre-schema procedural objects and actions . exporting cluster definitions EXP-00056: ORACLE error 1403 encountered ORA-01403: no data found EXP-00056: ORACLE error 1403 encountered Scan Metalink not found upper error, please English. Atte. Received on Fri Apr 02 2004 - 09:26:00 CST This message: [ Message body ] Next message: JZ: "Re: ER diagram" Previous message: pheonix1t: "development question - using .net on oracle/linux" Next in thread: Hans Forbrich: "Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE" Reply: Hans Forbrich: "Re: EXP-00056: ORACLE error 1403 encountered HELP PLEASE" Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ] Original text of this message HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
2007 - 8:21 pm UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: The Oracle Database Developer Choice Awards: We Need You! Latest Followup You Asked Tom, https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1492331695311 I export a table that has the following constraints: Primary key Unique key Check Why does an import back into the same schema with ignore=y show errors for unique and check constraints but does not show them for primary key constraints that exist also? IMP-00017: following statement failed with ORACLE error 2261: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_UK" UNIQUE ("COLUMN2") USING I" "NDEX PCTFREE 10 INITRANS 2 MAXTRANS oracle error 255 STORAGE(INITIAL 24576 NEXT 409600 M" "INEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP" "S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE " IMP-00003: ORACLE error 2261 encountered ORA-02261: such unique or primary key already exists in the table IMP-00017: following statement failed with ORACLE error 2264: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_CK" CHECK (column2 > '') ENABL" "E NOVALIDATE" IMP-00003: ORACLE error 2264 encountered ORA-02264: name oracle error 1403 already used by an existing constraint About to enable constraints... Import terminated successfully with warnings. Just Curious . Thanks Peter and we said... ignore=y changes the behavior of CREATE statements. If the CREATE statement failed - no data would be imported. Ignore=y says "go ahead, import the data anyway". The failure of the ALTERS affects nothing -- the data is already imported by then, so we just "fail" them (but continue on) Reviews Write a Review ignore=y May 23, 2002 - 11:31 am UTC Reviewer: X Wang from NJ USA I use ignore=y option when I import the data. It only ignore CREATE TABLE command, but failed in CREATE TYPE command. IMP-00015: following statement failed because the object already exists: "CREATE TYPE "MYTYPE_T" TIMESTAMP '2002-02-10:16:24:15' OID 'F4CDB776D6771" "1D3AD090008C7E98428' " How can I ignore create type command? Thank you Followup May 23, 2002 - 3:31 pm UTC it didn't fail, it just keeps on going. ops$tkyte@ORA817DEV.US.ORACLE.COM> drop user a cascade; User dropped. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> grant dba to a identified by a; Grant succeeded. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> @connect a/a ops$tkyte@ORA817DEV.US.ORACLE.COM> set termout off a@ORA817DEV.US.ORACLE.COM> REM GET afiedt.buf NOLIST a@ORA817DEV.US.ORACLE.COM> set termout on a@ORA817DEV.US.ORACLE.COM> a@ORA817DEV.US.ORACLE.COM> a@ORA817DEV.US.ORACLE.COM> create table t ( x int ); Table created. a@ORA817DEV.US.ORACLE.COM