I am trying build a business case for Oracle at my workplace and
install Oracle Files. I have a Solaris 8 box with an Oracle 10g
instance, but the dependency tree is getting a bit problematic.
Oracle Files is bundled with Oracle Collaboration Suite release 2

I'm interested in Oracle security.
I've seen the Oracle alerts on the oracle website. A lot of the highly
critical advisories are about database server itself or the underlying
operating system command execution.

I was recently given a datacleanse task that I think makes an
interesting SQL Puzzle.  At the end are the setup statement you will
need.
I guess replies to this thread, so far I've been unable to do it purely

i am currently using oracle 10g and i want to export my schema using sqlplus .
.. i have done it using
db administrative page. is there anyway that i could call the import/export
procedure using sqlplus and overwrite the values for jobdescription, log file

I am using UML Class Diagram to do data modeling.
The question is then how should I translate it into Oracle database
design ?
In the Class diagram there are operation/method, where should I

I have the following two tables (AA & BB) that I need to use to
populate a third table (CC)
Table AA
item_code   type   rel_code

This may be just a privilege thing.  But, we loade dthe JVM and have
this Java mail routine working fine under this one schema.  The Java
was loaded, of course, using the SYS schema.
Anyhow, we now create a new procedure that will use this Java mail

This may not be the best place to discuss this but anyway it is related to
Oracle.
I notice that the Oracle books from Oreilly are a bit outdated - mostly on
9i and before.  I'm just wondering if their focus have been shifted to other

Sorry if this question has been posted before, but I want to know if
the create directory statement must point to a folder from the server
filesystem. I mean, using sql*loader, we can have the files containing
the data to load in our own workstations, but I am not sure with

I have a stored procedure proc1(param1 in varchar2, param2 in
varchar2). I have tested this one and it works fine.
I need to call this procedure from a shell script. I am using
sqlplus -S ${ORACLE_USER}/${ORACLE_PASSWORD}@${ORACLE_CONN}

I have a parent class (PL/SQL) and some child classes that inherit from the
parent object.
I have a table of the parent class type
I have objects of the parent and children classes in the table.

Does anyone have any info/advice on the following:
Our customer has a Data Warehouse using Oracle 9.2.0.6 on an HP_UX
9000/800 machine, os version 11.00, 4GB of memory, 2 processors.
Database files are stored on an HP VA7410 virtual disk array.

I have a program that will read as follows
#define    MS(x) memset(x.arr,'\0',sizeof(x.arr))
void memset_var()
{

I encounter problem during loading oraclease module in AS4, do anyone
encounter similar problem?
[root@fatdb init.d]# ./oracleasm configure
Configuring the Oracle ASM library driver.

forgive me if this is a stupid question, I have been away from Oracle
for a while.  I have some people in my company who have turned on
auditing in 10G and they noticed that everyone in the database can
query sys.aud$. They want this priv removed since the users can seen