Editing DB.XML Files

This section describes how you edit an exported DB.XML file before importing it again.

A Sample DB.XML File

An exported DB.XML file might look like this. Note that the content is wrapped in a pair of <TRANSACTION_SET> tags.

<?xml version="1.0" encoding="iso-8859-1" ?> 
<xml2sql Version=”21C”>
<TRANSACTION_SET>
<CORPORATION CORPORATION_GID="ACL" CORPORATION_XID="ACL" DOMAIN_NAME="PUBLIC" INSERT_DATE="2001-10-05 19:03:37" INSERT_USER="DBA.ADMIN" IS_DOMAIN_MASTER="N" UPDATE_DATE="2001-10-06 12:43:46" UPDATE_USER="DBA.GLOGLOAD" dbObjectName="CORPORATION" /> 
</TRANSACTION_SET>
</xml2sql>

You can edit the values and add new objects.

When editing date and time values, be sure to keep the following format: YYYY-MM-DD HH:MM:SS.

If you miss an element in the exported file this is probably because Oracle Transportation Management does not export elements that are empty in the database. This means that you will have to add the tag to the DB.XML file yourself. Refer to the Oracle Transportation Management Data Dictionary for more information about what objects and tables exist.

Oracle Transportation Management ignores element names that do not correspond to the database table. This allows you to comment your DB.XML file without affecting what is imported.

As you edit the file, keep all element and attribute names in uppercase.