I'm trying to update 2 columns in a table, with values that exist in the
same table under a different key value.
The select ion of rows in the table to update, is made by matching key
columns from a cross reference table.

I'm an oracle novice and I'm a little confused by Users vs. Schemas.
I had thought that User == Schema.
However, while using the schema browser feature in TOAD GUI I noticed
that under the 'Schemas' node there is an entry for 'PUBLIC' for which

According to oracle if SGA size is more then 128 MB then Granule size
will be 16 M.
But in my database:
sys ----- OEMREP> show parameter sga_max_size

Hope this is the right place.  I'm a Windows and Unix sysadmin and as
such I periodically have the need to change IPs.  My Oracle people
tell me that changing the IP of servers in our web tier (Solaris) is
nigh on impossible because it requires a complete reinstall of the

i've faced a problem that connecting sys as sysdba is always giving
ORA-01031: insufficient privileges.
the problem is only occured when using as sysdba on root user. if i
connect using system/blabla, there is no error.

We are using the OCS Suite 10g in Germany.
Are there any other users who will share their experience with me?
(Oracle for Outlook Connector, WebConferecning, Calendar, Files)
Juergen

Does anyone have good performance on this device via NFS?
We never ran Oracle on NFS, but we could not push this device (oracle
on fully populated disk shelve) further than 30megs per second.. On
non-jumbo VLAN it seems to perform better.. NetApp support was fairly

What 3-rd party software would you recommend for backing up Oracle
Database? What product are you actually using and what you like/
dislike about it?

Oracle Application Developer :  Budapest, Hungary
Duration: 6 months
A large renowned international organization have an immediate opening
for a Oracle Application Developer who knows DBA also.

Learn Oracle Database Administration in 10 Minutes. No kidding. Check
it yourself,
http://www.takveen.com
Only good analogy makes complex concepts simple!

Hell All,
To reproduce one of our cusotmer's probem, I need to make the SQL to
run for more than a minutes before it returns the result set. I do
not

I have the following problem:
10.2.0.1 EE installed on W2003 SE 32 bit,
which means a max memory alllocation of
2 GB per process. RAM total: 3,5 GB.

Currently using oracle enterprise 10.2.0.3 on RAC cluster using oracle
recommended strtaegy
of weekly backup up
BACKUP tag='Core_daily_backup' INCREMENTAL LEVEL 0 DATABASE PLUS

[Oracle 9i2 9.0.1.3.0, Windows XPsp2]
The situation is as follows: At a remote site some windows system
dll's got corrupted, the machine didn't start up anymore and they
reinstalled Windows (XPsp2). Now in this situation everything (under C:

how to give execute grant command in trigger as execute immediate is
not working in it.
SQL>CREATE OR REPLACE TRIGGER Try
 2  AFTER CREATE