Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

Team Projects

Team Projects determine which objects are controlled by Team Coding. If you are a Team Coding Administrator (meaning that you have the TC_ADMIN_ROLE) you can create one or more Team Projects to group the controlled objects into logical work units, based on your organization's workflow requirements. To use Team Coding there must be at least one Team Project.

When a version control system (VCS) is being used in Team Coding, you can link a Team Project to a project in the VCS. This linking determines where the object source revisions of the Team Project are managed in the VCS.

SQL Navigator enables you to create one or more sub-directories in a VCS project at the same time that you create a Team Project. This feature is helpful if, for example:

  • You plan to use multiple Team Projects and want to mirror each one to its own VCS directory under a common root VCS project.
  • You have multiple developers or development teams working on the same Team Project, and you want to isolate their objects into dedicated directories within a common root project.


Use Team Projects page of Team Coding Administration to administer your Team Projects. Only a Team Coding Administrator can administer Team Projects.

  1. If using a version control system with Team Coding, log into the VCS from Team Coding | VCS Logon.
  2. Go to Team Coding | Administer.
  3. Select the Team Projects tab.

To Create a Team Project

See Setup Team Projects.

To change a Team Project

Under the Team Project that you want to change, do one of the following:

  • To change the name of the project, right click the name and then select Rename Team Project.
  • To edit the controlled database objects, click in the field next to Database Objects, then click the arrow to select the schema that you want to edit. Refer to Setup Team Projects for information about how to complete these fields and apply the changes.
  • To make a project active (meaning Team Coding is active for the objects specified in the project) or inactive (deactivate Team Coding for those objects), select or deselect the Active box.

To delete a Team Project

  1. Select the Team Project to delete.
  2. Click to delete the project, or right-click the project and select Delete Team Project.
  3. Click Apply.

To freeze a Team Project

  1. Select the Team Project to freeze.
  2. Click to freeze the project, or right click the project and select Freeze Team Project.
  3. Click Apply.

Note: In the Team Projects list, the project is now marked (Frozen) rather than (Active). Click to unfreeze the project.

To work with revisions

The Team Coding Administrator can perform the following actions for a project:


Action Description

(Disabled if a VCS is not being used)

Synchronize Changes

Synchronize differences between the version in the database and the version in the VCS. Select the objects that you want to synchronize.

Synchronize resolves the following issues:

  • Differences between the VCS source code and the object in the database. Any differences are resolved by the global setting of the "When differences in source versions exist" option in the Team Coding Administrator window (as configured by a Team Coding Administrator). If the option is set to Prompt User (user chooses between opening the database version or the VCS version) a non-administrator user can make that choice. Otherwise, either the database or VCS version is opened, depending on the global setting. See Set Team Coding Global Settings for more information.
  • Objects in the database but not in the VCS are added to the VCS.
  • Objects in the VCS but not in the database are added to the database.

(Disabled if a VCS is not being used)

Create New Revision in the VCS

Create a new revision in the VCS for all controlled objects. This action loads all of the objects for a Team Project into the Synchronize window. Select the ones for which you want to make a new revision.

Compile PL/SQL Objects in DB

Compile the selected object in the database.



Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating