We have a Windows 2000 COM+ application server which seems to have a strange
network issue when trying to reach the database server (8.1.7.4 on AIX 5.2).
Tnsping seems to "hang" once in while (>2500 ms reply). Ping sometimes gives
"request timed out" (but less than tnsping). I ...

hoping for some help....
How would I find out using sql the size of schemas in my db and also
calculate the free space in each schema...many thanks.

I tried to install Oracle on a Celeron machine a couple of years ago and the
install failed.
Will Oracle10g Standard/Enterprise install on the latest batch of "budget"
processors from Intel and AMD.

I have this problem when I am trying to run my replication scripts to
replicate data between 2 machines. I delete and recreated my instances
and run the scripts from the beginning.
ORA-23375: feature is incompatible with database version

I want to select all record which contains date between monday and
friday, could YOu explain how to do that ?
P.

I recently took a job as an IT manager for a financial institution in
the United States. I will be acting as the senior project manager until
I get a feel for things, and then I will take over as the departmental
head. The current departmental head is a semi-paranoid multivalue ...

Expert-one-on-one mentions that we should commit only after the
transaction completes, otherwise it takes more time and generates more
redo. I agree to it. But suppose if my transaction takes a few minutes
to complete, i will be holding locks for that time and other people

I'd like to create a new tablespace and to access it through a certain
host and port. I know that tnsnames.ora and listener.ora are the lists of
all the "tablespaces" available with a different port for each of them.
But I don't know how to assign a specific port to my tablespace. ...

I have a table T1 has columns FNAME, MNAME, LNAME, STATUS and other
columns, the value of T1.STATUS is 'Y' or 'N'. The requirement is to
retrieve the table from these four columns, How to create index is the
right way?

Folks, I haven't used savepoints before. We have a large data migration
job and what I would like to do is to set a savepoint every (say) 1000
records so that if we should run into some error such as tablespace or
temp segment or rollback space probs then we only lose the last ...

  We are having a problem, in the problem that Stored Outlines are not
getting used.
We have a query generated from a third party tool, on which we seem to
have no control to pass hints. So we decided to embark on Stored

I have table:
create table corporate_slaves (
      slave_id             integer primary key,
      supervisor_id         references corporate_slaves,

Oracle 9.2.0.2  RHEL 4 Linux (Itanium).
I have picked up on a subtle difference in the new 9i Join syntax.  It
appears that there are 2 forms of the join command which seem logically
the same, but return different results:

1) What type will NrInstances have in this query:
SELECT Module_ModuleType as LicProgPartID,'Module' as
LicFor,COUNT(Module_ID) as NrInstances,Lic_RegCode
FROM etc.

Using Oracle 9.2.0.4/Windows 2000 I am trying to schedule an automatic
dump of a database from a DOS window:
at 17:00 /every:th d:\oracle\ora92\database\archive\dump.bat
(meaning: execute dump.bat every Thursday at 17:00 hours)