Can anyone tell me what's the best way of limiting connections to a
database (9.2.0.4)?
We've just gone live with a system that allows students to view their
exam results via the web (9.0.4.1 apps server). However, these projects

Say we had Unix users (developers really) that needed to deploy plsql
code to an Oracle DB on a remote HP-UX box. But these users would not
have any security to that remote box or database. Say we did not want
to surrender users or passwords of the remote box or Database.

I'm trying to install Oracle 10g 10.1.0.3 (for Linux x86) on White Box Linux
Release 3.0 Respin 1.
The runInstaller failed with the following message :
Checking operating system version: must be redhat-2.1,redhat-3,SuSE-9,SuSE-8

We are trying to figure if oracle is indeed using async io
there are two articles/notes i referred to in the process and of course
the metalink. We did relink the Oracle kernel
1. http://download-east.oracle.com/oowsf2004/1449_wp.pdf  See page 14

Hi, I'm getting a "PLS-00402: alias required in SELECT list of cursor
to avoid duplicate column names" error when every single one of the
field in the SELECT clause have been aliased.
CURSOR

   Here is the scenario.
We have a production instance with huge partitioned tables (almost 2
billion rows in the biggest table ) partitioned on a weekly basis.
  We are embarking on an archiving mechanism where we are trying to

I had problems with Oracle 10g Client. I un-installed the 9i client
first. Now all the client operations like ODBC and others that uses TNS
cannot resolve names. Although Enterprise Manager works fine and will
look in the network/admin directory of the 10G client.

Martin Solveig wrote:

Oracle 10G on Linux:
I have a large table TA1 sitting on tablespace TS1.
On this table I have a column CO1 of type CLOB.
As I have a second tablespace TS2 and I want to balance space usage a

Hi (again)
I had a problem with a standalone Oracle forms 6i app at our branches.
Accessing the db from the lan is no problem, but accessing from the wan gives
ORA-12545. I finally got around it by specifying (server=dedicated) in

I need your advice so please could you tell me
what is the way to collect information about the oracle versions and options
installed or used on database server.
This information should be collected remotely without accessing or logging

I want to send following message body by using UTL_SMTP. The variable
msg_body is of type clob.
cCRLF constant varchar2(10) := utl_tcp.CRLF;
msg_body1 clob;

I need to upgrade an oracle server. For a new server, I picked dual Xeon Intel
board and 2G of memory (a lot of people would say "too low", but the
person who manages db says that it would be enough for 2-3 years.
Now the question is - board and CPUs support EM64T, should I pick up

I need to upgrade an oracle server. For a new server, I picked dual Xeon Intel
board and 2G of memory (a lot of people would say "too low", but the
person who manages db says that it would be enough for 2-3 years.
Now the question is - board and CPUs support EM64T, should I pick up

I have an app server with 2 tnsnames connections to my Oracle 8.1.7 db, one
set up for dedicated server (server=dedicated) and the other not. Running a
particular query using the dedicated server conn gives ORA-03232 but the same
query, same user, using the 'non dedicated' conn is ...