I am attempting to INSERT records from two identical tables in two
different schemas into one table using a single SQL statement, Could
one do this by using DECODE in the INSERT statement?
EX:

Oracle11 has some new additions to the mechanism of statistics
calculation. The old GATHER_STATS_JOB is gone, it is replaced by
BSLN_MAINTAIN_STATS_JOB which, unfortunately, doesn't run DBMS_STATS, it
uses an undocumented package DBSNMP.BSLN_INTERNAL which maintains

I have a query in which I need the first column to basically be the
row number.  This is not the ROWNUM psudo column, just simply a
counter.   The query is below.  I basically need the number of the row
in the result set.......

I am learning to use RAC 10.2 on Linux
As root, I can do
ocrconfig -exp test.dmp
As oracle, I can do

Group,
I installed RAC on my linux machine  Linux vlinux2 2.4.21-47.EL.
I put ASM and database in the same Oracle home directory.
Now I want to move my database into another Oracle Home, so I

Is there an easy way to output the contents of a table as a tab-
separated file from SQL*Plus? Currently I have something like this:
SET NEWPAGE 0
SET SPACE 0

Dear,
Iam trying to install oracle on sco507, in the middle of the
installation iam getting the below said error.
Error during action Relinking oracle server Manager 2.0 executables

I have a produciton environment with data guard configuration which
for little while pops out ORA-00354 - corrupt redo log block.
upuntil today it was resolving itself with out any problems from the
multiplex copy. but today after the error thre is a redo log missing

I have a oracle server configure to receive ODBC call (oracle odbc
interface). One of us tried to run a data migration from Access file
to the Oracle through odbc at the server for a few millions records.
Then we experienced a very slow odbc accessing speed, when we ran an

Oracle 9.2.0.8
Does it matter at all when the export of the meta data is done when
creating a transportable tablespace? Assume nothing in the physical
structure of the tablespace changes (i.e. no additional datafiles or no

I wish to know how to make to post the parameters of a session.
Typically I wish to know the value of the parameter
"optimizer_featuree_enable", to use it running.
thank you

I have installed red hat Linux 4 with patches. I don't know how to
install Oracle 9i on Linux?
Thanks,
DK

We have a situation where Oracle RAC runs on a set of HP/UX Itanium systems
and one of our tools is no longer supported on this platform. Would it be
possible to configure a different hardeware platform (HP/UX PA-Risc or maybe
Linux) and allow it access to the RAC shared storage ...

Oracle 10G ...  Hp Unix 11.11
Need help backing up data files and  archived redo log files using HP
DataProtector.
While backing up the files  the pre and the post  enables me to copy

Hi all, does somebody have an idea about TESTING this script?.....
This is my script (for data migation) :
--PH1_LOAD.sql
create or replace view myview2 as