just a quick one hopefully....
If I perform a full export of a database on version 8.1.7 and then
perform a full import of that resultant file to a 10.1.0.3 database
which has already been created and contains all the relevant tablespaces

Is it possible to get Oracle to join 2 tables (in a
nested loop for instance) but using at the same time
an index UNIQUE SCAN ? Or will it always use a FAST
SCAN in a join (and the unique scan is only possible

what is the 'de facto' query-tool for Oracle?
Requirements: Objectbrowser, should be able to export query-results to
file, save query's, load query's from txt-file.
As DBA I'm really amused from TOAD, but is this the right thing to

First of all I am not a Oracle techie so please excuse the lack of
technical knowledge.  I have the following problem.
A disk was running low on space to I did a check of file sizes.  The
UNDOTBS01.DBF turned out to be 7gb.  That is huge given that the files

  There is an interesting question come up in my work.
In my work, there is different kind of DELETE_RULE, like
"ON DELETE CASCADE" and "ON DELETE SET NULL".
But after create table with these 2 different constraints,

Get lots of crazy erros on server reboot. Running 9.0.2, this is a
backend for a mission critical spatial database. Unfortunately, there
is no budget for a bona fide DBMS admin....
I'm kinda desparate here, we have rough backups of the raw data, but

Is anyone running Oracle 10g RAC on multiple small servers (2 CPUs
each)?  What has been your experience with performance?  Type of
servers?  O/S?  Number of servers?  Scalability as you add additional
servers?

On 9i i had this nice gui which I could start with "oemapp dbastudio" on Linux
and it made it pretty easy for me to play with tablespaces, redologs and all that.
Is there any equivalent for 10g? I don't want to use the full enterprise server just
to manage one database.

I have the following senario at work
Table 1 - Visits with columns Visit_id*, Visit_description
Table 2 - Patients with columns pat_id*, event_date, visit_ID
* primary keys

Hallo all,
I'm using Oracle DB v. 7.3.4.5.0 (On Unix). Clients run on WXP boxes.
I'm wondering about perfomance of fetching data from tables containing
column of LONG datatype. Most significant impact of this behaviour is

I have a database (Oracle 9i) with approximately 100 tables in our
production facility and need to replicate most but not all of the
tables to a database at our preproduction facility.  We can't overlay
all of the tables because certain preprod tables contain important info

With sqlplus I can do "COL mycol FORMAT 999,999,999" to format long
numbers with commas.
How can I do this from within code? Do I need to just select the column
and then use logic in the code to reformat the numbers?

is there any simple way to recover database after disaster?
now i tested procedure /below/ , it seems is OK, but
http://localhost:5500/em ... doesnt work...
procedure

I am trying to compile demo code with Oracle 10.0. I downloaded the
information from this web site address:
http://www.oracle.com/technology/sample_code/tech/oci/index.html
I am getting the following errors when I try to compile cdemodr.c

we have an Oracle 10g database here and want to use the resource
manager. We created a plan and set PARALLEL_DEGREE_LIMIT_P1 of a
consumer group to 1.
What we wanted to achieve is, that each single user of that specific