I made a table with 1 blob  field, and a specific lob tablespace to store
the lob column.
If i insert a row with nothing in the blob field, 1 MB is reserved for it in
the lob tablespace.

I'm teaching myself oracle and I am looking for some easy to follow
step by step tutorials on oracle and sql. I already found a few good
introductions which cover the basics (and possibly more) but the ones
I have found so far seem to leave a lot of questions. Two things I

After upgrading from Oracle 10g 10.2.0.1.0 to 10.2.0.3.0 I am no longer able
to use DBCA to create a new database. I believe the problem is the
10.2.0.3.0 patch set does not upgrade the seed database used by DBCA from
10.2.0.1.0 to 10.2.0.3.0. Thus after DBCA completes the DB ...

Dear group,
I want to maintain a table, so that if people in this table, they can
logon using sqlplus, if they are not, they can only logon through our
application server.

I am using 10g.
I am running a test. I want to create an explicit cursor. Then I want
to put the data that is in the cursor into a table. The problem is
that the table has a lot of fields. I could put the data into

I have huge number of data coming to my application through a bacth process
in main frame. Assuming that all this data are available in one table, I
have a PL/SQL procedure to manipulate the data and do some data massaging
and put into three tables.

Let's say the network between my (physical) primary and standby
databases fails.  Can I perform a switchover if I shuttle the archived
redo logs from site to site by some other means?  Here's how I see it:
Switch primary to standby.

PeopleQuest Staffing is currently looking for highly organized multi-
talented Software Programmers with extensive IT experience for our
client in West Houston, TX.  This is a Contract position with one of
the Nations leading Energy Solutions providers.  Please read the

I have a feeling I know the answer to this question, but I am
struggling to find a confirmation.
Oracle 9.2.0.8.
If I have a partitioned table (list partitioned), several local

I have a grid control agent running on a host. this agent is secured
to an existing grid control configuration and it works fine. I have
installed and configured a new instance of OEM grid control on a new
and powerful server. I would like the agent to communicate to he new

My procedure below is failing to provide the desired result and I've
failed to track down what is the cause. The procedure is supposed to
dynamically grant roll on objects to users. I've tested the cursor SQL
and it's working fine. However, sql_stmt is failing. When I run the

A post I sent earlier seemed to be construed as spam,  I apologize and
will repost in the marketplace.
-Corey

We are running Oracle RAC 10.2.0.2 and we received
a note from Oracle to apply CPU 2008 upgrade.  However,
this upgrade requires Oracle RAC 10.2.0.3.  So we are now
trying to schedule upgrade of 10.2.0.2 to 10.2.0.3.

We have an insert/update transaction that normally takes 0.2 seconds
but
sometimes takes as long as 16 seconds.  The granularity of statspack
is 30

We use Oracle RAC 10g on Windows. Everyone seems to complain about the
Windows aspect of it. I am just curious.. is it really a bad mix ? People
complain only because my DBAs do not come from a Windows background.
Let me know