can we retrieve the data if the system/database  crashes
1. the data is uncommitted, but present in the redo log file
2. the data is uncommitted, but present in the redo log file
and the datafile.

Can anyone tell me what version of Oracle I need to enable the SQL/Net
encryption?  Can I do it on the non-enteprrise workgroup version?  Is
it an extra cost? How much?
I'm waiting on a callback from Oracle and my IT department but I'm

What's the code PL/sql for find the part integer end decimal of number?
Thanks

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

Dear all;
we are using an Oracle sequence to generate primary
keys in our DB application. This is done in the usual
We have tested against Oracle 9i and Oracle 10g.

Oracle 9.2.0.6 EE on Win2K Adv Server SP3
I have an SQL statement which runs in 2/3 seconds in one database and
over 30 minutes in another environment.
I have narrowed the problem down to the optimizer choosing 2 totally

We have Oracle RAC 10g Release 1 (10.1.0.2) installed
on two Solaris boxes (SPARC Solaris 9).
Oracle RAC works well for about one working day.
Then for some reason, the nodes spontaneously reboot

The Tablespace undo, is full.. ¿Why? ¿any idea?

I get ora-27125 when running DBCA to create a new database.  What OpenVMS
parameters do I need to modify to get around this? There is nothing (at
least I did not find it) in the manuals about what to change to get around
this.

I'm looking for an idea on how to perform the following
(Oracle 10g):
We have booking data from the previous 24 months in a large data
warehouse (OLAP warehouse, customers access it by a java client

I set the USE_SHARED_SOCKET= true
The TNS message - is that the connection is closed.
on the 1 post - some one wrote that on Oracle 8.1.7. is error - there is
Oracle 8.1.7 - is there any known patch that resolwes that

We are facing a very strange problem, we have an Oracle 9i Server
running , the problem came into picture when we tried to connect to the
database through ASP.NET application using ODP.NET, it throws an error
"ORA-12560 TNS Protocol Adapter Error", then we tried a console

Our team is currently quickly approaching an 8k block size upgrade of a
fairly large production database (800 gig).  This is one step in
several to improve the performance of a long running (44 hour) batch
cycle.   My concern is the following and I hoping people can tell me

In the Oracle Administrators guide it is mentioned that ArchiveLog mode
protects the data in case of system/disk failure but NOARCHIVELOG mode
does not.
Now if the Archive log files are in the same system as redo log files,

I upgraded from an 9.2.0.1 to 9.2.0.6 database on Win XP without any
problems.
Now I have got some problems using EXP. The Error EXP-00008: ORACLE error
942 encountered comes.Ifound some similar notices, like let run CATEXP.SQL