when I am connected to a 10.20.4 database
with a 9i client, the purge command doesn't work:

SP2-0734: unknown command beginning "purge dba_..." - rest of line ignored.

I have a Windows XP machine that never had Oracle on it before.
I installed Oracle 11g and everything appeared to be going smoothly except
towards the end, it could not start the DBConsole.
After the install was complete, 'oracle.exe' was taking 100% of the CPU

Group,
I have a database at Site1 stored on a SAN, and a disaster-recovery
site2 with identical hardware. They are connected by high-speed fiber.
(Both SANs are enterprise-class with full journaling capabilities in

I have a table T with columns A, B, C and an index I over all three
columns. Further, I have a query which uses columns A and B, but not
C, i.e.
SELECT * FROM T WHERE a = ? AND b = ?

Does Oracle 10g have a so called "natural sort" feature? E.g.:
    foo1
    foo2
    foo10

I am working on a 10.2.0.3 ee database on windows 2003
A tablespace that was available in 8i has been taken offline
( alter tablespace RBS offline )
..in anticipation of  dropping as it was thought it was not being

After having upgraded from 10.2.0.3 to 10.2.0.4 in our programs on different
sites we have sporadic errors of the following type:
ORA-12899: value too large for column
"ISC"."AUFTRAEGEDURCHLAEUFECHECKS"."ADCABRRZDATUMSTORNIERUNG"

i want to know what is concept of table in Oracle?is there any
relations to segment?

I understand I can configure server-side TAF with
DBMS_SERVICE.MODIFY_SERVICE. But how do I query current failover
settings?
We have 11.1.0.6 Standard Edition running a 2-node cluster on SuSe 10.

I've configured openldap to store information from tnsnames.ora.
See http://oracle-cookies.blogspot.com/2007/01/get-tnsnamesora-from-openldap.html
for details.
Then I configured Naming Methods via netca as follows:

I am used to "SQL Server 2005" and have just installed Oracle 11.  I wonder
how/where I can do "normal" things to find performance issues in my SELECT
quereries:
A) In "SQL Serve Profiler" I can see all my SQL queries from my program and

report builder 6 (I know this is way old ...)
This is probably simple, but I didn't find a solution:
I've got a repeating frame containing a number of records. Below
there's a single frame containing  a totals line:

perhaps I'm doing the wrong thing here, or perhaps the system is detecting my
downloading from a windows platform, but when I go to:
http://www.oracle.com/technology/software/products/jdev/index.html
it says:

I am learning Oracle, my PM asked me the following question, Please
help me on this :
You are a new employee at the company and the only Oracle DBA.
You were just informed by the management that one of the Oracle

I have a CSV file which need to be loaded into database using SQL
loader. Below is my flat file data ...
I have three fields in CSV - Add1, Add2, Add3. I am able to map Add1
and Add2 to Address1 and Address2 columns in my table.

Afternoon All,
I've recently been impressed by the oracle tools for .NET plugin for
visual studio 2008/2005. At the same time, the oracle offering (SQL
Developer) hasn't been well received by our oracle guys.