Hi ng,
At first I have to explain the situation a bit:
There is an Oracle9.2i DB, that contains information about trees on
roads, I call it now MyDB.

below is my listener.ora, tnsnames.ora and sqlnet.ora. I think there is
no problem with these files, but i am still not able to connect to the
database. I have oracle8.0 on Win2K
LISTENER =

Does anyone knows a tool which can easily compare different schemas and
to generate DDL for the differences? As well to compare the data in the
tables.
Thank you

I am using oracle 8i and I have a table called ge_module_access which
has a field name called functions. functions field has values like
'NNNNNNYNNNYNYYYY'
'YYYNNNYYYNNNNNYY'

Platform:  Oracle 9.2.0.7.0 on Win2003 server
On this box, some months ago, we created a db.  All well and good.
Today we tried to create a second db.  Running oradim resulted in the
following:

I have migrated to 10g release 2 from release 1 few days back. I am
finding a lot of issues currently in R2. One major problem is that one
SQL is working when I login as the schema user, but when I try to run
it by login as a different user it is not executing.

Oracle 9.2.0.5
I want to put a default value of 0 for number which may or maynot be in a
table. I have found that if I do:
select num, the_count from

Note:308895.1, 9.2.0.7 Patch Set - Known Issues, points to
Note:4711930.8 Subject: Bug 4711930
"When installing the 9.2.0.7 64-bit Patch Set on Solaris 64bit JRE
1.4.2 is not installed if the current ORACLE_HOME is at 9.2.0.4 (or

   I have Windows XP Service Pack 2 with oracle server 9.2.0.1.0
installed on my laptop for local development. I want to bring my local
database server up to version 9.2.0.6.0 or 9.2.0.7.0. to match what my
clients have installed on the server.

I have a table column, "filename", that stores the names of different
types of files gathered from the web. Because the files are gathered
from the web, some of the file names have URL encoded characters, i.e.,
%20, %22, etc.

Hi there, pls help me resolve this issue...
In my oracle 9i Schema there is a table called 'AREA'
When I ran a DTS from SQL Server to populate some tables in my schema
it erroneously created another table by the name 'area'.  how it is

I am looking for a Formula for Determining the Maximum Number of
Possible Sessions (Dedicated connections) is possible for an Oracle9i
Database Server.
Looking through the Init Parameters I've determined the Following:

I am trying to merge a table in a remote database via DBLINK, but I got
an error:
in the using() part, I use a subquery from local db tables.
The simple table merge (between tables with the same structure, and no

I have two identical databases that have replication running between
them.
Let say I have a table
scott.emp

I get the the above message whenever i try to connect to the database.
below is my listener.ora & tnsnames.ora file
Oracle 8.0, on  Win 2000
listener.ora-> Location C:\orant\NET80\ADMIN\listener.ora