IBM Support

Exporting Rational Team Concert databases in Oracle Database using the expdb utility

Troubleshooting


Problem

When using the "exp" utility from Oracle to back up the Oracle database backup, columns of type BINARY_FLOAT and BINARY_DOUBLE were not exported. This procedure can be used when working with an IBM Rational Team Concert repository database.

Symptom

In the resulting log, many error messages can be observed:


    EXP-00104: datatype (BINARY_DOUBLE) of column VAL in table CQDBA.WORKITEMS_SNAPSHOT_WC_DBL_XT_T is not
    supported, table will not be exported
    EXP-00104: datatype (BINARY_FLOAT) of column VAL in table CQDBA.WORKITEMS_SNAPSHOT_WC_FLT_XT_T is not
    supported, table will not be exported

Cause

The Rational Team Concert database uses the optimal Oracle datatypes named BINARY_FLOAT and BINARY_DOUBLE. BINARY_FLOAT and BINARY_DOUBLE are newer, more efficient column types and are introduced to replace the generic NUMBER datatype.

The Oracle "exp" utility does not handle BINARY_FLOAT and BINARY_DOUBLE datatypes export. Oracle recommends using the "expdp" utility to export BINARY_FLOAT and BINARY_DOUBLE datatypes.

Diagnosing The Problem

Database is Oracle Database 10g or newer.

The Oracle "exp" utility is being used to export the database and not the "expdb" utility.
Error messages EXP-00104 are seen in the log.

Resolving The Problem

To resolve this issue, use the "expdb" utility to export the database.



Leverage the Jazz Community

Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Related Information

Jazz.net work item 85318

[{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Repository","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"2.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":null}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert

Document Information

Modified date:
16 June 2018

UID

swg21391060

Page Feedback