I just dropped varchar2 (50) column full of data on a couple of tables
(approx 3 millions of records total) in my tablespace, and now I would
like to "defragment" the 10g database.
Toad 8 that I use shows tablespace Fragmentation Index = 33.57 and

We are running Oracle 10g on a Quad Dual Core Windows 2003 x64
Enterprise Server with 16GB of memory.  I notice that the Oracle
process is only using 4.6 GB of Physical RAM and 10GB of Virtual
memory.  Performance monitor is showing that the server has 8GB

I am using Orale9i and Oracle 10g on Windows and UNIX boxes.
When creating new indexes which are non-unique, what are the
pros and cons of creating a single index of multiple columns vs
creating a separate index on each column.

 On POWER6 I have aix 5306Sp3 and oracle 10.2.0.3.When I run simple DML
opration on database CPU use 50-100% and has not finished. Truss output
command on this process:
kread(0, 0x0000000000000000, 0) (sleeping...)..

I am new to using Oracle and I am using 9.2.0.7.  Basically I did a
coldbackup of all the datafiles (except for the UNDO), control files
and spfile of my database.
I accidentally overwrite one of the schemas by mistake.  I need to do

I can log in to SQL+ as user A and select * from V$SESSION. However,
when I try to do the same thing from an application (logged in as same
user A), I get a table or view does not exist error. The app uses ADO
to connect.

I need help to decide what is better.
I have a tableA which has id primary_key, and id_2 which is not unique
and can be NULL,
I have altered the tableA adding column colC, colD, colE

I am wondering if anyone can find a simple solution to this SQL query.
The end of goal of the query is to give me a count of distinct cust_id
for each ctype and order_date, for a set of ranges. For example, I
want an example record in the end with

www.bootstraptech.com
Bootstrap Technologies Private Limited, Global Systems integration and
IT Services Company with a Focus on Enterprise Applications Space
looking for Aggressive offshore expansion plans for their Hyderabad

The 11g docs have not been added to the tahiti site but can be found at:
http://www.oracle.com/pls/db111/homepage
I've also put a link on the PSOUG home page ... click on the 11g icon
(top-center).

Dear Group,
I am strugling get the following done in SQL. Could anyone help me to
figure out a way?
Oracle version 8i .

Isn't it possible to backup an existing table using the following
syntax?
create table mytable_backup
as

Does anyone have an easy inline REGEXP_REPLACE() (or equivalent)  that
will strip out unwanted HTML tags?
I've been trying the following variation, but I suspect that I'm on
the wrong path.

I would like to insert a row into a table, but only
if the primary key does not exist.
For example, if I have a table "keywords" with
columns "name" and "val", I would like

I am trying to rebuild an index  in a procdeure but some how getting
the error below
ERROR at line 1:
ORA-01031: insufficient privileges