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