Error on compare

[Infoadv]

I'm trying Data Compare for Oracle for my customer and when compare two oracle db ( one is 9.2 and the second is 10g ) during a table compare I receive the following error :

Bug report generated at 07/03/2011 12.03.11
Program version 1.0.1.346

System.Exception: Couldn't execute statement:
SELECT SEQUENCE, LASTMODIFIED, LASTUSER, _GROUP_, _INACTIVE_:, COMMITMENT_ID, FISCAL_YEAR, COMM_AMOUNT FROM "_SMDBA_"."BUDG_COMM" ORDER BY SEQUENCE ---> Devart.Data.Oracle.OracleException: ORA-00911: invalid character
at Devart.Data.Oracle.bo.b(Int32 A_0)
at Devart.Data.Oracle.an.a(Int32 A_0, a4 A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
--- End of inner exception stack trace ---
at RedGate.Oracle.DataCompare.DBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.OracleDBDataReaderFactory.CreateDataReader(ITable table, IList`1 columns, IList`1 indexColumns, String whereClause)
at RedGate.Oracle.DataCompare.DataComparer.Compare()
at RedGate.Oracle.Compare.EngineController.Data.DataCompareEngine.#t.#GKb.#UsY()
at RedGate.Shared.Controls.ProgressDialogEx.e()

if we remove _GROUP_ and _INACTIVE_: colmuns from compare all work fine.

it's enough that column name be in double quotes (") to solve this problem , how can I do that ?

thanks in advance for help

[Tom Harris]

Hi,

I'm sorry that you've run into this problem. As you correctly point out the problem is caused by the column names containing special charcaters, but not being enclosed in quotes. I've marked this as a bug against our product - ODC-193.

Is it difficult for you to rename those columns to add the missing quotes?

Kind regards, Tom

Tom Harris,
Red Gate Software

[Infoadv]

It's impossible to change column name becasue the 2 database are repository of an application data and the table cannot be changed.

Bye

[Tom Harris]

Hi there,

this issue has now been fixed. Please email productsupport@redgate.com to get an updated installer

Kind regards, Tom

Tom Harris, Red Gate Software

[Tom Harris]

Hi there,

the fix for the issue is now incorporated into the Red Gate Oracle tools download. You can grab the latest version from

http://www.red-gate.com/products/oracle-development/

Kind regards, Tom

Tom Harris, Red Gate