There is a package containing lot of procedures exists in the system.
Whenever we use the procedures of this package, it gives some errors.
Now, I would like to check whether there were compilation errors
reported when this package body was created/defined earlier. Is it

I have a process that generates a datafile whith a query executed from
sqlplus:
  sqlplus .... << eof > my_data_file
  set ...

When installing under RAID 5 we encountered a problem. As soon as we
start creating the datafiles for our tablespaces (the datafiles are >
1GB) the server is not responding any more (Oracle software is already
installed, there is other productive software running on the machine).

My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle
are in the same box.
I have tried both Oracle OLEDB Provider and Microsoft ODBC For Oracle,
but both not working.

We've been using Oracle 8 for a few years as the back end of our
product for a few years now. Recently we started using Oracle 9
(9.2.0.0) and didn't find any problems.
Until... One of our data structures represents a column of data in a

I have a win32 Delphi demo program (from Direct Oracle Access
Delphi component, compiled on Deliph 7).
When running on a client PC installed with Oracle client installed, it
connected to an Oracle 8i database without problem.

I have imported a heap of tables from a dump file into Oracle. They imported
into the SYS schema. I need to see these using ODBC but there are no tables
named sys.xxx when I open it through ODBC. Any ideas?

Hey, all.
I'm looking to use RMAN (8i on AIX) to duplicate a database from one
server to another.
Specifically, we regularly do a refresh of production data down to our

Is there any way in Oracle to only extract a certain number of
charaters from a field.
For example, I have a student number field (STDNT_NUM), and some
student numbers start with an S, such as

Could someone comment on these figures from our Oracle 8.1.7 database?
I don't know what is acceptable or if this needs some tuning?
Thank you in advance.
log file sync            1,236,225    2,135,472    75.54

I am working on oracle 9i. I have a table that has several tree
strucutres stored in it. Tree strucutres can have any arbitrary depth.
Root node has parent_id as null.
For Example :

I would like to export spatial data in the well-known text format as
proposed by OGC. What am I doing wrong?
SQL> select astext(shape) from cola_markets;
select astext(shape) from cola_markets

Can someone confirm my assumption is correct?
If I restore a whole database from a "Consistent Whole Database Backup"
I don't need to perform a recovery to open the database.
Note a "Consistent Whole Database Backup" is as follows (from the

Is there any way in Oracle to only extract a certain number of
charaters from a field.
For example, I have a student number field (STDNT_NUM), and some
student numbers start with an S, such as

- Oracle 9i 9.0 / Win XP Pro -
Hi all,
I've created an OMS/repository database (OEMREP) on my laptop, and I
can connect to the OMS when I log into Enterprise Manager. I'm able to