Oracle 10.2.0.1.0 on Windows 2003 server
While chasing down a problem with a db link, I ran across this bit of
strangeness.  Our temp hired gun -- who is far better than me -- can't
explain it either, beyond a vague comment about differences in

I´m having a problem using Bind Parameter with Oracle 8.1.6
The same query runs ok on a Oracle 8.1.7 or later... but on Oracle
8.1.6 the first oracleReader.Read() statement takes a very long time
(10 minutes to fetch 440 registers).

someone can tell me what does it do this command:
alter database clear unarchived logfile group ...
i've search on Sybex book of 10g but don't explain me what does it
mean..

I have some really wide varchar columns, but the data
is not very long.  Is there a way to automatically
combine these two statements, to set the column width
to the width of the longest string?

Hello, I have a weird problem.  I have 4 database schemas.
1st set
1 schema has parent objects and 1 schema has synonyms to point to these
objects

Running Oracle 9.2.0.5 Ent Ed, DMTs, UNIX AIX5L, compatible parameter =
8.1.0
That should raise some concerns of it's own, but on to the question.
Is there a certain number of extents for objects that one should start

Hi! I've an insert like this
insert into (....)
select field1,field2,field from..
my problem is that I would like to modify the contents of a particular field

Does Oracle Job cost a lot of System resources?
variable myjob number;
/
begin

Oracle 9.2.0.6 on hp-ux 11.11
Is supported by Oracle the use of triggers on materialized views?
I have seen that you can create them but i haven't seen documented
anywhere.

I'm trying to implement a program in PL/SQL on Oracle 9iR2, OS is Tru64,
that tells me the size in bytes before and after I compress some text.
It's a test to see how compressible data is over a moving window.
So, I want something like:

               We have a requirement where we want to transfer some
millions of data in 15-16 tables from one schema to same structure
tables in another. Both source and destination tables are partitioned.
Right now we are going for partition exchange for both schemas. But as

I'm doing an install for work on a windows xp (32bit) development
station.  To mimik the production systems I need to install 9.2.0.1.0
and then the patches for 9.2.0.4 and 9.2.0.5.  I've installed 9.2.0.1
and I have a disk for the patches but it is corrupted.  Where can I get

I'm getting a very mischievous error when querying Oracle spatial (10g
release 2).  The table was created by loading from a shapefile with polygons
using Oracle's shp2sdo.
I want to run the following aggregate query:

I don't know how this happened by I think I have a Oracle 9.2 database
that has no user with SYSDBA role anymore - no SYS, SYSTEM, etc.... I
have passwords for all of them and can log on as "Normal" but get
"ORA-01031: insufficient privileges" as soos as I specify:

This is a two part question and I hope I've included enough information to
elicit responses.
I am working with a data warehouse using an Oracle 10g R1 database.
I attempted a quick test of collections to see if it would work and how much