WALK IN INTERVIEW ON 1st March & 2nd March 2008
Role: Freshers, Trainees in Oracle Developer, Oracle DBA, Oracle Apps
DBA, Oracle Apps Technical & Functional (HRMS, Financials, Mfg, CRM &
OPM)

Looks like patch 6810189 is out for linux, even though the 10.2.0.4
Note:401436.1 still says no release date.
Kudos to Laurent Schneider, Sven Vetter, Alexander Kornbrust and
whoever else is blogging about this!

in the last days I'm thinking about the best way to find rows present
in a set not present in an other set.
Suppose that both sets have a pk, is always the outer join filtering
only null values on one side the most *efficient* solution?

To all,
Have tar on this open, but support has been slow with updates.
9.2.0.7 EE Sun 5.9 64 Bit.
Anyway have this table, query is:

[10g/Win]
Is there a way to change the error message given to a user when a
check constraint is violated?
For example, instead of:

SiSense is pleased to announce the beta release of its first product
Prism -
a Powerful, innovative Do-It-Yourself productivity software for
building,

I need to reverse the logic of a SELECT statement, and change it into a
DELETE statement.
Do I have this right?  Does this:
--------------

DBMS_SCHEDULER contains no "alter job" procedure. I want to create new
schedule for GATHER_STATS_JOB, without having to create a new job. As a
matter of fact, DBMS_SCHEDULER has nothing like DBMS_JOB.CHANGE. I think
I will create a new job using DBMS_JOB. Is anybody aware of ...

Using Oracle 10.2. I'm a newbie user, so there's probably a simple explanation to this. I wonder why I can't access iSQL*Plus. I'm trying to access it from Enterprise Manager. I login as SYSDBA, use the SYS user and the database password, but I don't get access. What are the ...

I have a materialized view as follow  :
CREATE MATERIALIZED VIEW MV_TRANS_STOCK
PARALLEL
BUILD IMMEDIATE

on the session details page there is an entry "last call time" in
category "application" (top right).  I was not able to find a
definition of this measure in Oracle documentation or the web.  Our
current theory is, that this is the complete time from receiving a

Oracle 10.2.0.3.0
Windows 2003 Server
16GB Memory (93% SGA( 93% Buffer Cache,<3% Shared Pool, <3% Large Pool), 7%
PGA)

10.2.0.2 EE, AIX 5.2 64bit. RMAN 10.2.0.2
I have run the scenario and know the outcome, but was surprised kind
of.
database is in archivelog mode. I start up rman and connect to target

One of our customers sent us an export dmp which we're trying to
import. Their database uses a character set that is West European or
MSWIN, whereas ours is Unicode. During the import, we get this error:
. . importing table                "DEFECT_REPORT"