Folks,
  I have read a lot of posts about this error but I am unable to
resolve mine. I just installed an Oracle XE database on Windows XP
Professional. I created a new user gm/gm.  I am able to access the

Platform: AIX 5.3   Oracle EE 9.2.0.6
I knew I'd get bit ...
Database acipmdv on server Dev1
Database acipmdv on server Dev2

Oracle 9.2.0.6 EE on Win 2K
Anyone know if the following "Elapsd Time(s)" and "CPU Time(s)" are
'per execution' or total for the snapshot interval:
        CPU      Elapsd

Os info:     IBM AIX 5.2
Oracle info:     Oracle EE 9.2.0.7
Alert file of physical standby database complains about a gap in the
archived logs but the archived log is not missing, it is there where it

I am assigned this DBA task of upgrading our DB from 9i R2 to 10g R2
although I am not a DBA at all.
My question is, when you upgrade to a new Oracle version, do you
prepare a whole document on the upgrading of your server? I actually

I got a small problem. I have to install Oracle Database Express 10g. I
have done it and everything works fine, but when I want to import the
old database from Oracle 10g, I got warnings during import that
"row rejected due to Oracle Error 12899

My Sql is
SELECT 'x3y2q1__q1',
         partition_name
   FROM all_tab_partitions

I am assigned this DBA task of upgrading our DB from 9i R2 to 10g R2
although I am not a DBA at all.
My question is, when you upgrade to a new Oracle version, do you
prepare a whole document on the upgrading of your server? I actually

Dear Members,
I M working on window98 SE operating system.
I had installed Personal Oracle 8.0.4 for win98 on my home computer.
I had also installed Developer 2000 ver 6.0 on the same computer.

I want to select from a test ride table the data of the last Right
Curve. I can do that by the select as given below. My problem is that
this select is quite inefficient, because the same basic select is
performed twice (once to obtain the time tag and once to obtain the

I want to apologize first, this is probably a stupid question but I am
no DBA and really in need of help =)
We have this client whose hard drive crashed. He had no backups and
didn't even know what version of Oracle he was running (we eventually

Quick Question regarding this topic.  If I have a table that is fixed
lenght (two number(9)) columns and the only thing I do to this table is
insert rows, select rows, or delete rows would I ever want to have pct
free anything other htan 0%?

we are using a program which was formerly using an oracle 8 database.
Instead of oracle 8, we now want to use Oracle Express 10g, but when
using this database we are having serious performance problems with SQL
Updates. In fact, select and inserts are performing quite well, but

I'm not very clear about the concept of build-index and gather-stat.
Grateful if you can give me some idea.
I have a table [user] where [user_id] is the primary key.  Initially
the table is empty.  An application will read from a text file and load

I need help with a query conversion from SQL Server to Oracle.
The SQL Server query runs pretty fast, but when converted to run in
Oracle it performs poorly.  Both versions included below.
Any ideas how to make the Oracle query better?