import from /dev/null of del replace into <table-name>
Originally posted by dnlchou Hello,
Would anyone know how to run a large delete with a commit every n
I want to delete a large amount of records whose timestamps are
during a specific time duration.
You can also use the following SQL query to remove all the rows in a table
ALTER TABLE DummyTab activate not logged initially WITH EMPTY TABLE
However the condition here is that DummyTab has to be created with the NOT
LOGGED INITIALLY clause.
But note that, the primary key in DummyTab cannot be referenced as a foreign
key if DummyTab is created
with this clause.