I am very new to oracle and I am trying to give 7 users the ability to
create tables (this is for a DB class).  I have went and created the
users and assigned them default tablespaces. When they log in, they
cannot create tables.  It gives the error: ORA-01950: no privileges on

We are currently using 10g (10.2) w/ ASM (on Solaris 9 and 10) and are
looking to acquire software that will work with RMAN to backup our data
to tape.  We currently own NetBackup, but do not have a full license
for the Oracle agent.  We were able to acquire a temporary license in

I'm using Oracle 10g (10.1.0.2.0) database.
Our network contains one single Master, and several Replicated sites
with updateable materialized view. All MV's are defined with fast
refresh.

I can't do troubleshooting for a couple of days so any advice, input,
insight, etc. is greatly appreciated for the troubleshooting exercise.
I've googled, metalinked, etc. The problem does not occur in
development/test, only in production (working on app support to get the

I need to upgrade a large 9i database to 10g on a Sun Solaris system.
Because this database is so big a simple full export/import technique
is not an option.
I know one initial step is to install the Oracle 10g product into it's

   I am running oracle 8.1.7.4 (32 bits) on solaris 5.9 platform.
I have a 115 GIG tablespace (ABC), and
I would like to find out the biggest table in this tablespace.
I am not counting the number of rows(records).

I want a solutions for a compicateds sql select statments.
The selects can use anything : views, stored procedures, analytic functions,
etc...
(not use materialized view, unless it is neccessary).

I've inherited a monster table, and have to make a decision about
how/whether to normalize it.
It has 50 FK columns, each one with a FK constraint and a supporting
index. The worst thing from a design perspective is that in each row,

Suppose I had 4 tables like
tbl_a:
num
tbl_b

I have a complicated question which needs to be solved. I was using a
dynamic query which was working fine, but due to performance issue it
needs to be changed to a static query. But the values returned by a
dynamic query is differing from that of a static query.

I've been searching for a book or two on Pro*C, and so
far all I've come up with is "Oracle Developer's Guide"
at amazon.com.  Unfortunately, it seems dated, and
covers Oracle 7.  Can someone please recommend any

Folks,
  I inherited an application that has 1 very large lookup table.  This
lookup table has
  a 90/10 read/write ratio.  Most of the time it's read heavily, but

    I'm currently supporting a mixed OLTP/DSS'ish type environment.
The environment
    is 10.1.0.4 on Solaris 8 64 bit (10 cpus).   The environment is
about 75% reads.

Oracle Database 9.2 on Solaris
I perform daily database export (exp) with the following parameters
CONSISTENT=Y
TABLESPACES=users,others

We are running Oracle 9.2.0.7 on AIX.  We are trying to apple the
latest patch:  4759123 - CPUJan2006
We receive the following error from OPatch:
System Command: /ora2/app/oracle/product/9i/jre/1.4.2/bin/java