I need to join two huge tables in Oracle to generate a sales report:
Table 1:   Customer  (5 million records)
   Cust_ID    (index)
   Cust_Name

Having just installed Solaris 10 GA on my SB1K I thought I might attempt
 an Oracle 10g install. Despite Sun/Oracle promulgating that the
version of the OS is supported I notice that the installation only
alludes to Solaris 8 and Solaris 9 as compatible platforms.

I am setting up a new system for one of our clients, consisting of
seven workstations and three servers in a replicated environment.
While testing, I got everything configured using GLOBAL_NAMES.  Now,
I'm being told that I won't be able to use the domain at the client

Looking for some SQL help.
I have a query which pulls from a header / detail table looking for
certain type codes. That works fine.
But I want to return a yes or no for the entire order if the subcode

I am trying to create the jdbc resource for oracle in the Sun
Java System Applicatoin Server Admin Console 1.4
When set up the resources and try to ping the db i am always getting this
error message.

Hi Friends,
I am just confused between PMON & SMON relating to Rollback
transaction. There are documents saying that PMON is responsible for
Rolling back the uncommitted transactions upon recovery after crash or

The subject pretty much says it all - How often is proof of OCP status
required in situations where people either say the have OCP on their
resumes or employers decide it's a prerequisite?
David Rolfe

I need to get the values for all of the :new and :old trigger columns
when the columns on the table are user defined. Since I don't know what
the columns on the table are going to be I can't hard code values in the
normal way. Does anyone know of a dynamic way of doing this?

I was wondering if anyone has done this yet as the 10gR2 version of RMAN
records tempfile information, but I have been unable to duplicate a
database without having to drop and add the tempfiles manually.
New syntax allows for tempfile renaming, however, I still get errors

Dear Oracle users,
I'm new to Oracleso my questaion could be  very stupid.
I installed Oracle 10g on a windows 2000 mashine andwould like to access
the standard database usind the Enterprise  manager :

Does anybody have experience with installing 8i database on Linux RH (3.0 or
4.0) or Linux SLES 9.0?
I know that 8i is no longer supported by Oracle. I'm interested if there are
any problems with installing and using 8i on this versions of Linux.

renaming original table is not acceptable, because it will break some other
functions.
If I do this:
In schema A, I have a table A,

I want to corrupt the oracle block for testing purpose on my test
machine.
Can one tall me how can we do this.
I heard that we can do that using "dd"  ...

Just got 10g (Personal) installed on Windows xP.
Want to start experimenting using SCOTT/TIGER but the account is "expired &
locked".
How do I resolve this.

I plan to install Oracle 10G2 on Red Hat Linux.
I'd like to fit 4 disk drives and a dvd-rw unit in a pc tower.
The disks have to be SATA.
I've searched the Antec site for instance, they give a lot of