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: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: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

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