I can't get this sql to work properly. I would like to update the
FSA.RESOURCESTRING with FSA.ART_DATA.ID || "-" || FSA.ART_DATA.ISSUE
based on the criteria below.
UPDATE FSA.ACCESSLOG

Went back to a package for the first time in a couple of weeks to make
some tweaks and all of a sudden the package hangs if i try to view,
drop or recreate the package.  Has anyone else come across this or got
any idea what might be causing it?

I would like to call 'shutdown immediate' in my proc program but I
could not figure how to do it. Tried calling it using EXEC SQL but it
failed with
"ORA-00900: invalid SQL statement".

I'm writing an app that will be a simple server communicating with my
pl/sql procedures via tcp/ip (utl_tcp package). How can I cause the app
to start up along with the Oracle after e.g. machine reboot?
thanks for any help

The server (10.2.0.1.0) and ODBC (EasySoft Oracle ODBC driver, v3.0)
application run on a RHEL4-x86_64 box.
We're seeing TX locks remain in the database when the ODBC app is killed
by ctrl-c.  The DML is being performed by stored procedures.

Can anyone point me to any reference material highlighting the use of
10G OEM while managing 9i databases (good or bad idea, what is gained
or lost)?  We are in the midst of an upgrade and are currently on 9i.
In the meantime, we are installing OEM (preferably 10g).

Hi folks, I'm new here, and I had a question, hopefully not too
dumb/ignorant.  :)
We have two Oracle RAC Clusters running Oracle 10g and an Oracle
Enterprise Manager/Grid Control server from which we normally manage our

Is there any documentation on what operations have a severe impact on
the system and what ones are low impact? I know that most maintenace
should be done on downtime but we really don't have any, so I'd like to
have a reference of how bad performance is going to go down the tubes

I am not sure if I'm correct but it's possible to set up many oracle
databases on a single machine each will be accessed through different
net listener , right ?
how can I enumerate all oracle db running on a machine? is OCI helping?

I have RMAN restore question.
How to restore from exact backup file?
For example I run script
RUN {

We are using Oracle 9206.
Because of a block corruption recently, we have to shutdown a mission
critical database for a few hours.  Now we are planning to have a standby
database to prevent any downtime.

I have just recentely become an Oracle 10g database administrator and I
have been having problems connecting a clients to our DB.
I have installed the instant client but I am getting the ora-12514
errors (unable to resolve the TNSnames, etc...)

I'm trying to use a query analyzer on some pre-existing procedure code
and can't get past this message.
"Describe Error: Failed to execute EXPLAIN plan: ORA-00905: missing
keyword"

This is a consolidation and refocus of a prior thead ...
Replication environment ..
 Master site: Oracle 8.1.7 on Solaris 9
 MV site: Oracle 10.2 on Win2k3

I have a text file populated with hundreds of id numbers(one entry per
line). Now I want to execute against a database a query in the format
"select name, id from employeeTable where id in ({--contents of the
text file--})". What is the most effective way of doing this ?