How to fix the Oracle error ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.?

In this post, you’ll learn more about the Oracle ErrorORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.

Reason for the Error ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.

The data in the EIF file was exported from a dimension with wider values than the target dimension will accommodate.

How to fix the Error ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated. ?

You can fix this error in Oracle by following the below steps

Change the definition of the target dimension, or check to be sure that multiple values from the target dimension have not become identical during the import process. This could cause data loss as data from later dimension values overstores data imported earlier.