We're finally getting around to installing 10g and I had a question
about expdp. We used to write our exports to named pipes so they could
be compressed with gzip. Data pump doesn't support that. Is there *any*
way around that limitation or do I need to continue using export/import

Oracle DBA wanted (URGENT)
EXP   : 1 - 2 YEARS.
LOCATION : INDIA.
PACKAGE : 3Lakh per Annum.

I have a question on restoring a database using RMAN:
Pre Disaster Environment
1. Using a standard non-RAC Oracle 10.2.03 database on a UNIX Sun
Solaris 10 system.

Hello Friends,
I have an indefinite contract with SUN and GE in Milwaukee, WI.  We
are looking for a heavy hitting linux admin with good solaris
experience.  Please send me resumes ASAP.  Thanks and have a good

I am NEW to the Oracle, and I have two questions here.
1. Let's say I am going to run a "select ... " sql, is there an easy
way for me to set the format of the output? When I was using
PostgreSQL, I can run a "/x" to have the output in vertical or

This morning I received an email from a colleague at another
installation asking for help with the following.  As I understand it,
this occurred after applying the July CPU from Oracle.  My guess is he
doesn't have LD_LIBRARY_PATH and SHLIB_PATH set correctly, but I

I am trying to export everything from quite a large database (9.2.0.7)
apart from the data using export and import it into a new database
(10.2.0.1).
I have created all the tablespaces in the target database as locally

Is there a way to instruct RMAN to delete archived redo logs that have
been backed up "x" times to disk _and_ have been successfully archived
at a remote site (this is a Dataguard setup)?  We're running Oracle
9i.

Something weird happened, the first query retruns rows but not the second
Have you an explanation ? ( 9.2.0.6 AIX)
Thanks in advance
select * from

I'm getting the FRM-41214 error when trying to run a report from a
form. DB used is Oracle 10g. Oracle Forms & Reports are in version 10.
I know from looking on the web that there is several possible root
cause, but I think neither fits to my situation.

Someone asked a question the other day for which we didn't necessarily
have an answer.  Someone was concerned about low level OS processes
10g can execute and if a defrag was run on the drive hosting the
database (using Windows Server 2003 R2), would that interfere in any

What will work faster in Oracle for Import?
CREATE INDEX or ALTER TABLE TAB ADD INDEX

I'm fairly new to Oracle and I was wondering if there was a simple way
to return a list of all user created tables (with no system
tables)..
Any help or direction would be great!

Have a scenario wherein have some 20 tables  each with a million and
more records. [ Historical ]
On an average I do add 1500 - 2500 records a day... i.e would add a
million records every year on an average

Oracle 9iR2
We have recently implemented a new way of generating web pages from our
app (mod_plsql) which involves storing the basic page template in a CLOB
and then replacing "place holders" with data from the application's