Am wondering if it is possible to manipulate data as it passes thru the
application server.
So for example if a DATE is passed to or from an Oracle Form we could
either add on or strip off a time element.

I am using the following query to create a tablespace, but it is giving
me an error, I thik it is becaue of the uniform size. Any6 help?
CREATE TABLESPACE INDEX02
     DATAFILE 'c:\oracle\product\10.2.0\oradata\INST1\INDEX02.dbf'

I've tried imp user/pass@alias file=<my exp file> show=YES, but it's
not giving me anything useful and it's taking ages to do it.
I have yet to find any examples of using SHOW=YES nor have I been able
to get any useful results.  Am I missing something?

I am involved in designing a application that need to move data from
one of the tables(Say TableA) to Archive table (ArchiveA).
The process involves deleting the rows based on a condition and
inserting the same into ArchiveA.

I want to upgrade my 9.2.0.1 dataserver to 9.2.0.6.
I found the metalink that referred me to, thanks for that.
But, I got a list of patches for 9.2.0.1, but which one will upgrade my
server from 9.2.0.1 to 9.2.0.6?  

I am running an Oracle 8.1.7 instance, and now I want to tune its
performance. But I get two confusions:
1. From Oracle's report.txt statistic, I can see latch "library cache" has
relative low hit ratio 85% while other latches' hit ratio are all above 99%.

I am using Oracle 9.2.0.4 on Win 2003 server.
How do I know if sort_area_size is properly configured?
OEM shows that it's set at 1024 Kb.
Thanks,

We are about to apply Oracle Patch 4560421.  The documentation does not
say anything about having to roll back any patches.
If a certain patch needs to be rolled back, will the opatch tell that
before it jumps into the install process?

I want to learn about Oracle9i. Kindly help. I have a very good laptop.
You may send to me the drive of the software. My regard.
Michael Atansuyi

I need help writing a sql statement.  The table structures are as
follows:
version table = version_pk, stage_fk
section table = section_pk, version_fk, stage_fk

I am trying to learn Pro*C and got stuck in the very begining. I really
appreciate any advise.
I have the following simple program SampleSel.pc:
#include<stdio.h>

  I'm installing Oracle 10g in solaris 8 (sun)? But there are
something blemish ,like this:
[oracle@Solaris8 Disk1]$ ./runInstaller -silent -responseFile
/usr/oracle/Disk1/response/myinst.rsp

    I am new to this group. I hope someone could help me on this.
I want to extract a tables data into a delimited file. Currently i am
using spool commmand and in that simple select statement to output the
data into output file.

I am using the following query to create a tablespace, but it is giving
me an error, I thik it is becaue of the uniform size. Any help? The
error says "atleast 5 blocks ". So how do i increase the blocks?
CREATE TABLESPACE INDEX02

If I do:
spool C:\Oracan.txt app
I get this error (assuming file exists)
SP2-0333: Illegal spool file name: "C:\OScan.fil app" (bad character: ' ')