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

Technote (troubleshooting)


Problem(Abstract)

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

Cross Reference information
Segment Product Component Platform Version Edition
Rational Team Concert

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Team Concert
Repository

Software version:

2.0

Operating system(s):

Linux, Windows

Reference #:

1391060

Modified date:

2009-06-24

Translate my page

Machine Translation

Content navigation