I am connecting from websphere to oracle 10G using jdbc thin client.
Oracle does not have advanced encryption installed.
Is it possible to have the user pwd used by the driver encrypted when
we don't have the advanced encryption package installed ?

I'm using Oracle 10.2.0.3.0 and I'm trying to import a 9i dump file.
I know this file is good but on this particular server.
With the HTML based OEM, I'm selecting the Maintenance tab, Import
from Export Files.  From the combobox, select "Prior to 10g", point to

I'm trying to figure out how to set the tablespace for data and
indexes on all the tables of my Erwin model.
I know how to do it for one table, but I would like to avoid having to
edit the property for each table individually...

As many times as HJR has changed things and ditched all of his old
content there are still at times useful articles and postings out
there.
However it looks like now both the ( old site as of just a couple of

Oracle 10g.
I have a general question here on how best to implement this: We have
a table called TRAIN that holds around 10K records of railroad data. A
client of ours wants to be able add a field that specifies which of

I am trying to write a simple script to drop triggers for a user on a
10g database
declare
   v_trgname   varchar2(30);

Group,
We just installed Oracle RAC(10.2) on linux.
We would like to backup the database for ASM disk and local disks at
the same time, so that every nodes can have access to the backup and

For a one time query, and if I were to make many of these, caching in
the V$SQLAREA is not necessary.
Is there any Oracle hint to allow me to do that?
Thanks.

I am using Oracle for the 1st time.
I have been given the dump of a database (snc01.DMP), which was
created by means of the export command.
I have not much details about the export, apart that it was don using

I am new to Oracle and today someone asked me about the "fference
between unique_id and primary key. Which to use and why?" I know about
the primary key but not unique_id. Can someone kindly give me an
overview of it?

Needed help to generate following report in html using preferably
sql*plus leveraging  it's built-in html reporting  functionality
(i.e.set markup html on ) but open for any other solutions as well..
Here is the SQL for the report.

I am trying to construct a query tool in VB6.
This is all i want my query to perform:
Select * from table where timestamp_field = Date.text
Any help?

Oracle - E-Business Technical Consultant ( send resumes at
solutionsdxb@gmail.com )
* Interfacing with the Finance Functional consultant and appreciating
the needs of the business

10.2.0.3 on RH Linux 4.0, update 4, 2 node RAC. I am experimenting with
ASM parameters, DB_CACHE_SIZE and DB_FILE_MULTIBLOCK_READ_COUNT.
Default cache size is 25M, MBRC is 110. Default block size is 4k.
I have set cache size to 128M, MBRC to 256 (1M reads). I tried going above

I am looking to query the first occurance of a row based on a distinct
column. Here is an example result set:
SELECT * FROM TABLE
ID      Name   SSN