Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014

    Unanswered: Sqlcode=-1477, sqlstate=55019


    If the table went into SQLCODE=-1477, SQLSTATE=55019 . Is there any option to revert this back without dropping & recreating this.
    I altered a table with NOT LOGGED INITIALLY & After that tried to update that table & I can't able to access my table.

    Can some one suggest me what have to do without recreating this.

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 27
    If you activated 'not logged initially' and the UOW failed, you can only drop and recreate the table (docs have clear warnings about this).
    Inexperienced people should never use 'not logged initially' without taking all necessary precautions against this situation.
    A much safer option is a DGTT or CGTT.

Tags for this Thread

Posting Permissions

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