Re: TRUNCATE/DELETE/CONSTRAINTS/HELP

Hi Robert,

We've had the same problem with truncating tables being refernces by constraints.
You can easy get a list of all constraints into the table by quering the system table all_constraints (user_constraints). I wrote a script to first disable these constraints, then trincating the table and re- enable the constraints. It works fine.

Nils.

#  ____    ____    ____
# |  _ |  |    |  |    |      Nils Vierus
# | (_)|  |    |  |    |
# | ___| _|   _|__|   _|      IVU GmbH
# |(   (_  \ ( (_  | (_ |     Bundesallee 88
# | |  | \  \/ /|  |  | |   D-12161 Berlin
# | |  |  \   /||  |__| |
# |(____) |\_/ |\________)    fon       : +49 30 85906-325
# |    |  |    |  |    |      fax       : +49 30 85906-313
# |____|  |____|  |____|      e-mail    : nv_at_ivu-berlin.de
#                             compuserve: 73064, 2423