Monthly Archives: April 2008

Here I checked on the sequences and application of these on the standby databases. I found an interesting fact here.

This will compile all invalid triggers in your schema.

This will compile all invalid views in your schema.

ORA-1000 and cursors What are cursors, and what are they doing in my SGA? Let’s take a closer look at what is going on inside oracle.

I noticed that the table I’d created below had a disabled primary key. CREATE TABLE “RDBM”.”DBH_OBJECT_SIZE” ( “DATABASE_NAME” VARCHAR2(9), “DATE_EXTRACTED” DATE, “OBJECT_TYPE” VARCHAR2(18), “BYTES” NUMBER, “LAST_DDL_TIME” DATE, “TIMESTAMP” VARCHAR2(19), “OWNER” VARCHAR2(30), “OBJECT_NAME” VARCHAR2(128), “STATUS” VARCHAR2(7), CONSTRAINT “PK_DBH_OBJECT_SIZE_PK” PRIMARY KEY (“DATABASE_NAME”, … Continue reading →