I have a data file that has Header and Detail information.  The Header
information is put into one table and the detail into another.  The
lines are distinguised by an H or a D.  Currently the sqlldr reads all
the H lines first and puts them into the table and then the D lines

I'm new to oracle and I'd want to build a form search.
I'm currently using dynamic sql to append all the where clauses that
has no null values on the corresponding form text boxes but I'm
searching for a more elegant and static solution.

I store all spfile in ASM disk group. How about the spfile of ASM
itself? Should I use pfile instead? What can I do if I have no cluster
file system in RAC environment to store the shared pfile?
Thanks.

Hey guys
We have some third party UDT that can be stored in the table as one of
the columns. These UDT objects are created using stored procedures and
are compared using other stored procedure. There also some kind of

Is there a tool available to test if default usernames and passwords
exist in SQL database?

Folks,
We've got an application that runs right now on Oracle 10g. The app
runs with NLS sorting and comparisons on e.g.
ALTER SESSION SET NLS_COMP=LINGUISTIC

do you know an algorithm for me, which is able to encrypt passwords,
which are compatible Oracle passwords? There is a maximum length
limitation in Oracle (30 chars) and the algorithm should not produce
an encrypted password longer than 30 characters, if the clear text

I am trying to use flashback database in 10g to do testing comparisons
between several iterations of a tuning exercise. So basically:
1) Start from a known state, and enable flashback database functionality
2) Update tables that are required to be performed for the tuning exercise

i'm using swingbench for retrive TPM information, but i don't know why
it shows me low TPM values.
My server is BL480C (2 CPU quad core) with 16Gb of RAM, there is
oracle 10g installed with SGA size of 6Gb and it is sizing for OLTP.

http://www.tpc.org/results/FDR/TPCC/HP_ML370G5_TPCC_071112_FDR.pdf
Page 96
spool createmisc.log
set echo on;

I am supposed to upgrade a 9i database to 10g on Linux x86 on 32bits.
Things to know:
- I want to preserve old installation. On 9i some very good DBA (not
like me) installed the database and there are many scripts which

I want to set up a silent install of 10.2.0 under RHEL4u5 I created a
response file, but noticed that when I did so, the first screen of the
installer was not the "Select Installation Method" screen I get with
just ./runInstaller, but a "Welcome" screen instead. When I try to use

What would cause this with rman 10.2.0.3?
I use Tivoli tdpo for my media manager. They provide a utility -
tdposync - which crosschecks backup pieces in the tdpo library against
the rman catalog to see if it has any that are no in the rman catalog.

What are the recommendations for oracle on Windows
Antivirus disable ?
Antivirus skip datafile ?
Defragment datafile ?

On the Oracle site you can download :
Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating
System
(SPARC) (64-bit) for evaluation.