I am trying to connect to a database server that is using port 1522. Whenever I try to connect from Toad on my laptop I get the following error: ORA-12170: TNS:Connect timeout occurred
When I tnsping from my laptop I get the following message: TNS-12535: TNS:operation timed out
When I connect to the database using Putty and tnsping the connection is instantaneous and the tnsping returns back the tns string and OK (0 msec)
There is no firewall on the database server I am trying to connect to. My laptop has Oracle installed and the listener is configured for port 1521. Can someone help me to resolve this issue?
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
How to Unravel a Tricky Query
If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them. …