Some database objects have been deleted from the database that were under version control. On opening Team Coding Viewer they still appear in the list. How can these be deleted from the Viewer?
For Toad 10.6 and below:
1) Drop and Rebuild the Code Control Group where the objects exist. (Team Coding | Code Control Groups)
or
2) Login to TOAD as the TOAD user, select the TC_OBJSTATUS table and then the data tab, look down the PSL_OBJECT_NAME column and find the name of the object you have deleted from the database. Select the row and delete it from the TC_OBJSTATUS table.
(Note that if Team Coding was installed as part of SQL Navigator setup, then the rows should be removed from SQLNAV_PROGRAM_STATUS_LOG and SQLNAV4_PSL_VC_INFO tables in schema SQLNAV.)
For versions 11.0 and above, it is possible to simply highlight the object in the Team Coding Viewer and click the 'Delete' key. This would need to be done be a user who has the TC_ADMIN role (if not the owner of the object).
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center