Resolved ORA-12154: TNS:could not resolve the connect identifier specified
This issue is faced in some versions of oracle as ORA-12154: TNS: Could not resolve …
Resolved ORA-12154: TNS:could not resolve the connect identifier specified Read More »
Oracle Tips and Tricks
Oracle is a database used in a large extent. For more oracle tips and tricks like SQL tips, PL/SQL tips and Oracle DBA, follow IT Blogger Tips.
ORA-00600: internal error code – Fixed
In my previous articles you have learned how to fix ORA-01722: invalid number and ORA-28056: …
Fixed: ORA-01722: invalid number
One of my friends asked me to resolve the oracle “ORA-01722: invalid number” error. He …
Fixed: ORA-28056: Writing audit records to Windows Event Log failed
Today I tried to connect with Oracle Database 11g and got ORA-28056 error. Oracle Database …
Fixed: ORA-28056: Writing audit records to Windows Event Log failed Read More »
Create a Table from another Table in Oracle SQL
In my previous article, you have seen how to create a Table and Global Temporary …
Create Normal Table and Global Temporary Table in Oracle
We can create two types of Table in Oracle. 1) Normal Table (CREATE TABLE Command) …
Create Normal Table and Global Temporary Table in Oracle Read More »
Alter Table Command in Oracle SQL
The ALTER TABLE command allows you to rename an existing Oracle table to a new …
Fixed – ORA-19809: limit exceeded for recovery files
When you try to connect with Oracle Database and it throws an error message ORA-19809: …
Fixed – ORA-19809: limit exceeded for recovery files Read More »
How to use LPAD and RPAD Function
If you want to pad any character on the left side or right side of …