Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Unanswered: Deleting a lot of records from a table

    Hi,

    I need to delete about 3 million records from a table from a table that has about 4 million records.

    I have a maintainence window of about 30-45 mins, maybe more.
    Can i disable logging on a sybase database, delete the records. Renable logging and backup the database.

    In oracle you can turn the logging on and off.
    Can the same be done in sybase

    Thanks in advance,
    Dave

  2. #2
    Join Date
    Dec 2002
    Posts
    10

    Re: Deleting a lot of records from a table

    Do you wan to run you procces as a daemon? Or do you wnat to run it in a single user mode?
    Ruth G.

  3. #3
    Join Date
    Jan 2003
    Posts
    26

    Re: Deleting a lot of records from a table

    How about doing a "select into" for the 1M records you want to keep into a new table, dropping the original table, and then renaming the new table? "select into" operations aren't logged.

    Frank

Posting Permissions

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