Hi, I need to find a good sotware to manage database changes. I've used
ERWIN years ago to do reverse engineering for Informix DataBases in
order to print good looking database diagrams and other stuff, but I've
never work with oracle. Can you recomend one thatr works well with

I have a query that can return a few hundred rows (< 500).    Is there any
way I can then apply a filter on top of that result set to display only a
specific number of records ( < 20), based on some filter criteria the user
provides.  I rather not be requerying the database all the ...

I am trying to run the RMAN backup from a script (unix). i wrote a
small script (sh) with following commands:
rman TARGET /
RUN { backup database;

[oracle]
Does anyone know how the wrapped package, unwrapped. Mayby  somebody
knows  some tools  or programs who do this ??
Thanks for any help or some information.

I write from Italy and with this procedure I want send a E-mail from
Oracle.
Ok, all works fine except the messagge body.
-------

My second post here this afternoon- I should just go home.
I want to write a query that returns all months for a year and the
total number of incidents per month IF they exist.
Current query looks like:

I have a table
xxx
col1    varchar2(10)    default 'x'    null,
col2    varchar2((100)    not null

I've commited a drop on a table but this was an accident ! I don't know
if it's possible to undo this action ? How to restore my table. I need
help, thanks a lot.

I am running 10g App Server release 2 phase 2 on Solaris 9.  I have
successfully configured SSL for the HTTP_Server, however, I cannot
configure WebCache properly.  When adding a listen port, it will not
accept my wallet file location (using the same one as for HTTP_Server).

I am having situation where my below query is not using index on
updated date column, I have index on two date columns, created date and
updated date, the query under focus has a OR condition with both the
columns, the query execution is very high (full table scan) as below.

Firstly i'm new to Oracle.
I created a database using the DCA. Can someone tell me why the database
shows in the standalone and not the OEM?
Thanks,

Hi, all.
I have a 10gR2 database (on W2003) which I imported in from an export
file made in 8i on AIX.
I created the db as per normal, and then imported all non-system

I am running 9i with a slightly outdated patch level.
I have two tables Inventory and Shopping_Cart
The Inventory has a primary key ( item_number ) smallint not null
The Shopping_cart table has a composite pk key

Regards, Ranko

I've searched metalink and on the web and could find very little
documentation on this and so thought I would post it here......
While collecting database stats using the dbms_stats package and
including the option for histograms on indexed columns (FOR ALL INDEXED