One of our installer is disabling port 1521 to block Oracle user out
while he is doing an updrade. But this also blocks out our installion
software, done in Java using the thin driver. Besides changing our
install software to allow entering a new port number, is ther another

Is there any method using which I can search some numbers in all
numeric fields in all the tables of a particular schema ????
This is urgent. Thnaks in advance.

Does anyone know what is the side effect of having a large open_cursor
variable.  We are doing imports into an oracle database which is heavy
on cursors.  We have found by setting a small number we keep on
getting the exceeds max number of cursors message.  Therefore, we have

I am
trying to generate csv file from the output of a sqlplus.
9i on unix.
Dome quite well so far.

We wholesale cheap Nike Air Jordan,Nike Air Max 90,Nike Air Max
95,Nike Air Max 97,
Nike Air Max 2003,Nike Air Max 2004,Nike Air Max 2005 ,
Nike Air Max 360,Nike Air Max LTD,Nike Air Max TN, Nike Air Dunk

I've wrote some function and procedures(create function etc.) on PL/
SQL
How can I back up/save them in case I lose  my DB? Is there any tool
for that?

Hello out there,
today I imported a full database export of an Oracle 10.2.0.3 database
running on Windows 2000. I precreated the tablespaces since I wanted
to put the datafiles on different locations.

I understand that when you feed the count( ) function an asterisk as
an argument it runs
slower than if you use a column name as an argument. Can someone tell
me why this is so?

I'm working on Oracle 10g.
What is the diffrence between:
- MBRC setted by dbms_stats.set_system_stats or automaticly with
dbms_stats.GATHER_SYSTEM_STATS

Is the only way to do this through some custom script to
v$asm_diskgroup?
thanks,
.......

I set up systems for a classroom training environment that include
Oracle and a database. I am trying to migrate from 9i to 10g but have
run into a major roadblock and would appreciate some help.
With 9i, I could edit the listener.ora and tnsnames.ora and substitute

Database is 9.2.0.8 running on W2K server, clients are windows xp pro
running 9i client.
We've not used OS authentication here for any databases yet, so this is
relatively new to me. To make our SOX compliance easier we are thinking

i've an Oracle database with RAC 2 node version 10.1.0.5  on Linux
Suse SLES9 64 bit. Recently i've
got an  error  ORA-8102 during the execution of a procedure that was
deleting some records. So i have found that

Hi Group,
I need to import a schema from a 10.2 database into a 9.2. database.
What's the best way to do this? Exporting with 9i's exp and importing
with 9i's imp was my first guess - but i'm not completely sure if

I use the below query to get the Timeoffset from a given timezone.
However this query will not work for many timezone example for MST.
1.  SELECT TZ_OFFSET('PST') FROM dual;   -- this query works fine for
Timezone PST and returns a timeoffset correctly