Prev
Next
Forums S3 Systems Administration

DBreorg issue

Sort:
You are not authorized to post a reply.
Author
Messages
John Crudele
Veteran Member
Posts: 50
Veteran Member
11/18/2013 1:28 PM
    running LSF9 , Windows/Sql2008

    When I run a dbreorg i get the following error

    File GMCODES 
    ERROR File alreadt exists in Phase Create file while processing file GMCODES

    Error Text  CreateSQLFile(dbo.GMCODES)
    CM sfSQLMaker Execute command
    SQL Server error code 2714 There is already an object named "gmcodes" in the database

    I was given a solution of dropping the table in SQL and rerun dbreorg

    Does this seem correct or will it cause other issues

    Thanks
    JC 
    Kwane McNeal
    Veteran Member
    Posts: 479
    Veteran Member
    11/18/2013 1:41 PM
      If the table has no records (and I'm assuming it does not), then yes, that should work.
      If it *does* have records, then you'll want to back them up, then drop the table.

      typically, a 'create table BLAH as select * from GMCODES;', should do a quick and dirty backup.

      Kwane
      You are not authorized to post a reply.