We are running Oracle 9i on Win 2003 Server.
I am trying to do my first backup using RMAN using the following:
RUN
{

Date - Time Problem
can someone tell me how to avoid ora-01843
The statements works fine against a oracle 9.2.0.1 dbms on Windows
but it fails against oracle 10.2.0.1 dbms on suse linux.

I have an update that I'm trying to optimize.
UPDATE PS_TL_PAYABLE_TIME
  SET PAYABLE_STATUS = 'RP'
WHERE PAY_SYSTEM = 'NA'

I have two pieces of SQL that as very similar, but are treated very
differently by oracle (9.2.0.1 by the way).
This sql was originally in a package.proc.  The real version selects
from more than just the voter table, I have removed the extra columns

Ive been struglling with implementing updateable materialized views. I
have a master and slave database.
I susccessfully created the materialized view using:
create materialized view replication for update as

I installed Oracle9, and instead of running dbca, I created my db
instance according to the docs whereby I copied the init.ora file and
modified the parameters therein to generate the control file.
This worked great, and I was able to create my database, and tables in

we are facing problems and dont know what caused them
We have an application server on win2k3 with 9i thiick client and then
database server 10G Rac on HP-UX, we receive
errors like ORA-03113: end-of-file on communication channel

Folks,
log_buffer should be around 1mb or under in 8.1.7.
Does anyone have any anecdotal or practical experience of what happens
if for some reason it gets set to > 100MB? I know that's a ludicrous

I have been reading the ORACLE fundamentals 1 book and I am just not
being able to find enough information on this issue. I'd like to know
if both the SQL areas of PGA  and Library cache from SGA are capable of
storing binding information and parse trees.

i want to print all the tables names owned by a user along with their
number of rows...
give me query
thankz

We are using ldap naming (oracle internet directory for name
resolution).
Is there a command to dump the whole ldap into a tnsnames.ora ?
(we need to generate this file automatically with a batch)

I'm trying to setup OS Authentication (local) on XPSP2 with SID
remorse, however it keeps failing. The user/machine details are :
USERDOMAIN=FUJWINXP
USERNAME=Sunit

Do you know which view i can select from to know WHEN the job is
created?
Thanks in advance.
-Mike

I'm currently working on a database part of a design projet.
Version is 8174 operating on Solaris 8 on a V880 box with 8 CPU.
DB is in NOARCHIVELOG mode.
Our purpose is to measure overall performance of the software we're

HI everyone, I think this should be easy - my reference book seems to be
discussing using ranking functions to be able to obtain the top N
results.  I'm not sure if that applies here as I haven't done this in
Oracle before.  As an example, consider the following statement.  It