An export to Oracle fails when a column name exceed 30 characters. For example, the Calculated_Data_Type_Comparison column name causes the export of calculated indexes and colors to fail. To export successfully, manually change column names which exceed 30 characters.
How to edit a column name
1 In the Navigation Pane, choose Setup➛Data Exports.
2 In Setup Data Export—Data Exports, select a data export name.
3 Choose View or Edit.
4 In Setup Data Export—Columns, choose Show SQL.
5 In Show Export SQL, choose Save.
6 In Save As, type a file name. Then, choose Save.
7 Open the file in an text editor. Edit the column name. Then, choose Save.
8 Use a SQL editor, such as SQL Plus to create a table in Oracle with the shortened field names.
