I am working maintenance on a software system and I have found the
cause of a bug but I am not sure of the best way to fix it.  Problem
is: we have 1 and only 1 dbms job scheduled to run every 60 seconds.
When we change the time back (for testing or fall timechange) the job

We have ORACLE 9ir2 on several servers.  I need migrate several users from one
database to another database.  I have script which can import one user:
  file=file1.dmp
  buffer=64000000

 I have a db in which all tablespaces are ONLINE. I ve not issued
ALTER TABLESPACE BEGIN BACKUP command on any of the tablespaces. But
still when i query the v$datafile_header table i get a YES value in the
FUZZY column for all datafiles.

can someone give any idea and examples?

Oracle 9i.  I am running an update statement from one schema to update
some data in another schema. The update statement in pl/sql block was
successful (test1). But if I use dynamic sql (test2) to do the
something it failed. Anyone know why?

I have modified a sql statement that I have seen in various places (ask
tom, google, etc) to try and see the overall size and available space,
along with the max size of my existing datafiles.
SELECT trim(b.file_name) "DATAFILE",

I have a table (myTable) with approx 2 millions rows in it that i would
like to start replicating.
what if find is that when i try to add this table to the materialized
view group via the OEM GUI interface, it seems to take ages and

There is a spelling mistake in one of the apps I am maintaining and I
want to go into the database and fix the spelling mistake.
Unfortunately I do not have access to the source code of the app.  Is
it possible to search the entire database for text.  For example if I

"protocol handler start failed",
this is is the problem i got when i start up tomcat . before installing
the oracle9i i dont have any problem. so that i am not able to run the
web applications, becos it is asking for "connect local host" user name

I have a block of statements like the following.  The last statement in
the block is an update statement.  I was wondering if there is a way to
get the number of rows updated by that statement.  An easy way would be
to wrap the whole thing in a function but, the code is not mine and ...

The bulk of our Oracle database data is time series data, at various
intervals (hourly,
daily, monthly, etc). When a value for a particular site is unavailable
at a given

New to Oracle and cant understand why my code is not working ..
FUNCTION   "VARIATION_ID" ("range_id" IN VARCHAR2) return NUMBER is
     rangebig NUMBER;
BEGIN

                Can someone please tell me the performance differece
between DECODE and CASE?
I have searched net for the same. One thing i am able to get is that
CASE should be used instead of DECODE and it executes faster. but i am

Hi Developers,
I am a .Net developer of a Large Online Retailling Company. I would
like to have your help on a Connection Pool issue.
Recently we have developed a Web Application on ODP .Net to work with

I need to install Oracle database on my home pc. This will be just for
learning purpose.
Which database should I install.
My pc is a P4 2.4G 256mb RAM and 40G hdd