Ok, I had a running database on ASM, but we had a problem with the
oracle software and we reinstalled.
Now, we have a new working installation, I used same disk group.
This is a test system, but I have a couple of table I want back.

I'm trying to speed up a query that is being generated from an
application.  The application (there the sql itself) cannot be
modified.  Therefore I was investigating using bitmap join indexes to
help speed things up as there are some joins on large tables (700k rows

Version 9.2.x about to upgrade to v.10 on Linux, data warehouse
implementation ....
Seeking advice as to the best method of generating a "table row checksum".
In brief:

I cannot install jvm. Every time I run initjvm.sql I lose connection with
error msg:
ORA-03113: end-of-file on communication channel,
just after following statement:

I have an interface to an Oracle database that displays data in a grid.
The grid displays the first N rows returned by a view.  The view
cross-references 8 tables, all joins are based on primary keys.  Some
of the tables have a considerable amount of data (> .5M records).

Many of our esteemed MNC clients are looking out for Oracle
professionals with multiple positions opening. Please go through the
list below and forward your updated word document CV if any of the
profile matches your requirement. Please email your CVs to

I am troubling in getting reference of an user defined type after
inserted it into a table.
For example, I use a java program to insert an user defined object:
.

How do i tell when (what date) a dbms_job is created? Which view or
dictionary view provide such info.
Thanks in advance.
Mike

I'm running 9i on a Unix AIX 5 system. I have a logical volume that is
getting full and have created a new volume that I want to start using.
I want to create a datafile, on the new disk, for each datafile that
existed on the old disk. After doing this how can I insure that I wont

I have oracle server already, and I need software to install onto
client site, so client can talk
to server to do query. Would anyone please point it out which software
should I download from oracle.com?

How can I remove all tables
UserName.TblNam1
UserName.TblNam2
UserName.TblNam3

Does Oracle Ship any odbc drivers as part of their installation on UNIX
(solaris,linux,hpux,aix)
(or can it be downloaded from their siter)
As far as I could see there was only odbc drivers for windows

When I execute  'select '*' || to_char(33,'0009') || '*' from dual
I get '* 0033*' instead of '*0033*'.
Does anybody know what might be wrong? Something wrong in my configuration?

Is there an SQL command that will tell me who I am logged in as right
now?
Thanks for any tips!
Dean

Next Tuesday, on the same day as the Steve Jobs Macworld Expo keynote,
Larry Ellison and Scott McNealy are holding a town meeting for
employees at Oracle's headquarters, which is in close proximity to
Sun's. Here's the preliminary description from the e-mail invite: