Check table attributes as it says. May be the indexes are in UNUSABLE state!!!
Sunday, February 16, 2014
Subscribe to:
Posts (Atom)
skip to main |
skip to sidebar
Few adventures in my slow running life...
About Me
Popular Posts
-
As stated in my previous post, loading data file into PostgreSQL is easy with the COPY command. But, the problem I faced is with loading ...
-
If your ASM is using RAW devices then its pretty easy to find out by just looking into your /etc/sysconfig/rawdevices (hope your DBA had ma...
-
Its not that quite often your SA asks you to release one of the disks that you been using it for a while for your database but if they do ...
-
There is a view named _v_dual in Netezza that can be used to replace Oralce's Dummy DUAL Table. For ex., In Oracle: select sysdate f...
-
If you are getting the error "ORA-00245: control file backup operation failed" in 11gR2 then the solution is to use the backup l...
-
OK, I am in process of upgrading one of our 11.2.0.2 RAC Environment to 11.2.0.3 and as a pre-req I have to install a patch 12539000. Fir...
-
Got the Simba JDBC drivers from databricks. Extracted the zip and then SimbaSparkJDBC41-2.6.3.1003.zip Adding Simb...
-
As mentioned in my earlier posts, this is one of the issues that I have faced with GoldenGate 11. I had three groups in this Golden Gate ...
-
One of the group abanded and ggserror.log says: ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, RRHP03.prm: Error mapping from ...
-
OMG... Its a new database that i want to create and Oracle yells at me stating that INSTANCE_NUMBER is busy? Oracle Error Code Says: ORA-003...