DisclaimerThe views expressed here do not reflect the views of the company(ies) I work for (or have worked with) neither Oracle Corporation's. The opinions expressed by visitors on this blog are theirs. You are free to use this information but I am not responsible if you ever happen to suffer a loss/inconvenience/damage using it.
Top Posts in the last 48 hours
Category Archives: SQL
I still find confusion out there about the LOGGING and NOLOGGING clauses when performing DML and DDL operations, the reality is that the NOLOGGING clause will work only on particular conditions, but all regular inserts,updates and deletes will still log … Continue reading
One common question we can find in the internet is how to shrink the undo tablespace, because even if we see it empty we can get an ORA 3297 error (see here how to deal with ORA 3297 error), therefore, … Continue reading
ORA 3297 when resizing a datafile December 2, 2009 · Leave a Comment · Edit This Sometimes we want to shrink a datafile and we get the ORA-3297 error, what? but if there is enough space!! Well , there is … Continue reading
How to run a query when the result of the first one is null, powerful examples with NVL Continue reading