On the Oracle 10 DB:
SHOW PARAMETER shared_pool_size;
Is returning 0 because it is not set
How to update script TFSSPUTL.SQL to get "Shared pool allocation

I can compile the following Java code just fine when using the Java
compiler. But I am getting an error when trying to compile the source
file in Oracle.
Here is the code:

I have a question regarding delete triggers. is there a way to protect
one specific record of a table from deletion? The way to do it with a
view and instead triggers is not possible. Also i can't raise an
APPLICATION_ERROR, since the whole thing should not be visible from

I got some guidance earlier (TA!) about what possibilities their were
for slicig and dicing 3 X18 GB disks on a Sun 440 development box for
Oracle 10G. So now current plan is to put Solaris 10 and query app on
disk1, oracle product on a 5G B slice /u01 on disk2 and data on disk3 /

Is it possible to speed up this query ?
Thanks in advance
9.2.0.6
 2  SELECT   dc0.nrid, dc0.so0_nrid, dc0.etat,

I'm a Unix/Linux Oracle developer who needs to ask a Windows-oriented
DBA question.
For testing purposes, one of the guys in this shop wants a new
instance that will access existing database files. Working from home

Is there some easy way to verify if the driving_site hint in a SQL
query is obeyed and executed at the specified location?
Maybe by adding something to query like
select /*+driving_site(remote_table) */ $execution_site_name, ...

What is the best way to export any of the following:
1. Whole Schema, or
2. All Tables with Row Header information, or
3  Individual tables with Header row information

Urgent openings for fresh graduates and experienced people
Don't waste ur time any more
http://www.uronlinesuccess.com/Job.html

Folks,
 I have always worked on Sun/HP platforms in the past. There it was
clear to install the Oracle kernel under an "Oracle" OS account, as
opposed to root.

In 8i there was a limitation with FBI and TTS
Is this limitation stay there for 9i, 10g ?
Thanks for your lights

I have a table with 2 columns.....
CREATE TABLE TEST ( ID NUMBER(5), NAME VARCHAR2(30))
My data file looks like the following and '|' is the col delimiter
10| |                -- single space

I visit Oracle homepage. It doesn't include Oracle 11g
for Solaris x86.  Would there be available later?
Thank you for your attention.
--

This code will compare a column to a variable:
declare myx number;
begin
 select * from foo where x=myx;

Try to restore some datafiles of an instance in order to create
another database. Need this to restore a single table. However the
restore fails: it tells me that the datafile is in use or in recovery.
Looks it tries to recover the actual instance but that's not what I