Oracle 10.2.0.1 EE on RHEL 4
We have a very large table which is partitioned by range and then
further sub partitioned by list.  All indexes have been created as
locally partitioned but the primary key is a non-partitioned (global)

Is anyone aware of a way to compare Oracle databases (schemas and
content)? I found a .net software DBTyP.net that promises an easy and
visual comparison, but it seems not to be working with Oracle dbs
(though their site outlines it as one of the available options).

I fetch some parameters from a table which I use as GET-Parameter in an URL.
Unfortunately there are sometimes special characters like 'ä', 'Ö', 'ü'
included so I have to url-encode these data during the generation of the
 URL.

Is there a Windows GUI pivot table tool that has the fuctionallity of
pivot tables in Access (user can choose which fields to use in the
pivot table, filter the data etc.)? I could of course connect Access
to Oracle but this would mean that Access would read a huge amount of

DEFINE _SQLPLUS_RELEASE = "1001000500"
DEFINE _O_VERSION      = "Oracle Database 10g Enterprise Edition Release
10.2.0.3.0 - 64bit Production
I have a clob.  I save data in it, and then I want to get it back out.  I

Can someone share a link that will make this beast easy to understand
for users of a superior product :)
Particularly interested in 'how to tune', but 'general concepts' will
do as well.

is anyone aware of a tool which allows to load flatfiles into an
Oracle 9i-DB via a GUI?
SQLLDR is great, but since I have to load many files with different
structures I appreciate something more efficient...

If I do an explain plan of the statement below I can see that the
"and" clauses that have MMDDOB=NULL do not get executed
select * from v_search where
UPP_FIRST='JOHN' and UPP_LAST='SMITH' and MMDDOB=NULL and AA=1 or

Hi ng,
(Oracle 9.2.0.7i)
I talk about a database concerning real Trees.
There is a table TTrees.

Perhaps a bit too much, if you get my drift.
http://members.aol.com/annika1980/ohdaddy.jpg

Oracle 9.2.0.6 on AIX 5.3
I have a problem that i don't understand
I have a table with these values :
PCTFREE 10

Often the archive log destination is not really meant to be able to
hold a week worth of logs.
How can we redirect media restore to some temporary mount?
Alternatively, if I am just recovering a couple of blocks.. why can't

Cary Millsap leaving Hotsos and starting a new company?
http://carymillsap.blogspot.com
The timing is extremely conspicuous. We all remember Tom Kyte's "taking
job with MS" on 4/1/2006. Does anybody know more?

Hopefully, I frame this problem/question correctly.
I have some code written/updated in visual studio 2003. This code when
setup on other machines where I have installed the Oracle 9i client,
and the Oracle 9.? odbc drivers will connect to my oracle database

Hi Dear All,
Hope you are doing great. This mail is about Oracle BI (Siebel
Analytics) training we provide. We have all setup and experts
faculties to provide these kind of training.