[ОТВЕТИТЬ]
Опции темы
28.06.2012 11:47
 
Саму smextrachardge тоже почисть.
28.06.2012 11:53
 
Цитата:
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
 
smextracharge
D была лишняя.
28.06.2012 12:02
 
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
 
SMPRICEROUNDRULEHISTORY и SMPRICEROUNDRULE очищай. Возможно еще будет SMPRICEROUNDRULECLASS.
28.06.2012 12:11
 
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
 
sadocdefaults
28.06.2012 12:22
 
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
 
slscales
28.06.2012 12:28
 
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, время: 11:24.

Все в прочитанное - Донат - RSS - - Карта - Вверх

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