I have a tablespace that apparently does not have sufficient space to
extend any further - No issue as i added a datafile to it.
Still getting the same error so i checked the freespace in the
tablespace and this is the report for that tablespace

Hy,
I need to import data into a new fresh 8i database. This new database is
created with local management TBS and with uniform allocation extents.
wath is the best thing to do ?

I want to use c++ driver for Oracle to develop a c++ application which can
make some select to Oracle.
I need to know if OCCI driver is fine, or does it exist better ?
Do I need an Oracle client for this to work ?

Oracle users from time to time have an error "invalid column name" on  
select from database. That invalid column is usually function based  
column. I read thread about "cursor_space_for_time" but I still don't know  
is it reason. Database is used by 30-40 users in time now , but ...

I'm an Oracle DBA. The vendor of our current application is helpless.
We are looking for a new one. The one my manager like most is based on
informix/linux because of the application's functionalities. I try to
convince him that moving to informix now isn't a good idea.

We are seeing intermittent library cache pin/lock problems. The
problem occurs for about a min and then goes away. This of course
causes timeouts all over the place.
Any clue on where to start?

I'm hoping to get some insight into why oracle creates 2 cursors for
the same sql query when I execute a SELECT statement via my small
little perl script.   Here is what is happening .. My query uses 2 bind
variables and when it is prepared  oracle generates 1 cursor for my

I am about to migrate my database which is on redhat linux itanium 64,
rac 9.2.0.5 ( 2 nodes) , ocfs to a sun solaris box.I use emc disk array
and my data size is about 2tb. I need some reccommendations in order to
do this migration as easy as possible.How can i transfer the data ...

How to migrate mediumblob from mysql to oracle.Since the column contains more
than 500MB of data it's diifcult to migrate.I'm using SQL*LOADER for
migration.This is my CTL file
load data

I am running Oracle 9i on Win2003 Server.
I am running:
RUN
{

I have a database that was installed on D:\ then the C:\ partition was
deleted and I had to re-install the oracle server. i installed oracle
9.2 the problem is that the database cannot be opened while it can be
mounted and the error I get from the log is that I have to open the

This should be easy. I read somewhere that says we are not supposed to
use normal unix command like cp, mv etc on ocfs mounted filesystem. Is
this true? I now need to remove a datafile to test backup and recovery.
How can I remove it?

I want to build a web application, and want to do the esimation about
the hardware requirement, like (Platform, CPU, RAM and Disk), I have
heard that Oracle sizer tool can help on this. Does anyone know about
oracle sizer tool, and where can I download the tool?

I have a great performance problem on an Oracle 9.2.0.1 Server...
(This Problem is independent from the version)
I try to update a table containing about 800,000 Rows with the
following statement:

       I am using the oracle transparent gateway connectivity with sql
server using tg4msql,as far as settings are concerned those were set
and Connectivity is working Fine, and getting the response from that
server.