SQL Developer No TNS ?
At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »SQL Developer No TNS ?
DBA Role, How and Why
DBA Role In Oracle database, DBA could be the most privileged role. Whenever we want to make a user to be the most dominant application… Read More »DBA Role, How and Why
Oracle TO_CHAR Example
TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »Oracle TO_CHAR Example
How to Resolve ORA-02304: invalid object identifier literal
ORA-02304 When we copy all data from one schema to another through a loopback database link, we saw ORA-02304. [oracle@test ~]$ impdp system@orclpdb schemas=ERP remap_schema=ERP:ERP2… Read More »How to Resolve ORA-02304: invalid object identifier literal
How to Resolve ORA-01821: date format not recognized
ORA-01821 Tried to display a datetime into a readable format by TO_CHAR function, but it failed with ORA-01821. SQL> set heading off; SQL> select TO_CHAR(sysdate,… Read More »How to Resolve ORA-01821: date format not recognized
Oracle Parameter SESSIONS, How and Why
In this post, we'd like to talk about the following topics for you to manage SESSIONS parameter better. Default Value of SESSIONS How to Check… Read More »Oracle Parameter SESSIONS, How and Why
How to Restore SPFILE
Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How to Restore SPFILE
How to Backup SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How to Backup SPFILE
How to Resolve ORA-02224: EXECUTE privilege not allowed for tables
ORA-02224 When we tried to grant some object privilege to an user, it failed with ORA-02224. SQL> grant write on hr.employees to oe; grant write… Read More »How to Resolve ORA-02224: EXECUTE privilege not allowed for tables
How to Resolve ORA-22928: invalid privilege on directories
ORA-22928 Tried to allow an user to be able to access a directory, but it failed with ORA-22928. SQL> grant select on directory data_pump_dir to… Read More »How to Resolve ORA-22928: invalid privilege on directories