Populating CES Database

You can populate the new empty database by:

Using Oracle Export/Import to Load Existing User Data

You need to carry out a complete database export if you want to export the data in addition to CISDBA schema.  For detailed procedures to export the database, see Exporting Database in Using Oracle Export And Import To Load Existing User Data. Otherwise, export only the CISDBA schema.

Loading CES Seed Data

The Loading CES Seed Data allows you to the CES meta model with seed data.

To load the CES Seed Data, these conditions must be met:

  • On UNIX, you must belong to the dba group.

  • On Windows, you must belong to the ORA_DBA group.

Also, when loading the seed data into an empty database, make sure that the options Create Empty Database and Load Seed Database are executed from the same version of ENOVIA V5 VPM/CES Database Server.

This task explains how to load the CES Seed Data:
  1. In the Available Database Profiles list of the EDM database selection window, select the database.

    The selected database is highlighted.

  2. Click Select.

  3. In the navigation pad, select Load > Load Explore Seed Data.

    You are prompted to enter the password.

  4. Enter the password, and then click OK.

    The Load Explore Seed Data window along with the ORACLE_SID appears.

    You are not prompted to enter the password if you are loading the seed data in the same session. You are prompted to enter the password only if you have closed the session, and logged on later.

  5. Click Load to load the seed data.

    A confirmation message seed data will be loaded and this process would take some time appears.

  6. Click Yes to continue with the loading of seed data.

    The Load Explore Seed Data - Progress window appears.

The following actions take place during the Load Seed Data process:

  • Tables, views, sequences, synonyms, grants, and so on are created, all the application related Meta tables, corresponding views, and synonyms are created. The required grants are also given to all these objects.

  • All the data for the Meta tables are loaded.

  • Meta Model data is updated. All the Meta Model tables are updated and reflect the changes of the current version of CES.

  • Stored procedures are loaded. All system related stored procedures, triggers, packages and functions are created.

  • Meta Model and all system related queries are loaded.

  • DEFAULT and DETAIL configurations for the system class and the data modeling class are created.

  • All the latest patches are applied and CES Database is upgraded.

After the process is completed, a summary of errors, if any, appears.

  1. To view the list of errors, click the Error Summary tab.