sequences & IMP-00015: following statement failed because the object already exists: [message #73812] |
Sat, 17 July 2004 00:20 |
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
|
|
|
|
|
|