What are the challenges you face when working across database platforms? Take the survey
Options

Error on compare

InfoadvInfoadv Posts: 6
edited March 31, 2011 6:54AM in Data Compare for Oracle
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

Comments

Sign In or Register to comment.