DB.XML Export

This page is accessed via Business Process Automation > Data Import/Export > DB.XML Export.

Use this page to export DB.XML.

Note: Excessively large DBXML exports will be stopped rather than overloading the server.

Note: There is also a command line utility available to export DB.XML files. See the Data Management Guide on the Oracle Help Center for details.

Exporting DB.XML

1. Select an Export Object Type. Depending upon your selection, the available fields on this page change.

Note: The DB Object Set capability is deprecated and is not supported. Use the Migration Project functionality instead of the deprecated functionality.

DB Object and DB Object Set

1. If you selected DB Object or DB Object Set in the Export Object Type field, select a DB Object or DB Object Set. This selection indicates the database table, or set of database tables that you want to export.
2. Enter a Where Clause. When specifying a where clause; omit the "where" keyword. For example, "RATE_GEO_GID = "DOMAIN.PA-NY". For another example you can enter DOMAIN_NAME='GUEST' or rownum<3. You can also combine the two like this DOMAIN_NAME='GUEST' and rownum<3.

Query

1. If you selected Query in the Export Object Type field, enter a SQL Query (for example, "select * from activity").
2. Enter a Root Name (for example, ACTIVITY).

Migration Entity

1. If you selected Migration Entity in the Export Object Type field, select a Migration Entity Name.
2. Enter the Object IDs you want to export. This field is a comma-separated list of object primary keys. When the selected Migration Entity Name has a compound primary key (i.e. contains more than one column value), each value is separated by the pipe '|' character. For example, if LocationRoleProfile were the selected entity name, a valid entry in the Object IDs field would be "TEST_LOCATION_ONE_GID|SHIPFROM/SHIPTO, TEST_LOCATION_TWO_GID|PORT".

Common

These fields are common to all choices made in the Export Object Type field.

Note: If your data contains international characters, save your file without specifying an encoding. Later when editing your file, use an editor that supports UTF-8.

1. Set the Include Footprint Columns field to "Y" if you want to include the INSERT_DATE, INSERT_USER, UPDATE_DATE, and UPDATE_USER columns in the export. These columns are called the footprint columns.
2. If you want large objects to be shown as encoded, select "N" in the Large Objects (LOB) as Elements field. If you want to see them displayed as text, select "Y".
3. Select the Output Destination. If you want to glance at the data, choose "Browser". You can click the Copy Text button when viewing in your browser to copy the output into the clipboard. If you choose "File on Local," the output is saved as a file to your local machine. It is recommended that you save the output as a file.
4. Click Run.

Note: Elements that are empty in the database do not display.