Table

How to Resolve ORA-25182: feature not currently available for index-organized tables

by Ed Chen
October 5, 2023September 7, 2023

ORA-25182 Found ORA-25182 when I tried to move an index-organized table to another tablespace. SQL> ALTER TABLE ERPAPP.CONFIG MOVE TABLESPACE ERP_TBS_01 ONLINE PARALLEL 16; ALTER… Read More »

Oracle ALTER TABLE DROP Column By Examples

by Ed Chen
June 26, 2023May 24, 2023

The syntax of dropping a column is pretty easy. SQL> show user USER is "HR" SQL> alter table employees drop column salary; Table altered. As… Read More »

How to Resolve ORA-12992: cannot drop parent key column

by Ed Chen
June 23, 2023July 2, 2023

ORA-12992 Tried to drop a column from a table, but it failed with ORA-12992. SQL> alter table customers drop column customer_id; alter table customers drop… Read More »

Create Table SQL Statement

by Ed Chen
May 10, 2023May 24, 2023

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 »

How to Resolve ORA-00907: missing right parenthesis

by Ed Chen
May 2, 2023March 25, 2023

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-02263: need to specify the datatype for this column

by Ed Chen
May 1, 2023March 24, 2023

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-02449: unique/primary keys in table referenced by foreign keys

by Ed Chen
April 27, 2023May 25, 2023

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 Find References to Table

by Ed Chen
April 26, 2023April 28, 2023

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 Resolve ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

by Ed Chen
March 6, 2023March 7, 2023

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 »

SQL Statement Hang? Why?

by Ed Chen
February 6, 2023June 6, 2023

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 »

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