Dear Group,
I am using oracle 8.1.17, on Solaris 8
There has been some update in database tables. The table does not keep
a record of the timestamp, can we check somewhere in O.S. or oracle

Is it possible to copy large objects (CLOBs and BLOBs) in Oracle 9i
over a dblink? Has anyone tried this?
Thanks.

I have problem. I want to login do database as SYSDBA. I am using
OleDBConnection (vs 2005) Do you know how I can do it? I am trying this
structure: OleDbConnection con = new OleDbConnection();
con.ConnectionString = "DBA

I made a valid backup of Oracle 9i on Win2003.
I am trying to test restore and recovery using the following script:
shutdown;
startup mount;

We migrating from a 300G machine to one with 2.2T in RAID5.
Oracle10g has been installed on the new machine.
What is the best way to copy/clone the databases in old machine to the
new one ?

Is there a per instance minimum for maxssiz (or maxssiz_64bit)
parameter? I am using HP-UX 64-bit.
I have checked several docs but none provide a value per instance. For
example, Oracle9i installation guide gives a maximum value for this

I tried to reproduce a "case study" founded in a rman tutorial. at a certain
point, after that command:
alter database mount;
restore database;

is this a bug or a feature or am I missing something?
The following statement works with chr(193) but throws an ora-03113 with  
chr(194). Strange behaviour, isn't it?
SQL>  declare

Iam using iSQL*PLUS (Oracle 9i) environment to execute queries. I find
it strange that I cannot execute selected part of the query syntax
(writing beginner level SQL statements). If I dont want to exceute
certain statements I have to go through a circuitous process of putting

For Oracle stored procedures that are executed with dbms_jobs,
is there any way to capture the output generated
with dbms_output.put_line(),
without changing the pl/sql code?

According to the November 21 issue of eWeek, page 13, Oracle has
decided to drop Linux as a reference platform, at least in the 64
bit space, and once again embrace Sun Microsystems.
Any comments Mr. Townsend?

I have a PL/SQL package that displays an HTML form like the following:
name | approved?
------------------
Allen   |   x

I have a query that uses "CASE WHEN" syntax:
SELECT   startdate,  (CASE WHEN groupno = 0 THEN 1 ELSE 2 END) AS
groupno
FROM ware01

One of the requirements for oracle 9.2 to be installed on hp-ux 11.11
is jdk 1.3.1, but Sun recommends to upgrade to a later version.
It is appropiated install oracle 9.2 with a later version of jdk like
1.4 or 1.5?

I came across the link
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinso
ft.html
and went through the FAQ for the same. It says it is free and can be
used for training etc.