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
User and Schema
How to Resolve ORA-00924: missing BY keyword
ORA-00924 ORA-00924 means that the reserved word BY is missing from the statement at the position where it points out in the error message. ORA-00924… Read More »How to Resolve ORA-00924: missing BY keyword
How to Resolve ORA-02155: invalid DEFAULT tablespace identifier
ORA-02155 Tried to set the default permanent tablespace for an user, but it failed with ORA-02155. SQL> alter user hr default tablespace; alter user hr… Read More »How to Resolve ORA-02155: invalid DEFAULT tablespace identifier
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-02277: invalid sequence name
ORA-02277 Tried to create a sequence to share with other users, but it failed with ORA-02277. Reserved Word SQL> create sequence share; create sequence share… Read More »How to Resolve ORA-02277: invalid sequence name
How to Resolve ORA-01918: user does not exist
ORA-01918 Tried to change an user's attribute, but it failed with ORA-01918. SQL> alter user ht account unlock; alter user ht account unlock … Read More »How to Resolve ORA-01918: user does not exist
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