ORA-00001: unique constraint entity framework 6 code first approach

ORA-00001: unique constraint entity framework 6

Solution : - 

The solution is to grant user both: 

'CREATE SEQUENCE' and 

'CREATE TRIGGER' 

permissions and re-create the schema.

Read More

ORA-30673: column to be modified is not an identity column oracle 12c

ORA-30673: column to be modified is not an identity column

Answer : - 

Currently orcle 12c does not support modifying an existing column as IDENTITY column 

Solution : - Solution is to add a new column and then drop the existing one

ALTER TABLE Tablename ADD (ColumnName_NEW NUMBER(3) GENERATED ALWAYS AS IDENTITY);

Read More

ORA-00904 invalid identifier entity framework 6 migration oracle 12c

ORA-00904 invalid identifier

this issue is caused because of we have used oracle keyword in column name. check below image

Action is keyword in oracle. this is the reason oracle appends "" double quotes in column name. 

Solution : - 

Just remove the double quotes and rename column name in Capitalize letters.

Read More