Search results for query: *

You have to consider that DDATE is a date field and not a CHAR string. You would need to explicitly convert the literal CHAR string to date eg. to_date('01-JUN-03','dd-MON-yy') or something like that

Or put another way: A->B ~ A determines B which is what you require. QED

What do your queries look like? And where do the indexes sit on your tables? I don't believe 2 million rows are terribly significant. 200 million rows maybe ;-)

My installation fails immediately. It appears that I don't have a supported version of the Java package installed. * The failure message: Initializing Java Virtual Machine from /tmp/OraInstall2003-06-18_10-25-29PM/jre/bin/java. Please wait... There was an error trying to initialize the HPI...

In this side-issue to getting Oracle set up, I think I have finally reached finality! phew... I issued an "ipcrm -q 10" knowing that such a queue does not exist. The instruction fails, as expected. Then I perform "sysdef" and, by George, the parameters are listed as required...

OK, subsequent investigations have led to this answer: "As Sun explained this to me, your shared memory setting are correct and the system recognizes them. However, since Solaris uses a dynamic kernel, the setting won't take affect until a process attempts to use them. (i.e. Oracle, IBM...

sysdef will indeed provide info on kernel parameters. However, not quite all are listed. In particular, during my pre-installation procedure of Oracle 9i I cannot get confirmation (after booting) of the shared memory and semaphore kernel parameter settings. I'm investigating ndd to see if this...