Oracle ALTER TABLE DROP Column By Examples
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 »Oracle ALTER TABLE DROP Column By Examples
Reference Constraint
How to Resolve ORA-12992: cannot drop parent key column
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 »How to Resolve ORA-12992: cannot drop parent key column
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 Oracle Rename Table
You can either using SQL statement or GUI tools to rename a table, depending on your requirement. Table Rename by SQL Statement Table Rename by… Read More »How Oracle Rename Table
Drop Tablespace Examples
We take the following steps to drop a tablespace. 1. Make Sure Non-Default The tablespace that we want to drop must not be the default… Read More »Drop Tablespace Examples
How to Resolve ORA-00903: invalid table name
ORA-00903 In this post, I will introduce 3 main error patterns about ORA-00903, they are: Create Table Select Table Insert, Update and Delete Table Alter… Read More »How to Resolve ORA-00903: invalid table name
How to Resolve ORA-00942: table or view does not exist
ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »How to Resolve ORA-00942: table or view does not exist
How to Disable All Referencing Constraints Before Importing Data
Disable Constraints Before you can import with table_exists_action=truncate, you have to disable all referencing constraints. Otherwise, you may get the error: ORA-02266: unique/primary keys in… Read More »How to Disable All Referencing Constraints Before Importing Data