Here is the solution for anyone out there, took me time and $$$ to
finally find a fix to this problem. Let information be free!
Oracle v 9g/ 10g/ 11g:
PROPOSED SOLUTION(S)

What the biggest threat for the Oracle DBA?

It`s possible? When a get from dba_users  hash password id like to create
database link with this password like this :
create database link connect to 'test' identified by values '1234124213'
using 'test';

We are using Oracle 8i on the occasion of our professional application.
Today we have 2 solutions :
- migrate to an another application running with Sql Server.
or

I have one question about table design for Globalization in Oracle
ERP. The following example is from Oracle ERP. Do I have other chocies
to design table for this kind of requirement.
CREATE TABLE product_information

I have a cursor which queries some tables over a DBLINK. The remote
database is Oracle 8.1.7.4 and package is being compiled on 10.2.0.3
Since this morning I am getting the below error message while trying
to compile the package:

Running 11.1.0.7 64 bit on OEL 5.2 system.
Old statistics are left in DBA_TAB_COL_STATISTICS when doing
dbms_stats gather_table_stats with different METHOD_OPT than the
previous run.  Can bypass by doing a delete_table_stats before the

10.2.0.4 EE three node RAC on SLES 10
I'm fairly sure I am missing something, but can someone please explain
what is below?
SQL> select min(jrn_seq) from xwc.xwc_change_history where jrn_seq

We are building a new application with Java/Spring, Hibernate and
Oracle.
One requirement is to be able to trace back the history of all objects
(table-rows) in the database and see how they looked at a certain

We have an application that has been around for several years and
never had any issues. It uses 9.2.0.8 on AIX.
Several days ago Apps Support reported that it was slow for approx 15
minutes. No action was taken and the problem went away. I had a look

I'm trying to call Oracle functions from a VBA-Application using
ADO over ODBC.  I've done this a couple of times in previous
projects and don't remember any serious problems. This time
however I ran into something that drives me nuts...

 I have configuration like this :
                            service=xxxxx, LGWR SYNC
Productional DB ------------------------------------------>STANDBY xxxxx DB
So every trasaction before commit is transmit to STANDBY by lgwr. But i have

Dear Group,
In our RAC environment, our private IP is not really private, it is
just another public IP on a different subnet.  PRD can communicate
with TEST server through private IP through a router.

I have a problem with tablespace file size limit. I use Oracle 11g
Standard Edition One on Fedora 8 Linux (x86_64).
The linux file system is ext3 with 4096 bytes blocks (which gives 2TiB
max file size). User oracle (on which the RDBMS runs) has no limits

I'm setting up a 10g standby database in the near future. I haven't had
to setup standby since 8i when it was all done manually. I'm thinking
about using Grid Control and dg broker to do it. Is there any advantage
or disadvantage to using dg broker? I've heard (anecdotal) stories ...