on 7/12 I put our test database on our production server, so we have
two databases running on the server.  This is only temporary.  We had
no problems all week until sometime Saturday night or early Sunday
morning the machine ran out of paging space it seems.  The machine was

I have two 9.2.0.4 databases on the same Solaris machine.  They reside
on the same filesystem.  I would like to Restore db "A" to db "B".
Different SIDS and different datafile locations.  Is the correct way to
perform this to use RMAN to duplicate to an auxiliary database?

We have a stored procedure that runs and grabs data from over a
database link.  Sometimes that link goes down because the remote
database goes down.
If this happens while our stroed procedure is running, it basically

In Oracle 9iR2, the USER_OBJECTS view contains the STATUS column for ALL
objects including table.  Does it mean it is possible to invalidate a table?
If yes, how?
Thx

This was to discuss a typical error we've been encountering related to
listener.  Our application which is a GUI, communicates with Oracle
Database using NET8.
The Problem :

What is the recommended data provider to use for .NET applications running
on Windows Server 2003 and connecting to Oracle 10g on AIX ?
ODP.NET (Oracle)
or

as I can know the size in bytes of a table.  The version of Oracle is 9i

have four queries Test, Test1, Test2, Test4 all of them having same
number of columns and same datatype
Test results in following columns
Refrence_Num

RHEL 3
9.2.0.4
I currently log into a file the number of connected users at a given
time with

Please correct this SQL which is returning multiple records.
SELECT DISTINCT a.CALL_TIME, a.P_TRANSID, a.METHOD, b.CALL_STATUS, FROM
DT_IPOS_CALL_LOG a, DT_IPOS_CALL_STATS b WHERE a.P_TRANSID IN (7569302)
AND a.P_TRANSID = b.P_TRANSID (+) ORDER BY a.CALL_TIME

Before i use an Oracle8.0.4 on AIX 4.3.2 and i could store $FF value
in VARCHAR2 type.
Now i have an Oracle9.2.0.4 on Redhat and $FF are translated to $7F,
I could not use RAW type

We have a stored procedure that runs and grabs data from a remote
system over a database link.  We are not responsible for that remote
system, and sometimes that link goes down for whatever reason.
Unfortunately, we are not responsible for that system, so it is

is there a way to select all columns from a table
where for example comlum W has its maximum?
Table A:
W | X | Y |

I have seen many databases that tables with columns such as IsMale,IsFemale,
IsNull,Is...
All these were somekind of boolean type with yes/no or true/false or 1/0
values.In DBMSs that supports

Hi, I've readed the Oracle site but I haven't know....
If I've a server (1 processor) with a Web Application (.NET) that uses
Oracle... and all internet users will connect to this application, witch
licence Must I to buy?? and witch price??