Is there an easy way to tell if a materialized view is in sync?
Thank you.

I am working through this tutorial:
http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm
and I am at What to do first -->  Loading Data.  stage
I have the file loads_sample.sql on my computer.

I need to generate reports on one database (SQL statements developed to
build delimited files), load them into a test database (control files
built using sql loader), and then update certain tables based on the
new information received within the test database (SQL update

I need an answer to a very urgent problem with sqlplus.
I try to launch (from a Java class) sqlplus or plus80, or plus80w, on
Win
NT, with the following command line:

I need to give a presentation on the benefits of AIX vs Solaris.
Can everyone share your thoughts. Keep in mind that I`m not looking
to dismiss either platform, I think they both work very well with
specific databases,

I have a multithreaded application where one thread is responsible for
reading from the database and another thread is responsible for
inserting or updating the same database. We have a mechanism within the
app that prevents overlapping reads of the same row, and this serves us

Please inform can I transfer sql server tables to Oracle, without using
sql loader and external table concept.
How................

Hey all. (Oracle 9.2.0.1.0 on Windows XP)
I have the following DML in my PL/SQL code:
----
delete from machine_down_times

I am not an Oracle DBA, but have been challenged with implementing a
logging solution for Sarbanes Oxley compliance.
What we would like to do is log all activity on the database by the
Informix DBA's. In particular, we would like to include log on/off

Is there any way to differentiate between normal trace files and
different Session's SQL enabled trace files which generate in udump
folder on Operating System?
I want to have a script which distinguishes between different

Please tell me where can I change date format in Oracle Alert file
(alert_%SID%.log)?
(By default it's something like 'Dy Mon dd hh24:mi:ss yyyy')

The dialogue with you makes me fully aware of the origin and the nature
of some dreadful phenomena  of the modern mentality:  the
dissatisfaction, the uncertainty, the rebellion, the intimate
unhappiness of the contemporary human beings.

I'm having an issue using a FORALL and inserting data into a table,
where one of the values in the insert is an item in an Associative
Array.
My array looks like this:

This query
select  to_date(CURRENT_DATE,'dd/mm/yyyy hh:mi:ss AM') from dual;
returnig the result as 31/07/0006 while the current year is 2006 ???
plz help

Last night on an instance that has been up for over 100 days, and on a
machine with an uptime over 400 days (HP-UX 10.20 and Oracle 7.3.4.5.0,
I started getting :
ERROR: ORA-12547: TNS:lost contact