I am new to oracle so this question might sounds easy.  When I
installed oracle I set up passwords for SYS and SYSTEM accounts.  When
I start sqlplus from command line and try to log in using SYS it gives
me the error messages:

I have to create in instance on which I'll have euoropen characters and
kangi charactes (english, italian, french ,german ,sweden and kangi ...)
is correct to use utf8 character set ? or is it better to use al16utf16
by

OS:  SunOS 5.10,Sun-Fire-V440
Oracle: 10.2.0.1.0
A couple of months ago we had an issue on this server with the OS
claiming we were running out of space on the file system holding most

Oracle10g 10.2.0.x 3-node RAC (64 bit)
RHEL AS 4.4 (64 bit)
Even though I started trace (alter session set events '10046 trace
name context forever, level 12';) through a logon trigger for the user

When we set the following parameters on the client machine with alter
session it works fine and we get case insensitive searches but when we
try to set this in spfile it only affects the sessions on the database
machine:

Hi iam eswar a student from electronics stream. Iam given a project of
patient management system in ahospital as a project in my
curriculam.right now I dont know  A B C s of data bases ..
I know c,html,php,javascript...Where could I get the complete

We sometimes use rman duplication to refresh test/dev databases from
their production counterparts. This creates a new dbid for the copied
database which effectively orphans the old dbid in the rman catalog as
well as it's associated backup sets. I want to get rid of these old

The server is running Windows 2003 advanced server, 8GB RAM, 8 3Ghz Xeon
processors, /fastdetect and /PAE switches are in boot.ini
Database is 9.2.0.6, shared pool 400 MB, buffer cache 800MB, large pool
8MB SGA max size 1505 MB - Typical number of connected users is between

Here is the problem I am facing.
A perl script hangs when executing the following piece of sql
$lsql = "SELECT NVL2(partition_name,
                           segment_name || ':' || partition_name,

9.2.0.5 Ent Ed AIX5L
I am trying to import statistics using the
dbms_stats.import_schema_stats procedure from one db/schema to
another. The procedure died with an 'ORA-20000 Schema TRDTA does not

Why the "DBA" in charge of a database would not use RMAN to back up a
database?  It currently takes nearly 24 hours each weekend to do a cold
backup.
When I questioned why about all the answer I got was that the RMAN catalog

Oracle 10g XE does not support Java nor Streams. However, Oracle
insists on assigning 1 dozen MB total for them even is the
corresponding *_pool_size are set to 0. Isn't this a bit stupid?
SQL> select * from v$version;

How can I write the number from 1 to 1000 on the screen like the
following in Oracle ?
12345*678*910111213*141516*1718192021*....
Please help me...

Can anybody please look into this.  I have installed oracle 920 on
Redhat ES 3.
But while invoking sqlplus I am getting this error.
##########################################

oracle 9
I have a table  with task_id , order_id , and status in
My problem is I only want to get orders out that have all "COMP" or ALL
"COMC" or all are "COM*"