I have EM10g installed on an RHL4 server.  The installation ran fine
and the agents now need to be placed on dev boxes for testing.  Our
dev/ua and production servers use Veritas Clusterware.  Has anyone
successfully deployed OMS on Linux and the agents in turn on servers

Is it necessary that all foreign key should have index?
SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE = 'R'
AND INDEX_NAME IS NOT  NULL
Above query does not return any row in my database.Is it bad?

Janet Don Burleson got her breasts reinflated, new tires too!
Check her new bra at http://www.burleson-arabians.com/horse_milk.htm
Don gets a new red tail to match his naked redneck and Oracle logo and
belly at

This may be a dumb question, but my SA wants me to find out.  We have
an IBM AIX server which uses a separate D40 to store all of our data.
Normally we install the Oracle software on the D40 along with all the
data files and everything for Oracle.  This way if there is a problem

this is related to list partitioning.
i want to partition a table based on one column' s value( name varchar2
(10)) . there will be three partitions. all the name , start with vowel
, should go in the first partition and all the names start with

I want to use this in an Oracle 10g enviroment between
two databases.
CONNECT scott/tiger@tsh2
CREATE DATABASE LINK TSH1.WORLD CONNECT TO scott IDENTIFIED BY tiger

How I view, the objects of BBDD, that not have privileges for execute
??
the all_tabl_privs show de tables, no objects, procedures, etc etc
I'm sorry, but my english is bad

                                                           OMNI GROUP
                                                       tgugger@sbcglobal.net
                                                           419-537-9447
   CRYSTAL REPORTS/ REPORT WRITER/ CONTRACT/ CHARLOTTE AREA

I used PL/SQL to write a report program under Oracle Applications
environment. The output is saved to OA defaultd output file. I used chr
coomand to force a page break. I click the Output file button and save
the file as TXT file (showed in browser). Then I printed it through

I am getting an error ORA-01034:Oracle not available in 10g,
Please help me.
I am new to oracle 10g.
Also how to start new services.

Is it necessary that all foreign key should have index?
SELECT * FROM user_constraints WHERE CONSTRAINT_TYPE = 'R'
AND INDEX_NAME IS NOT  NULL
Above query does not return any row in my database.Is it bad?

I want to pursue my career as a dba.
Is it necessary to have experience to get the certification.
I dont have any experience till now .
Also what are the books useful to prepare  for the examination

Thanks guys for your suggestions;
FILE1=/home/pavi/DS.txt
FILE2=/home/pavi/chain.txt
awk -F ":" '{print $1}' $FILE1 > f1.txt

Hi (and help).
I've been using Mysql and am in the process of migrating an intranet to
Oracle.  In the Mysql pages, we've created a number of pages which use
temporary tables, which aren't available in Oracle.

Can you please provide details ( or links to documents) about how
should we determine the size of all the memory structures given
hardware specifications or the process flow. basically what needs to
kept in mind and what things we need to know before determining the