I am having a problem with materialized views lately. We have several
MVs and we refresh them via the DBMS_MVIEW package. Everything works
perfectly all the week but on saturday, regularly, the refresh does not
come back anymore. It takes days (nobody has checked how long).

Hello people,
I have several querstions if somebody can help me. We have ORacle 9i
Rel 2 installed on AIX 5.2
1. I have read that JFS and Large File Enabled filesystem is not

All,
I am encountering an issue with gathering stats from an OLEDB
connection when the stats to be gathered include a composite index. I
receive the ambiguous " OraOLEDB: ORA-03113: end-of-file on

I have a query which has a date comparision in the where clause.
The query looks as
1. select count(*) from table where DTTM > '10-Jan-06';
2. select count(*) from table where to_char(DTTM) > to_char('2006-01-10

Hai every body
please tell me how to find factorial of a given number in
oracle(Through a query) with out writing pl/sql block........

Hi I am completely new to Oracle.I have been using SQL in Db2 for a
while.Now I am thinking to study for OCP With Oracle 10g and take the
exam for certification .Can anybody suggest me what would be the best
book for test prepation?

Could someone help me with some syntax?
I know that
SELECT To_char (sysdate, 'ddth Month YYYY')
will give me the format I want if it is today's date that I need.

I have just installed Oracle AS Forms and Reports Services 10 g on my
Windows 2000 PC.
I have Oracle 10 g installed on my PC.
The installation process of Oracle AS Forms and Reports Services ask

Hi everyone.  I currently have a procedure that takes the parameters,
v_case_id and v_fac_id, finds the earliest admission date and returns
the admission_id of the earliest admission date.  Here is the SQL from
this procedure:

Could any one please tell me what is best way to learn cursors in
Pl/SQL
Iam getting confused why cursors are needed...please help me giving
suggestions so that

I am not very knowledgable in this area so would appreciate any advice
you guys can give.
I need to provide a projected estimate of Oracle db tables. Essentially
my problem is in trying to work out the size of one single row. I have

we have 4 process which write permanent to the database.
The insert into a temporary table this is fast, the insert into
permanent table (nologging) is slow.
Thanks Thomas

i would appreciate some thoughts on this one.
client's criteria:
* be able to write to replicated copy during master site down time
* be able to move any record changes made on the writable MV back to

I am trying to install Oracle 8i and 9i Database server on same machine
, but I am getting getting various errors..
I cannot start TNSListener servive of both 8i and 9i simultaneously.
If i try to login to 8i Database using scott / tiger or try to create a

Hi everyone.  I have a quick question.  I just wanted to know if it is
possible to use a single group by statement witha UNION ALL query.  For
example:
SELECT