i have an oracle database and an SQL Database i query both and at the
mo i have to query one then put records in an array then query the
other than update the array.
Is there a method in VB6 that i can simply link the two (dsn-less

I have to duplicate a big table
so I did:
insert /*+ append nologging */
into  table2

Can I use safely datafile larger than 2 GB ?
I know it is a file system limitation not oracle limitation,
now on recent filesystem there is no such limitation.
Is this a "psychologic" limitation ?

Dear Gurus ,
as far as i know and tested , when i issue a parallel select statement
, oracle ,instead of looking at database buffer cache first, it
directly requests the data from the disk system. And when it reads the

OK, this one's pretty ugly.  Let me start with some background.
Oracle 9.2.0.5 server.  One data instance, one repository instance.
Database is up 24/7, with hot backups nightly run from OMS.  Nightly,
the OMS/agent/repository is shut down automatically, and a tape backup

We have a product that requires an Oracle client to run, currently we
are shipping Oracle 8.0.5.
when this is installed oracle will prepend it self to the path, placing
the oracle directory in front of the %WINDIR%\system32 folder. This in

Hi!  I like PL/SQL's capability to insert a row all at once, using
%ROWTYPE.
CREATE TABLE TEST
(a NUMBER DEFAULT 0 NOT NULL);

I read in the Oracle 9i Concepts document, that a free space generated
by deleting or updating of data can be used only by an insert statement
in the same transaction as of delete/update or any insert statement
immediately after the DML statement. So does that mean if there is no

Oracle 10g, Linux 386, Cooked files
I need to calculate/estimate how much disk space a database will use.
What would be best: Create the database add data, check size, add data
and check size and use the difference to estimate how much the database

Can someone give me an online link of all error messages in Oracle
databases (all versions)? Or if someone has a dump (PDF/ XLS / DOC) and
can share it with me, pls let me know....
Thx

I ran into an issue today that reminded me of a long-running question
about Oracle and Remedy. I updated the statistics on one of our larger
tables (TEC_EVENT, 5GB) which I cascaded down to the indexes. I used
DBMS_STATS to compute the stats across the entire table (no samples).

The following is quoted from the 10gR2 Beta document.
=======================================================================
The connect role privilege reduction feature reduces the number of
privileges granted to the connect role to one, the CREATE SESSION

This might be too much hassle for most of you but someone might be up for a
good challenge. I need to figure out how to optimize this query (at bottom
of this post) for Oracle 9i.
I have a table of sales figures (C_ACC_SALES) based on the following

I am on Windows 2000 and using Oracle 10G (10.1.0.3). In earlier
versions of Oracle, Oracle 9i, I always did export with consistent=Y.
In Oracle 10G, expdp, I do not see a consistent parameter, instead see
FLASHBACK_TIME.

I don't even know if this is possible, so any help is gratefully received.
I would like to extract rows from two different tables, having the same
columns, into one result set.
So, if Table A has col1 and col 2, and Table B has col1 and col2, then I