I'm trying to pass "20060821" as myUserID from a web page.
The problem is that it does NOT find any records.
I think it is in my First SQL statement.
What I'm trying eventually to do is to LOCK QTY on hand and subtract

It's my first post here. I'm trying to install AS on W2k3 but on the
final screen an error occure:
Configuration assistant "OPMN Configuration Assistant" failed.
What should i do? I have no experience with AS. Thx for any help.

I have some basic oracle question :
1) When do we use NUMBER and NUMBER (n) ?
2) For surrogate key, is it better to use INTEGER, or NUMBER or NUMBER
(n) ? why ?

I did an import that failed to extend the UNDO segment of my database.
I realize I need to use commit=y to overcome this issue.  However, the
database is rolling back the records it imported before hitting the
error.  This can take several hours.

I am facing this error regularly now.
I just want to know how to catch which user is causing this error.

Please tell it how to trace commit by any user.
Means if any user commiting data again and again then how can we trace
it ( How can u come to know who is doing this again and again ).

10g
hi does this mean 4 instances on this box ?
[klabu:~]$ps -ef | grep pmon
 oracle 10752     1  0   Mar 17 ?        1:34 ora_pmon_AKA01D

I'm looking at upgrading the Access database I use at work to Oracle,
now I can import all the tables and data okay but what I am having
trouble with are the constraints.
In my main Access table I have validation rule for 2 fields that are

is there any 10g Express Edition ODBC driver for Linux ?
It seems yes but how to proceed ?
Thanks,
Bruno

In Oracle 9i which data dictionary view/table I need to query to find
out the table is compress/nocompress.
In Oracle 10g the following query is working fine but when I use same
query in Oracle 9i its not working

10g
Is there a way/view to find out from WITHIN Oracle (i.e. No access to
OS)
How many CPUs on the server ?

Can someone convert this to an Oracle-SQL update statement?  The goal
is to update tblWORKER.PER_TYPE based on the case statement.  The
essentials are there but I haven't been able to get the correct syntax.
It was works until the WHERE EXISTS clause is added.  Any ideas?

Environment as in sig.
Can anyone point to the correct way in handling this? This is data being
POSTed from an HTML form (mod_plsql / plsql web toolkit):
The variables

Hi all and sorry for my english
I have a table usually empty (0 rows) and the statistics know that
In a job i insert into it many rows with an 'insert into table select from
.....' for example 2000 rows

I have Oracle 10g (10.1.0.3.0) running on RHE box. When I perform a
pretty simple select, even like select * from dual, I see that Oracle
stops for 2-3 s. and not responding, then it's OK. This happens every
4-5 correct selects.