I ran the following command, "Duplcate target database to dupdb
nofilenamecheck".  I received the error that no log files were present
or unable to preform media recivery because of missing log.  I have
now copied the archive logfiles over to my dupdb server.  waht command

I have a duplicate database already setup that uses trhe same DBID.
If i want to synch that database I found in the books that I can run
the following commands:
# start RMAN and then connect to the databases

We have this HUGE query.  It is dynamically built, so it will be
different each time.  The problem is, we need to order each query, not
the entire UNION.   So, each select needs to have it's own order by.
Can this be done in any way??

Oracle9i Application Server
http://freedownloadablebooks.blogspot.com/2008/02/oracle9i-application-server.html
Summary of Oracle Features
http://freedownloadablebooks.blogspot.com/2008/02/summary-of-oracle-features.html

i was looking around for oracle user groups in vancouver, b.c. but
there doesn't seem to be one...
there's one in victoria, but i'm curious if there are any other groups
nearby.

My platform is
Windows 2003 Server Enterprise Edition
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
I'm using Oracle Objects for OLE, version 11.1

Ok, I need help with this.  Here is my data:
TABLE A
---------------
2468

I can't do a create table in a package procedure. A drop jedoch is
possible.
With google I doesn't find any hint for a necessary privilege.
Here is the test package:

I get error message when using "recover database until scn ...." as
below:
------------------------------------------------------------------------------
RMAN> list backup;

Has anyone seen this before?  It seems new to me:
We're running Oracle 10.2.0.3.0 on Solaris.  We had statspack turned
on; now we wanted to turn it off.  I removed the job, and then I
wanted to clean out the statspack tables.  After doing so by simply

I'm a newbie in oracle & try to change undo_management=AUTO to
MANUAL.  I know that Oracle recommends AUTO, but I just want to test
the procedure to change.  Below are the steps that I follow & it's
fails to startup DB.  By looking at the log file, I know that missing

We have this HUGE query.  It is dynamically built, so it will be
different each time.  The problem is, we need to order each query, not
the entire UNION.   So, each select needs to have it's own order by.
Can this be done in any way??

To all,
I had a vendor tell me yesterday, that it was a good idea to name all
of your database related files *.dbf, including control files. This
immediately set off a red flag as it violates OFA. Anyone doing this,

Quantix are one of Oracle seven Certified Advantage Partners in the U.K and
we specialise in providing best value licenses and support for Oracle
Technology Licenses such as Oracle Enterprise, Standard Edition, RAC and
management packs.  

how can i design a front end in oracle