I have recently been asked to extract a very large volume of Data from
an oracle DB (something like 40,000,000 records).
I know that there is some way to open the oracle files directly and
extracting the Data from there (uploading). this will do it must

I'm looking for a good document about oracle's statistics, execution
trace and state view, troubleshoting, ...
Please, has someone a reference to good document about?
Thanks a lot.

Anyone know if exist any document that describe how to install ora 9ir2 on
fedora fc4?
Thank You

I faced with a problem in T-SQL to PL/SQL in a project.
scenario:
There is a function called hostname() in T-SQL which returns an obviouse
thing! I implemented this with:

Is there a way to discern when the last modification (update or insert) has
been performed on a row in a table? I have to work with a pre-existing table
structure, and cannot alter it. Thanks, Ike

mBizTech and Oracle
I have mDB from mBizTech and Oracle 10g installed on my machine.  The
version of Oracle I have downloaded is a free version, which is
available on trial licence.

mBizTech and Oracle
I have mDB from mBizTech and Oracle 10g installed on my machine.  The
version of Oracle I have downloaded is a free version, which is
available on trial licence.

after installing the oracle management server on windows 2000 with
no problems I can't start the service in the control panel - to be
precise
- the error window says - service "oracleOraHomeTestManagementServer"

We have the ER diagram for our database by ERwin Software. There is a
need to have this diagram converted to pdf or ppt or jpeg etc so that
it can be given as an image/file to all team members. Can you help me
figure out how it can be done?

I am having alot of trouble making LOCK_SGA work on my Oracle 8.1.7 running windows 2000, and am really looking for somebody with experience at this specific task.
I am aware of that LOCK_SGA is buggy until Oracle 9.2, but the guys at Oracle Metalink are saying that there is a ...

We would like to create a db link to a MS SQL server from a 9i
instance living in a AIX 5L box to do some simple select SQL. Please
share you AIX ODBC experience as well as 9i Generic Connectivity.  Any
recommendation on ODBC driver for MS on AIX? Is there such thing as

How exaclty the index and data objects can be separated from one
Tablespace into 2 Tablespaces? Is it possible with export/import? Or,
is it possible with direct SQL commands also?

quote from
http://dba-oracle.com/oracle_tips_credence_qualifications.htm
"Edward Stoever - California
I wanted to post a response, but I am still thinking of what to say!

edit from backup script:
alter system switch logfile;
alter system archive log all;
alter system archive log current;

I want to know when was the temporary tablespace in my database
created.The database version is 8.1.7(running on tru unix) and there is
only one Temporary tablespace having tempfiles.
I tried the query