Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Location
    Sao Paulo - Brazil
    Posts
    6

    Unanswered:

    Originally posted by dcronin
    Why not do a LOAD replace with an empty dataset?
    I did that using a 0 byte file and it did what was needed all right.
    Good tip.

  2. #2
    Join Date
    Jan 2002
    Location
    India
    Posts
    17
    Hi ,

    There is a Alter Table SQL statement which has the option of , ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE.

    But again this restricts lot of constraints on the deletion and logging.

    If you want to delete whole table records, try LOAD with 0 byte file.
    You have the option of logging yes or no for the utility.

    I have deleted around 1500000 records using the load utility in 1 sec or so .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •