Create Table SQL Statement
What is the syntax of CREATE TABLE in Oracle? Since the syntax of CREATE TABLE statement can be very flexible and complicated, so using text-based… Read More »Create Table SQL Statement
Table
How to Resolve ORA-00907: missing right parenthesis
ORA-00907 ORA-00907 means that SQL parser saw an illegal string or expression where it expects a right parenthesis to close the inner statement. Usually, it's… Read More »How to Resolve ORA-00907: missing right parenthesis
How to Resolve ORA-02263: need to specify the datatype for this column
ORA-02263 Tried to create a table, but it failed with ORA-02263. SQL> create table fruits (fruit_name not null, price number); create table fruits (fruit_name not… Read More »How to Resolve ORA-02263: need to specify the datatype for this column
How to Resolve ORA-02449: unique/primary keys in table referenced by foreign keys
ORA-02449 Tried to drop a table, but it failed with ORA-02449. SQL> show user USER is "HR" SQL> drop table employees; drop table employees … Read More »How to Resolve ORA-02449: unique/primary keys in table referenced by foreign keys
How to Find References to Table
Referential Integrity To check the referential relationship of a table in details, we have to join some dictionary views, ALL_CONSTRAINTS and ALL_CONS_COLUMNS. For example, we'd… Read More »How to Find References to Table
How to Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-00054 There're several cases that throw ORA-00054. Alter Table Move Tablespace We tried to move table to another tablespace. SQL> show user USER is "HR"… Read More »How to Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
SQL Statement Hang? Why?
SQL Statement Hang Statements hanging or waiting always has a reason, lock release. Let's see some cases. UPDATE TABLE Hangs You may saw something is… Read More »SQL Statement Hang? Why?
How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
ORA-01981 Tried to revoke object privileges from an user, but it failed with ORA-01981. SQL> revoke all on HR.EMPLOYEES from OE revoke all on HR.EMPLOYEES… Read More »How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
How to Resolve ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
ORA-14133 Tried to move a table to another tablespace, but it failed with ORA-14133. SQL> alter table employees move erp_tbs; alter table employees move erp_tbs… Read More »How to Resolve ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
How Oracle Rename Constraint
ALTER TABLE RENAME CONSTRAINT To rename a constraint, we need to do it through ALTER TABLE. Let's see a constraint. SQL> show user USER is… Read More »How Oracle Rename Constraint