Category Archives: Oracle

Impdp Hangs Importing Materialized Views

   Send article as PDF    A simple exercise to refresh a schema in a test database caused no end of problems when it hung at 99% complete. The last message on screen indicated that it was importing the Materialized Views (yes, with a ‘Z’). After a long time, the DBA running the import killed […]

Interesting Data Guard Problem

   Send article as PDF    While checking out a dataguarded database prior to being handed over into production, I needed to test that both OEM and dgmgrl could carry out a switchover and failover from the (stand-alone) primary db (ORCL_PDB) to the physical standby database (ORCL_SBY), and back again.

So, How Do You Change a User’s Password

   Send article as PDF    The Oracle database allows the users to change their passwords as follows:

Introduction to Oracle Datapump – Part 2

   Send article as PDF    In this, the second part of the Introduction to Oracle Datapump mini-series, we take a look at importing dump files using impdp. If you missed the first part which concentrated on exporting with expdp, have a read of it here. Once again, the following is a quick introduction for […]

Introduction to Oracle Datapump – Part 1

   Send article as PDF    Oracle Datapump, aka expdp and impdp were introduced at Oracle 10g to replace the old faithful exp and imp utilities. Many DBAs around the world find that it’s hard to change from what we know like the back of our hand, to something new. We need to change because […]

Oracle RMAN for Beginners – Part 10

   Send article as PDF    A slight variation on the incremental backups. In this (short) article, I demonstrate the use of database file copy backups which are themselves updated on a regular basis to avoid having to restore and recover using numerous incremental backups.

Oracle RMAN for Beginners – Part 9

   Send article as PDF    It’s been a while since the previous post in this series, but I’m back again. This time out, we are looking at incremental backups. What they are, how they work, and how – of course – to take them and use the to restore and recover your databases.

Oracle Proxy Users – What Are They Used For?

   Send article as PDF    This post has also been categorised under “rants and raves” as you will see below! Oracle 10g was the first time that proxy users could be used easily from SQL. Prior to that only Java and/or OCI programs could use them. They’ve been around since 8i, but not (well) […]

Spatial Indexes and Oracle Errors. How to fix.

   Send article as PDF    If, like me, you have suffered from ORA-29902 Error in executing ODCIIndexStart() routine errors where Spatial indexes are involved, the following might help you fix it.

This Listener Problem is Driving Me Mad!

   Send article as PDF    I have been looking at this far too long, and I’m stumped. I resolved a similar problem yesterday on another server. That was down to the ORACLE_HOME setting in listener.ora having a ’1′ in it rather than a ’2′. Took ages to spot that.

ORA-03262 While Dropping Empty Datafile

   Send article as PDF    Tired of trying to drop empty datafiles from a tablespace, which you know is empty? Keep getting errors telling you the data file isn’t empty? Getting frustrated with the whole thing? Me too. This link has the reason and solution.

Internet Explorer Won’t Upload Files to MOS?

   Send article as PDF    Are you forced to use Internet Explorer at work? Are you, like me, forced to use an old, insecure, broken version of IE at work, because it’s the Government Standard version? And are you, like me, unable to upload evidence files to My Oracle Support?

Statspack Snapshot Fails ORA-01400 Cannot Insert NULL …

   Send article as PDF    Oh hum. An 11.2.0.3 Enterprise Edition production database has statspack taking a regular snapshot under the control of a dbms_scheduler job. For no apparent reason, the snapshot started failing with ORA-01400 Cannot insert NULL into PERFSTAT.STATS$SYSTEM_EVENT.EVENT. This was an interesting one to fix.

Swap 2 Values, in SQL, Without Using a Temporary Variable

   Send article as PDF    Recently, I saw a mention of an interview question for SQL developers. It was something along the lines of: There is a table with a sex column. It has been discovered that the values are swapped around and need to be corrected. How would you swap all ‘M’ values […]

Ever deleted a Data File From a Running Database?

   Send article as PDF    http://jarneil.wordpress.com/2013/04/23/recovering-from-rm-rf-on-a-datafile/ has all you need to know to help avert a total disaster. Tanel Poder, who knows these things, advises that the file should be quiesced or made read only before attempting the recovery.