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?
User and Schema
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-01536: space quota exceeded for tablespace
ORA-01536 Tried to use CTAS to make a table in a tablespace, but it failed with ORA-01536. SQL> create table t1 tablespace users as select… Read More »How to Resolve ORA-01536: space quota exceeded for tablespace
How to Resolve ORA-00922: missing or invalid option
ORA-00922 ORA-00922 means that SQL parser found an invalid option where should be empty or one of other valid options it expects. Since it's a… Read More »How to Resolve ORA-00922: missing or invalid option
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 to Resolve ORA-01432: public synonym to be dropped does not exist
ORA-01432 Tried to drop a public synonym, but it failed with ORA-01432. SQL> drop public synonym country; drop public synonym country … Read More »How to Resolve ORA-01432: public synonym to be dropped does not exist
How to Resolve ORA-01434: private synonym to be dropped does not exist
ORA-01434 Tried to drop a private synonym, but it failed with ORA-01434. SQL> show user USER is "OE" SQL> drop synonym country; drop synonym country… Read More »How to Resolve ORA-01434: private synonym to be dropped does not exist
How Oracle Rename User
There's no direct way to rename an user, simply because Oracle does not support it. A supported way is to DROP USER then CREATE USER… Read More »How Oracle Rename User
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
How Oracle Rename Trigger
ALTER TRIGGER RENAME TO To rename a trigger, we can use ALTER TRIGGER RENAME TO statement to rename it. For example: SQL> show user USER… Read More »How Oracle Rename Trigger