Drop Tablespace Examplesby Ed ChenAugust 30, 2022July 27, 2022We 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 nameby Ed ChenMarch 28, 2019March 15, 2023ORA-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 existby Ed ChenMarch 23, 2019February 20, 20234 CommentsORA-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 Databy Ed ChenDecember 13, 2016December 11, 2022Disable 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