I created DB link and when I try to use It I am getting the following error.
Error : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. I have database entry in the tnsnames.ora on server and as well as on client.
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 …
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…