Hello, when I migrate asp.net core to oracle database, it throw error
Failed executing DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='0']
UPDATE AbpEditions SET Discriminator = 'SubscribableEdition'
Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
at .(Int32 )
at . (Int32 , )
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.Data.Oracle.OracleCommand.ExecuteNonQuery()
at .ExecuteNonQuery()
at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues)
at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
ORA-00942: table or view does not exist
How can I fix it? Please help me !!!
After migrated from project aspnet-core, my table is structured like that:
CREATE TABLE "HOTROKTKT"."AuditQuestions" ( "Id" NUMBER(19,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE, "CreationTime" TIMESTAMP (7) NOT NULL ENABLE, "CreatorUserId" NUMBER(19,0), "LastModificationTime" TIMESTAMP (7), "LastModifierUserId" NUMBER(19,0), "IsDeleted" NUMBER(1,0) NOT NULL ENABLE, "DeleterUserId" NUMBER(19,0), "DeletionTime" TIMESTAMP (7), "TenantId" NUMBER(10,0), "AuditQuestionCode" NVARCHAR2(50) NOT NULL ENABLE, "AuditQuestionContent" VARCHAR2(4000 CHAR) NOT NULL ENABLE, "ParentId" NUMBER(19,0), "BussinessId" NUMBER(19,0) NOT NULL ENABLE, "LocalSoftwareId" NUMBER(19,0) NOT NULL ENABLE, "IsActive" NVARCHAR2(1) NOT NULL ENABLE, "IsHoData" NUMBER(10,0), PRIMARY KEY ("Id"));
And if I want to select data from AuditQuestions using PL/SQL or SQL Developer, my query must include quotation mark (") with table name or column name.
How can I fix it with my Enity?
Auditquestions has been existed. You can see my attach
I want to check my data and I run my query in PL/SQL or SQL Developer and has an error ORA-00942: table or view does not exist.
select * from HOTROKTKT.Auditquestions
select * from Auditquestions
But if I created my table in PL/SQL or SQL Developer, It execute successfull.
After running migrate data from Migrator project with oracle database,I executed a query with one table in database and it throwed error ORA-00942 although I typed the correct table name. What is wrong here? Can you help me, please?
There are my queries and they have the same error:Error ORA-00942.
select * from HOTROKTKT.Auditquestions
select * from Auditquestions
Sorry, with ODP.NET 18c, can I use with ASPNET.CORE and angular, EF core 2.1? Because when use Devart.Data.Oracle.EFCore, I must have one license per on location.
Hi all !
Can I use ASNETZERO with ODP.net and oracle 12c?Because I have 4 projects using ASNETZERO, using Microsoft Entity Framework (EF) Core and oracle 12c and each project development in different locations.
