[ОТВЕТИТЬ]
Опции темы
28.06.2012 11:47  
Mtirt
Саму smextrachardge тоже почисть.
 
28.06.2012 11:53  
Kryukov
Цитата:
Сообщение от Mtirt
Саму smextrachardge тоже почисть.
а точно так называется табличка
SQL> delete from smextrachardge cascade;
delete from smextrachardge cascade
*
ERROR at line 1:
ORA-00942: table or view does not exist
 
28.06.2012 11:55  
Mtirt
smextracharge
D была лишняя.
 
28.06.2012 12:02  
Kryukov
SQL> delete from smextracharge cascade;

50 rows deleted.

SQL> commit;

Commit complete.

SQL>
SQL> delete from smpricetypes cascade;
delete from smpricetypes cascade
*
ERROR at line 1:
ORA-04091: table SUPERMAG.SMPRICEROUNDRULEHISTORY is mutating, trigger/function
may not see it
ORA-06512: at "SUPERMAG.SMPRICEROUNDRULECLASSUID", line 14
ORA-01403: no data found
ORA-04088: error during execution of trigger
'SUPERMAG.SMPRICEROUNDRULECLASSUID'
 
28.06.2012 12:04  
Mtirt
SMPRICEROUNDRULEHISTORY и SMPRICEROUNDRULE очищай. Возможно еще будет SMPRICEROUNDRULECLASS.
 
28.06.2012 12:11  
Kryukov
SQL> delete from smpricetypes cascade;
delete from smpricetypes cascade
*
ERROR at line 1:
ORA-02292: integrity constraint (SUPERMAG.SACDOCDEFPRICESTYPE) violated - child
record found
 
28.06.2012 12:16  
Mtirt
sadocdefaults
 
28.06.2012 12:22  
Kryukov
SQL> delete from sadocdefaults cascade;

27 rows deleted.

SQL> commit;

Commit complete.

SQL> delete from smpricetypes cascade;
delete from smpricetypes cascade
*
ERROR at line 1:
ORA-02292: integrity constraint (SUPERMAG.SLCSCALES_PRICETYPE) violated - child
record found
 
28.06.2012 12:24  
Mtirt
slscales
 
28.06.2012 12:28  
Kryukov
SQL> delete from slscales cascade;

17 rows deleted.

SQL> commit;

Commit complete.

SQL> delete from smpricetypes cascade;
delete from smpricetypes cascade
*
ERROR at line 1:
ORA-02292: integrity constraint (SUPERMAG.SMCLOCPRICESTYPE) violated - child
record found
 
 


Опции темы



Часовой пояс GMT +3, время: 12:34.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.