Could you please tell me (step by step) how to uninstall Oracle 8?
I have it on two computers with Windows NT 4 and Windows XP Pro.
I'd like to remove it from all places (directories, registry, services,
path etc.) on both computers.

I know how to use the spool command in sql*plus to save the results to a
file.  But myquery is returning about 63,000 user IDs.  I need these in a
text output file that can be imported into a utility to correct a problem
we're having.  Using the spool command includes line numbers ...

I know if I am doing RMAN backup and
then one file do an "autoextend" , then RMAN later on will complaint.
RMAN backup will fail.
But I never do a RESIZE on a datafile while RMAN backup?(probably RMAN

Can the new column PLAN_HASH_VALUE of V$SQL be used
to join this table to the various V$SQL_PLAN* tables
(SQL_PLAN, SQL_PLAN_STATISTICS & SQL_PLAN_STATISTICS_ALL) ?
Thanks.

what is the product i had to download to install oracle IAS on AIX 5.2
I would like to install just oracle IAS (8i, 9i and 10G)
thank's

Is someone aware of a dbms_ package, a dba_ view or
anything that I can use to resolve a string to
an actual object.
I face the problem that I have some string, for example

I have some basic index questions that maybe someone can help with. I
am just trying to get a better understanding of how this works (without
becoming a DBA). If I have a table with fields A, B, and C and it has
lots of records. Field A is mostly the same value, field B has a mix of

What I am looking for sample code that does the following:
A query (created in C) that uses the following definition for a table:
create table foo (
SampleInt integer NOT NULL,

I am new to Oracle and trying to migrate a SQL database to Oracle
database. However, I stumble over SQL Double datatype which is of range
-1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and
2.2250738585072014E-308 to 1.7976931348623157E+308. I look everywhere,

i want to install Oracle 9.2.0.4 x86-64 on a Linux 64 bit engine (suse
linux 9).
It is the gcc compiler whith version 3.3.3 installed.
When the Oracle-Installer compiled the extproc file the log-File shows

Recently I've been setting up the Oracle multi-site replication based on
Single Master Replication. It works fine apart from it can not replicate
indexes (ex. primary key indexes). It would be a bit overkill to upgrade
to Multi-Master Replication just for indexes replication. Is ...

I've installed 10g on XP Prof and before reboot everything worked ok
sql plus and  Webadminconsole. After reboot I'm just able to access
data via Webclients (Admin or isqlpplus) but I'm not able to access via
console sqlplus ore ODBC.

Not same guy as the other one.
I won this as part of Oracle Developer Days.  I'm taking the best
offer.  Time's running out.  Be a shame to pay $1970 when you don't
have to.

I don't want to grant the users access to views such as dba_triggers
or dba_constraints. But there is requirement that the user needs to see
the triggers owned by some other schema. Is there a way for a user to
see the data from all_triggers when he doesn't own the trigger? Any

I have a stored procedure sp_example().
In this procedure sp_example, i have another procedure sp_shell()
sp_shell call a Unix shell script
it works fine, but