i am a beginner of using oracle so , i am not familiar of the syntaxes,
so anyone can suggest some website or references to me/
thanks very much!

In what case is this possible?
the update statements I saw were something like;
update my_table set other_column=other_column+1 where id=:my_id;
other_column is not being referenced..

When I install the Oracle XE client on Suse Linux 10.0, the installer
complains that I need libaio 0.3.96, but I have a newer version: 0.3.104-3.
Any ideas how to get the installer to work with the newer version?

I am very new to Oracle and want to evaluate Oracle 10g Designer.  I
downloaded it but am having problem with the creation of a repository.
Basically, my DBA wants to know (and rightly so) what permissions are
necessary for the db user who creates the repository.  He doesn't want

I am starting to see a lot of junk tables and triggers that start with
something like BIN$bldskfjd ... How can I get rid of them quickly
enmasse with the least amount of repetitive drop statements. I have the
web based enterprise manager.

I am a SQL Server DBA...I'll wait for the laughing to stop :)
Is anyone aware of a utility that we can use\purchase that can be used
to convert an Oracle .dmp file to some other usable format for SQL
Server.... like .csv maybe.

I'm new in Oracle.
I've got two DBs one in production and other which is a test db.
Everty night I make a cold backup of the production DB.
Now, I want to copy these files to the TEST database.

If I am running dbms_stats.gather_schema_stats(user, 'TIME',
method_opt=> 'for all indexed columns size skewonly', cascade => true
);  Why would a single column, primary key, of varchar2 datatype get a
histogram generated. That could explain a lot to me. I thought if a

Setting aside indexes, does anyone know how the technical Oracle
internals do row by row, field by field compares of data for a join
between 2 tables with decent performance ?
Thanks,

Oracle 9.2
I've been digging thru tahiti and the ng archives for the last two
hours, and can't find what I'm looking for.
Trying to set up a logon trigger to start extended tracing ... code is:

An analyst-programmer came to me and said they had chosen
to create a partitioned table on a DATE field that is supposed
to be updated (on a more or less regular basis, and not for
all records contained in that table) in such a way that it would

Where can I get the Oracle 10g Documentation?
I know that it is available at www.oracle.com , but we need to be an
OTN member for accessing that.
I want the documentation for the follwing topics (links for these

I got a table named books with its field name Accno (access number) and
author (Name of the author).
i created a sequence with the following syntax
create sequence seqbook increment by 00000001 start with 000000001

I have 2 databases on an oracle 8i server running NetWare 5.1.  They are
duplicate databases as far as structure.  The has data that is about 8
months older than the other.  How can I copy data from one to the other.
Example;

I've been wasting hours on this and I still don't know what's wrong with my
code.
Can anyone tell me what misses in this code to make the insertion work?
The set up of php apache and oracle is ok. I can select stuff from the db.