1) I am using Oracle 9i.  I checked the tablespace usage in Enterprise
manager. The system tablespace is 99% full. Is this is
a problem? If it needs more space will it extend automatically?
When we create a tablespace we set the variable  "MAXSIZE =<SOME

Okay here is an odd one that neither us or Oracle can currently explain. Need some help from the experts.  I have an Oracle Stored
package for which I provide a common stored procedure for an external ASP web page to call upon and pass the appropriate parameters
to. This procedure ...

Has anyone every seen the following behavior?
Oracle 9.? running on AIX, no problems here Windows NT machine,
Oracle client installed on the NT machine with ODBC driver v 9.2.0.2
We have set up an ODBC source on the NT machine. An application (app

Im seeing an increase in my applications' DB operations time (C++/ OCI)
on increasing the size of unrelated tables. The size of tables that im
concerned with are not changing over a period of time, whereas the size
of other tables has increased substantially in that same time frame.

i have a problem when a switch from a recover standby to open read
only.
if i made :
SQL> conn sys/syspass as sysdba

I NEED SOME HELP REGARDING TO ENABLE THE WORKFLOW IN ORACLE APPLICATION
SERVER THROUGH MAILING.WE USE 11.5.9 VERSION.

I've been having a really tough time getting Enterprise Manager to work
in 10g. I can get it to the hostname:5500/em screen at long last, but
it says "The database status is currently unavailable. It is possible
that the database is in mount or nomount state..." If I hit Startup

Hi ,
My system is a two node rac on redhat linux 2.1 , 4 ia64 cpus ,
8gb.ram , ocfs and emc raid 10
The db_block_size is 16kb. , current multi_block_read_Count is 64

I am using a database named contacts.Now i want to see all the tables
within the database.What query am i suppose to fire?

I was wondering if anybody knew if 'IN' performs a implicit distinct?
For instance say if i had the query below:
select stat from orders where account_id in (select distinct account_id
from accounts)

I run Oracle 8.1.7. Is it possible to add calls to PL/SQL code from
constraints on a table?
Or is using a trigger the way to perform more control of data when coding is
needed?

Installing ASMLib rpms on RedHat 3.4 64bit (Kernel version 2.4.21-27.EL #1
SMP Wed Dec 1 21:53:39 EST 2004 x86_64 x86_64 x86_64 GNU/Linux) on a Dell
PowerEdge 2850 raises the following errors:
Preparing...                ###########################################

Given this csv file:
0101;Fox Street 20 A;27052005
00102;42nd Street 20921;25022005
00105;Fox Street 21;00000000

HPUX 11i v2 (11.23)
Oracle 9.2.0.6.0 (RAC)
The problem is when we do:
1 - alter session set sql_trace=true;

i'm working on a PL/SQL function (Oracle 9i) which should remove
special characters from a variable before entering it. the function is
supposed to remove all special characters except for - (hyphen) and
/(forward slash). It is possible to search the variable using IF and