How to Resolve ORA-00933 Error Message
ORA-00933: SQL command not properly ended ORA-00933 means that you use an unexpected word or phrase at the position where SQL parser knows what qualified… Read More »How to Resolve ORA-00933 Error Message
How Oracle Enable PDB Restricted Mode
We can enable the restricted mode of a PDB in the CDB or in the PDB. In CDB Enabling the restricted mode of a PDB… Read More »How Oracle Enable PDB Restricted Mode
How Oracle Check Startup Time
To check Oracle database startup time, we have to know the difference between instance startup time and database open time. Additionally, we also check the… Read More »How Oracle Check Startup Time
How to Resolve ORA-00980 Error Message
ORA-00980: synonym translation is no longer valid We usually use synonyms to point to a base object that we don't own it. Let's see a… Read More »How to Resolve ORA-00980 Error Message
How to Resolve ORA-65045 Error Message
ORA-65045: pluggable database not in a restricted mode If you saw ORA-65045 like this: SQL> alter database rename global_name to ORCLPDBX; alter database rename global_name… Read More »How to Resolve ORA-65045 Error Message
How to Resolve ORA-02243 Error Message
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option The root cause of ORA-02243 may vary in different operations, so the case in this post… Read More »How to Resolve ORA-02243 Error Message
How to Resolve ORA-00940: invalid ALTER command
ORA-00940 ORA-00940 means that you use an invalid object type for ALTER operation, usually it's because you misspelled the object type name. First of all,… Read More »How to Resolve ORA-00940: invalid ALTER command
How to Resolve dd: invalid number
dd: invalid number Tried to replicate a partition to another with dd, but it failed with dd: invalid number. Here I initially use 1g for… Read More »How to Resolve dd: invalid number
How to Resolve ORA-65016: FILE_NAME_CONVERT
ORA-65016 and ORA-65180 Tried to clone a remote PDB with the same name and path and got ORA-65016 like this. SQL> create pluggable database ORCLPDB… Read More »How to Resolve ORA-65016: FILE_NAME_CONVERT
How to Resolve ORA-17629 Oracle Error Message
ORA-17629 ORA-17627 ORA-12514 When we tried to clone a remote PDB via a DB link, we got ORA-17629 ORA-17627 and ORA-12514 in error stack like… Read More »How to Resolve ORA-17629 Oracle Error Message