User and Schema

CREATE TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020December 9, 2022

Here is the list of CREATE TABLE Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. CREATE… Read More »

DROP TABLE Syntax for All Releases of Oracle Database

by Ed Chen
July 1, 2020December 9, 2022

Here is the list of DROP TABLE Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. DROP… Read More »

Grant Create Index to User?

by Ed Chen
June 13, 2020May 26, 2023

CREATE INDEX Privilege? Tried to grant a CREATE INDEX system privilege to an user, it failed with ORA-00990. SQL> grant create index to oe; grant… Read More »

How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this session

by Ed Chen
June 8, 2020December 10, 2022

ORA-08002 ORA-08002 means that you don't have any sequence value cached in your session, so you can't check the current value (CURRVAL) of the sequence… Read More »

How to Resolve ORA-00001: unique constraint violated

by Ed Chen
May 2, 2020June 6, 2023
8 Comments

ORA-00001 There're only two types of DML statement, INSERT and UPDATE, may throw the error, ORA-00001: unique constraint violated. ORA-00001 means that there's a constraint… Read More »

How to Resolve ORA-02429: cannot drop index used for enforcement of unique/primary key

by Ed Chen
April 29, 2020December 10, 2022

ORA-02429 ORA-02429 means that the index you want to drop is a primary key. SQL> drop index hr.JHIST_EMP_ID_ST_DATE_PK; drop index hr.JHIST_EMP_ID_ST_DATE_PK … Read More »

How to Resolve ORA-12991 Error Message

by Ed Chen
April 25, 2020July 2, 2023

ORA-12991: column is referenced in a multi-column constraint ORA-12991 means that the column you want to drop is bound to some multi-column constraints. You must… Read More »

How to Alter Primary Key in Oracle

by Ed Chen
April 22, 2020December 10, 2022

Modify Primary Key Sometimes, developers may design a better primary key to support the uniqueness of a table and they want to replace the current… Read More »

How to Drop Primary Key in Oracle

by Ed Chen
April 22, 2020April 20, 2023

Drop Primary Key Primary key is sort of a constraint rather than an index, you should treat it as a constraint first so as to… Read More »

How to Add Primary Key in Oracle

by Ed Chen
April 22, 2020December 10, 2022

Add Primary Key There're 3 basic ways to create a primary key for a table. 1. System-Generated Name You don't have to provide a name… Read More »

« Previous
1
…
8
9
10
11
12
…
15
Next »

JavaScript is not enabled. Please enable it and reload the page.