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.
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. |
---|
Related Information
Product Synonym
Rational Team Concert
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21391060