Home » RDBMS Server » Server Utilities » sequences & IMP-00015: following statement failed because the object already exists:
sequences & IMP-00015: following statement failed because the object already exists: [message #73812] Sat, 17 July 2004 00:20 Go to next message
ramya
Messages: 87
Registered: August 2002
Member
hi when i am importing a schema level
i got this error i got the reason for it b cos
i started the import and terminated suddenly so the sequences are imported first.Mydought
is what i have to do or anything i have to do later
when i got this warning or wheter it will have any affect on tables that accessing this sequnce.i
just created a new schema and imported .
i am giving the log file mesages below some of them are cached

IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "DQ4$_IDS" MINVALUE 1 MAXVALUE 9999999999999999999999999999"
" INCREMENT BY 1 START WITH 207 CACHE 20 NOORDER NOCYCLE"

IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "DQ4_QUERY_IDS" MINVALUE 1 MAXVALUE 99999999999999999999999"
"99999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"

IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "DQ4_REPORT_IDS" MINVALUE 1 MAXVALUE 9999999999999999999999"
"999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
"CREATE SEQUENCE "ORDID" MINVALUE 1 MAXVALUE 999999999999999999999999999 INC"
"REMENT BY 1 START WITH 622 NOCACHE NOORDER NOCYCLE"

with regards
ramya
Re: sequences & IMP-00015: following statement failed because the object already exists: [message #73826 is a reply to message #73812] Tue, 20 July 2004 04:49 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
You need not to worry about this message.
Just reimport using parameter Ignore=Y.

Aotherwise simply drop the already created objects & then start a fresh import.

Regards
Himanshu
Re: sequences & IMP-00015: following statement failed because the object already exists: [message #332705 is a reply to message #73812] Wed, 09 July 2008 07:16 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Hello,

do we have to re-create the database from scratch? or we just do the import woth parameter ignore=y

Thank you
Re: sequences & IMP-00015: following statement failed because the object already exists: [message #332713 is a reply to message #332705] Wed, 09 July 2008 07:42 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
do we have to re-create the database from scratch?

Because objects already exist?

Quote:
or we just do the import woth parameter ignore=y

I think the answer is:
Quote:
You need not to worry about this message.
Just reimport using parameter Ignore=Y.

Regards
Michel
Previous Topic: ORA-02248: invalid option for ALTER SESSION
Next Topic: Nested functions in SQL Loader Control File.
Goto Forum:
  


Current Time: Fri Dec 09 05:55:12 CST 2016

Total time taken to generate the page: 0.06730 seconds