Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604: error occurred at recursive SQL level 1 (11g r2, Server 2003)
ORA-00604: error occurred at recursive SQL level 1 [message #417894] |
Wed, 12 August 2009 01:05  |
 |
delna.sexy
Messages: 941 Registered: December 2008 Location: Surat, The Diamond City
|
Senior Member |
|
|
Hi all,
I am facing problem as described below.
Please help me in solving that.
I was having THRD_PARTY_SITES table in my schema.
I DROP that table with CASCADE CONSTRAINTS option.
After it, I am creating that table again with some modification and getting following problem.
SQL> drop table thrd_party_sites cascade constraints;
Table dropped.
SQL> purge recyclebin;
Recyclebin purged.
XLNTSEO@gold12>CREATE TABLE THRD_PARTY_SITES
2 (
3 WEBSITE_PK NUMBER(38, 0) NOT NULL,
4 OWNER_FK NUMBER(38) NOT NULL,
5 WEBMASTER_FK NUMBER(38, 0) NOT NULL,
6 DOMAIN_FK NUMBER(38) NOT NULL,
7 REMARKS VARCHAR2(1000),
8 LAST_LOGIN_FK NUMBER NOT NULL,
9 LAST_MODIFIED TIMESTAMP(6) NOT NULL,
10 LAST_MC VARCHAR2(50) NOT NULL,
11 LAST_IP VARCHAR2(20) NOT NULL
12 , CONSTRAINT THRD_PARTY_SITES_PK PRIMARY KEY
13 (
14 WEBSITE_PK
15 )
16 ENABLE
17 )
18 ;
CREATE TABLE THRD_PARTY_SITES
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_OBJ1) violated
I have searched on Google and this forum as well, but unable to solve this problem.
Thanks in advance.
regards,
Delna
|
|
|
|
|
|
|
Re: ORA-00604: error occurred at recursive SQL level 1 [message #417918 is a reply to message #417913] |
Wed, 12 August 2009 02:01   |
 |
delna.sexy
Messages: 941 Registered: December 2008 Location: Surat, The Diamond City
|
Senior Member |
|
|
Thank you Michel sir for suggestion, but problem continues.
SYS@gold12>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
XLNTSEO@gold12>CREATE TABLE THRD_PARTY_SITES
2 (
3 WEBSITE_PK NUMBER(38, 0) NOT NULL,
4 OWNER_FK NUMBER(38) NOT NULL,
5 WEBMASTER_FK NUMBER(38, 0) NOT NULL,
6 DOMAIN_FK NUMBER(38) NOT NULL,
7 REMARKS VARCHAR2(1000),
8 LAST_LOGIN_FK NUMBER NOT NULL,
9 LAST_MODIFIED TIMESTAMP(6) NOT NULL,
10 LAST_MC VARCHAR2(50) NOT NULL,
11 LAST_IP VARCHAR2(20) NOT NULL
12 , CONSTRAINT THRD_PARTY_SITES_PK PRIMARY KEY
13 (
14 WEBSITE_PK
15 )
16 ENABLE
17 )
18 ;
CREATE TABLE THRD_PARTY_SITES
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
XLNTSEO@gold12>connect xlntseo@gold12
Enter password: *******
Connected.
XLNTSEO@gold12>CREATE TABLE THRD_PARTY_SITES
2 (
3 WEBSITE_PK NUMBER(38, 0) NOT NULL,
4 OWNER_FK NUMBER(38) NOT NULL,
5 WEBMASTER_FK NUMBER(38, 0) NOT NULL,
6 DOMAIN_FK NUMBER(38) NOT NULL,
7 REMARKS VARCHAR2(1000),
8 LAST_LOGIN_FK NUMBER NOT NULL,
9 LAST_MODIFIED TIMESTAMP(6) NOT NULL,
10 LAST_MC VARCHAR2(50) NOT NULL,
11 LAST_IP VARCHAR2(20) NOT NULL
12 , CONSTRAINT THRD_PARTY_SITES_PK PRIMARY KEY
13 (
14 WEBSITE_PK
15 )
16 ENABLE
17 )
18 ;
CREATE TABLE THRD_PARTY_SITES
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_OBJ1) violated
regards,
Delna
|
|
|
|
|
|
Goto Forum:
Current Time: Tue Feb 11 01:39:50 CST 2025
|