Hi Support,
I get following error from the Data compare for Oracle. The tool looks promising for my goal, but there seem to be some quotation marks missing. (yes, the name of the column is "Key_SITE")
Or am i doing something stupid?
Best regards,
Martijn Mooij
Bug report generated at 21-10-2010 17:44:12
Program version 1.0.0.318
System.Exception: Couldn't execute statement:
SELECT Key_SITE, Key_MAJOR, Key_MINOR FROM "PAS_STORAGE_MIGRATION"."Q_FILTER" ORDER BY Key_SITE, Key_MAJOR, Key_MINOR ---> Devart.Data.Oracle.OracleException: ORA-00904: "KEY_MINOR": ongeldige ID
at Devart.Data.Oracle.bp.b(Int32 A_0)
at Devart.Data.Oracle.ap.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 #IQK.#HQK.#t.#2Db.#jeR()
at RedGate.Shared.Controls.ProgressDialogEx.e()
Hi Martijn,
I get following error from the Data compare for Oracle. The tool looks promising for my goal, but there seem to be some quotation marks missing. (yes, the name of the column is "Key_SITE")
Or am i doing something stupid?
Best regards,
Martijn Mooij
Bug report generated at 21-10-2010 17:44:12
Program version 1.0.0.318
System.Exception: Couldn't execute statement:
SELECT Key_SITE, Key_MAJOR, Key_MINOR FROM "PAS_STORAGE_MIGRATION"."Q_FILTER" ORDER BY Key_SITE, Key_MAJOR, Key_MINOR ---> Devart.Data.Oracle.OracleException: ORA-00904: "KEY_MINOR": ongeldige ID
at Devart.Data.Oracle.bp.b(Int32 A_0)
at Devart.Data.Oracle.ap.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 #IQK.#HQK.#t.#2Db.#jeR()
at RedGate.Shared.Controls.ProgressDialogEx.e()