Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Unanswered: Msg 4720 - Cannot truncate table since some isolation level 0 scans or REORG is activ

    I get Sybase Msg 4720 even when no REORGs or isolation level 0 is active on the specified table.
    Am not able to find out the cause.
    Can anyone help me regarding this?

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    check if any locks exist on this table in syslocks

  3. #3
    Join Date
    Jan 2005
    The only time I received this error, it was after I had to kill a 'create index' statement. Once I rebooted the Sybase server, operation returned to normal. How long has it been since you rebooted the server?

Posting Permissions

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