I have two oracle 9i tables on Win2003 server.
For simplicity, let say:
 Table A contains two fields: A.id, A.part_id.
 Table B contains two fields: B.part_id, B.desc.

Announcing complete and extensive PowerPoint slides
for both an introductory and an advanced database course,
along with supporting manuals, available from
http://purl.oclc.org/net/db

I need to code some tool to get data from an Oracle database. The data
will then be processed with some mathematical algorithms and then
analyzed. As this is my first time using a database for something other
than mere data storage I have some questions. If this is not the right

We have ORACLE 9.2.0.6 on Redhat LINUX AS 3.4.  while we doing "full database
import"  there has ORA-30510 come out.  I searched Metalink and Google, but not
found much information.  The error messages on import are:
. importing OUTLN's objects into OUTLN

We have a web-based java application that maintains multiple identical
schemas. Each schema has a package that is used to evaluate a set of
spreadsheets for an individual customer.
We were observing ORA-04030 errors in some which we have traced to the way

 Has anyone successfully install Oracle 10.1.0.3 (64 bits) on a linux
SuSe 9.2?
Let me give you my host's configuration and then I will show you the
error message:

I need to calculate the sum of tablespace's size and its free size.
Select a.tablespace_name,sum(a.bytes)  total_mb,sum(b.bytes)  Free_mb
from dba_data_files a , dba_free_space b
where a.tablespace_name = b.tablespace_name

Question regarding the LOB data type.  Since, I am also a Java programmer
and I 've got use to the concept of 2 object references can reference the
same object instance.  I am a bit confused and want to know if this concept
applies here.

I have been trying to figure out why the optimizer is making the
choices it is, and am stumped by some of its assumptions.  The first
step in the explain plan is a full table scan with a cardinality of 1
row.  There is no criteria on that table that I can see that can be

I am trying to install Oracle 10g 10.1.0.2 on to Windows Server 2003 but it
failed at the last hurdle.  Everything went smoothly until it got to the
Oracle Database Configuration Assistant at the end of the process which came
up with a "TNS: Permission denied." error.

Anybody had any success with intergrating a delphi 5 dll as an
external function i Oracle 10?
Jens G

One of my client has only one database box, and they put all their
development/test/production on one linux box, I was trying to persuade them
to seperate production from development, but they seem to be concerned with
Oracle Licence cost.

I defined a cursor for selecting V$LOGMNR_CONTENTS.
And do the following action:
fetch cur BULK COLLECT
into collect1,collect2,....

I have recently started a petition at
http://www.petitiononline.com/oraman/petition.html  calling on Oracle
Corporation to allow all customers, not just enterprise edition
customers to license the various management packs that are available