I developed a database file tool, when database is open, I do not
put table into "begin backup" mode, just clear the fuzzy tag on data
file header, and make sure that no fractured block in the copied
datafile, seems like a cold copy, but SCN on some block may be newer

[oracle@pslid2 Disk1]$ sh runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-2.1, redhat-3,

I just tried to install Oracle 10g on a Sun V480 running Solaris 10.
I immediately got the following error message:
Starting Oracle Universal Installer...
Checking installer requirements...

Throne Software has opened up a SQL Forum at:
http://www.thronesoftware.com/forum/
Join us!

If I have a cold backup of a 9i database instance taken from Solaris 9
running on a Sun Sparc server, is it possible to restore it to Solaris
9 running on an x86 box (Dell 2850). I'm fairly sure it isn't but have
been asked to verify this.

SLES9 SP1 is on PIII with two 800MHz procesors and 2GB RAM,
on four SATA 156GBhard disks are created two RAID1 arays,
on one RAID is OS with 1GB swap and Oracle 10.1.0.4 enterprise edition,
on second RAID are two raw partitions each 70GB ....

I've got an RMAN catalogue running under a 817 installation, and want
to move to using 920 (10's not an option yet) on a different machine.
Copying the data to the new database is easy enough, but do I need to
run a script to update the catalogue to 920 compatibility?

I have a SQL question.  Consider the following table...
----------------------

----------------------

It seems to me that whatever I can do in AFTER ROW trigger, I can do it in
BEFORE ROW.
Are there any functionalities that can only be achieved by AFTER ROW trigger
but not BEFORE ROW?

I'm getting used to the merge statement.  I really like it.  I am using it in
combination with external tables.
But I am pretty new at this (or pretty rusty, depending on your point of view)
....

I have a table composed by varchar2, number and date columns.
If I alter the current session like this
ALTER SESSION SET NLS_COMP=ANSI;
ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;

Hi, i'm a beginner in Oracle.
I install and configure oracle server, oracle management server and
intelligent agent and when i want to connect to the base by the OMS it give
me message.

I  am a newbie on PLSQL and need some help to clarify a basic concept.
In releasing ordinary program (java, vb, c), the common concept is that we
would release the compiled image only - not the src code.  But, it seems
that with PLSQL, it is a common practice to release src code of ...

SQL and PL/SQL Forums
Throne Software has opened up SQL and PL/SQL Forums at:
http://www.thronesoftware.com/forum/
Join us!