we have presently requirement on Oracle and Sybase Product support. at
herndon va .
for duration 1 year.
If you instrested please send your latest resume to follwing:

I just started at a new company who is running Oracle 8i on Windows
2000.  I found a Temporary segment in the production data tablespace.
(I think this segment also has some corrupt data blocks).  I can't find
a way to just drop it.  I have tried to "get" smon to clean it up, but

Hi, I need to find a good sotware to manage database changes. I've used
ERWIN years ago to do reverse engineering for Informix DataBases in
order to print good looking database diagrams and other stuff, but I've
never work with oracle. Can you recomend one thatr works well with

Can anyone help me.
I have a table in SCHEMA1:=
create table TESTTAB (Dummy varchar2(10) );
grant alter,insert, update, delete, select ON TESTTAB to SCHEMA2

I need to resize temporary tablespace from 1,5 GB to 200 MB on Oracle
9.2.0.1
Please advice!!
Tnx!

for a uni project i need a copy of 8i does anyone know anywhere i could
download a ccopy from?

for a uni project i need a copy of 8i does anyone know anywhere i could
download a ccopy from?

I want to use the existing connection to create a service Context Handle
from a PL/SQL connection
E.g
EXEC SQL CONNECT:userpass

Hola ¿ existe alguna forma de ver el estado de la instancia en oracle 9i sin
tener que iniciar el enterprise management , con algun script o algo ?
gracias

i have an old VB6 application that has recently had the drivers changed
from Microsoft provider for Oracle (MSDAORA) to Oracle provider for OLE
DB (OraOLEDB.Oracle) for CLOB support on certain tables.
unfortunately, we now get the "ORA-01000 maximum open cursors

I have been looking at what's involved in migrating our product to
unicode.   While most issues have been successfully resolved, I
recently ran into a problem which raised further questions.
There are a number of points in our stored procedures where direct SQL

we are currently choosing which path to take in our Oracle database
environment renewal process. What we want is 1) reliability 2) minimun
downtime 3) maximum peformance 4) minimum cost. Sounds easy? :-) Due to
reliability and minimun downtime requirements we are planning to ...

The docs states that
" Sort_area_size is the memory used to for sort." This is understood
What i don't understand 1005 is the below
"After the sort is complete, but before the rows are returned, Oracle

hello gurus,
i have a clarification in Export, can the export be done in flat text
file instead of a <file.dmp> file. whether it is possible in this,
since few say that this feature is available in DB2 and SQL server. If

Please look at the alert log error I got
It shows ORA-01555 but the query duration is 0 seconds. How is that
possible that query goe the error just after starting
this is Oracle 9.2.0.5 running with automatic undo with undo_retention