Problem with query builder from backups

• Peter Fairchild

  Valued Member

  Points: 66

  More actions

  March 4, 2007 at 8:38 am

  #116392

  Sometimes when I get a database from a client (a backup) and I restore it, I find that the query builder (right click on table, open table, query) does

  not give me all the fields but simply *(all columns) instead of having all the fields listed. It also adds _1 to the tables name (ACCESS_ROUTINES_1 instead of ACCESS_ROUTINES)

  I don't understand where the ACCESS_ROUTINES_1 comes from.

  Thanks for your help,

  Kind regards

  Peter

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 5, 2007 at 9:54 am

  #693161

  I guess you do not have privilege to view all columns in this table.