I want to export all the tables from my schema apart from one(which is
huge).
Is there an easy way to do this or do I need to list all the tables I
do want?

Recently Quest changed the freeware version of TOAD to make it more like the
licensed version.  In the SQL editor, it used to have the capability to
format the SQL code and also to build it into a VB script.  I can't find
either of these features in the new version.  Am I missing ...

Anyone running 10g in a cluster environment?  I'm trying to decide between
AIX or W2K3 for my cluster.  Any tips, advice, horror stories, etc..  
Appreciated.  The DB is mission critical and HA is a mojor concern.  The DB
currently runs on a standalone AIX box.  Typically, this ...

I'm running a test database to practice installing patches with Opatch.
It's 10.1.0.2.0 (10g Enterprise / Win XP).
I can run "opatch lsinventory -detail" with no problems.
When I run "perl opatch.pl apply" from the directory where the

          Iam new to Oracle and would appreciate any clarifications on
these doubts I have:
1. Iam reading the documentation and it says that Oracle DB Server is
basically Oracle Database and Oracle instance. What I understand is

 I'm running Oracle 9.2.0.1 on Windows 2k.  After I initially
installed it, everything seemed to work fine.  However, now ( a couple
of weeks later) whenever I try to connect to a database in Enterprise
Manager, nothing happens.  I launch standalone - no Oracle Manager

I have a many to one relationship where I'd like to convert the rows to
a list format.
I currently use a function, but using that function slows the query
down.

We have oracle 8i and use snapshot replication which gets refreshed
every 4 hours.
We need to have one MV belonging to the refresh group to be refreshed
on demand when a user does a certain operation.

i was installing a critical patch update 4392446 on oracle 817 ,HP
UX(64 bit)..
It worked fine while installing on other 817 and 9i databases..
But while installing on oracle 817 ,HP UX(64 bit)..

I have a cf query where i want to set the date format before the query
executes.
<CFQUERY NAME="RptQry" datasource="#ds#" username="#user#"
password="#pass#">

Why do we have to opne database using resetlogs after recovery from
Backup control file? It makes sense to use resetlogs after
incompleterecovery, but not sure after backup from control file.
THANKS A LOT

I am writing a script that will bring Oracle 9i or 10g up or down.
Generally I reverse my actions to bring the services down.  I notice that
after I bring things down that there are occationally processes left
around that appear to be part of Oracle or are at least owned by

Can anyone help.  I have a requirement to gather stats in prod without
the values being put into the data dictionary and used immediately.
Instead I'd like them to go into a user stattab from where I can move
them into a non-prod instance.

Ok iv'e been working on this problem for some time now; and haven't
really figured anything out. I need to run my ref cursor multiple
times, depending on how many of the check boxes the user selects. Let
me example, I have a form which has four check boxes, with a text box.

I have a very specific problem with oracle 8.0.4.
i have following view
cum_fifo_figures
(