A weird thought...Am trying to resize the redolog file using
following..i know it doest not happen..then only way is to drop and
recreate the group member..but why am i gettin
that error about nonexistent log file...just wanna know under the hood

HELP! Okay, I am doing a simple update statement in which I take a
decimal field and multiply it by an integer field to populate into a
decimal field. Here is my example:
update tts_hlpdsktkt_acq_quotelines

Enybody know whot I must change in Oracle Reports or in register Because I
must print from Oracle Reposrt in russian language!!!!
Thanks!

I am currently configuring a server with over 200 "Oracle in OraHome92"
System DSNs.
As you can imagine this is a long and loborious process so to alleviate
that as far as possible I have created a dos batch file which uses the

I have a field defined as follows:
id integer
This field normally has some value in it 1,2,3,4, but it can be null.
For example, say I have 10 records, and 5 records have values

we have a table of usage
date_time               in_out          user
9/1/05 13:22            in              joe
9/1/05 13:21            in              sue

I have two ora 9.2 DBs, and simply want to copy one to another. The 2nd
DB doesn't necessarily have all the same views and such, but I'd like
to just force it to be an exact copy, if possible.
I do have SYS login capabiltieis on target DB.

Here is what im trying to do, the SQL statement looks like this..
select count(projectid) from project
where contains(objectives, 'agent', 1) >0;
COUNT(PROJECTID)

SQL*Plus: Release 10.1.0.4.0 - Production on Mon Sep 12 18:09:39 2005
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

I got an error message when updating my program from AIX 5.1 to AIX
5.3. It uses Oracle 8.1.7.
The following error message appears:
----------------------------------------------------------------------------

I am going to be doing some development work on Oracle in a few weeks,
and I was wondering what the feelings are regarding the minimum server
spec for running Oracle Versions 9i and Oracle 10g, where both are the
bog standard version of Oracle (no enterprise, web enablement etc etc) ...

In PL/SQL, I want to access the columns of my resultset by index. I'm
dreaming of something like this:
for rec_data in cursor (select * from postal_address) loop
  -- examining the structure of the resultset:

Hello, I've just started using Oracle and I'm using the command line
client SQL*Plus to teach myself basic SQL.
As you know, you can write command files containing queries that you
can execute by performing:

1)
select GPRS_CO_MSISDN
from GPRS_SERVICIO_GPRS
where NOT EXISTS (select 1 from SAPN_SERVICIO_APN

Oracle 10.1.0.4 EE on RHEL 3
Oracle claim that Data Pump is a considerably faster method of loading
and unloading data to/from the database.
However my first 'play' with the tool shows the opposite: