Как быстро подчистить базу... : Oracle

Саму smextrachardge тоже почисть.

а точно так называется табличка
SQL> delete from smextrachardge cascade;
delete from smextrachardge cascade
*
ERROR at line 1:
ORA-00942: table or view does not exist

smextracharge
D была лишняя.

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'

SMPRICEROUNDRULEHISTORY и SMPRICEROUNDRULE очищай. Возможно еще будет SMPRICEROUNDRULECLASS.

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

sadocdefaults

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

slscales

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