I'm using DBVISUALIZER. How can I edit the contents of a CLOB/BLOB
column that is originally text?
Thanks for your help.

i am using the oracle 10g database . i want to create a statistic about
how many tables from a certain user has never been queried by the
select statement ( e.g. in the last three months ) .  does anybody has
an idea ?

Does enyone knows, how to write data in russian  or ukrainian to oracle
table ( ver 9.2.0.5)?
How to set NLS_LANG on client machine i how to set NLS parameters of DB ?
Now i have on the server

The logwriter writes to the logfile on disk, so it must accumulate a
block of log records before flushing to the log file.  Suppose a
transaction commits, but the commit record flushing is delayed by the
log writer waiting to fill a block.  What would happen to the

I want to install Oracle iFS. However, i can't
find this from oracle installation wizard
Where can i find Oracle iFS installer?

We have a 10.1.0.2 Standard RAC running on RHEL 3.0 ES. Our custom app runs
great for 3 months or so and then it gets slow. The same queries get really
slow. The indexes appear to be ok, we rebuild then as necessary. Once it
gets slow, we export, drop user/schema with cascade, ...

we have 9.2.0.x database and we need to create histograms on weekly basis.
The problem is that it takes a long time and we would like to speed it up.
There are many tables with hundreds columns and hundred indexes
Any ideas how to do this,

after my update from 10gR1 to 10gR2 went out smoothly I am faced with a
info from OEM I am not really sure if I should take it or not. OEM says
that my SYSTEM-tablespace is set to manual segment-space management
which should be auto. As I already have taken down any applications ...

Oracle Version - 8.1.7.4
OS - AIX 5.2
I have a java stored procedure that uses log4j to write to a log file.
If I grant the user permission to write to a directory like this, the

My VB application accesses the database via ADO and it seems that ADO
(or is it the trace utility??) performs some weird SQL statements,
which slows down the overall performance of the database. All these
statements look like

I'm using Oracle 9i.
While writing aggregate function which is supposed to find the smallest
distance between points in 3d space I faced a problem which can be
considered serious as far as an Oracle newbie like me is concerned.

Hello.  We are running a three node RAC on 10g using a NetApp FAS250
and three Sunfire 210 servers.
I've got two problems I hope someone can help me with:
(1) If one of the three nodes goes down, the other two continue to

in the course of finding out how to connect an Oracle database
to OpenOffice 2.0 via JDBC I read a posting in this group:
"I use JDBC and it works flawlessly. Unfortunately, I'm running Linux."
but how?

Where is the executable code of a trigger stored in the DBMS? My guess
is the data database buffer (if present) or the data file?
Can anyone confirm or correct me?
Thanks in advance!

I need to delete records on multiple tables, based on the value of one
Column say.. ColID.
Do I need to delete the records from each table separately,like
Delete from TableA where ColID = 1;