I am not sure how to answer this question:
"What happens if you run a DDL, say alter table, on a table currently
being accessed by a long-running query?"
Would the query fail?

with update global indexes.
We did this on 2 partitions of different tables today and timings were
very different.One was 10 minutes and other was 100 minutes. Number of
rows are similar but the table that took longer had one more index.

Hi,
i have a problem. I'm enabling a unique constraint, that is
creating a index on a table. The table contains 135000000 rows
( 13 GB)

I have enabled directio and async io on my redhat box.
Async io is verified by running the classical cat
/etc/proc/slabinfo|grep kio
How do i verify direct io is being used by oracle.

I Got An Question , Been Searching The Documentation .. Not Getting An
Hang Of It.
I Would Like To Know , If Undo Block Is Brought In The Buffer Cache,
During An Update.. SO What Process Write The Undo Block [Old Image] To

I know it is possible to encrypt a package body, or table columns. But
my concern is, can you hide the source code of a view from all grantees
in a similar way ? I mean, using same tools, or a different workaround
must be taken ?  

Hi all Oracle users,
I need to install Oracle 9i on a Solaris (x86) box.
I took a look at the download section and it's mentioned
only Oracle 9i for Solaris ** SPARC **.

I am trying to Export and Import user data with multiple table spaces.
That is, Exporting data based on a user who uses multiple tablespaces then
Importing data to a different user with a single tablespace (to a different
tablespace of course.)

I assumed that 9.2.0.6 will be the terminal release for oracle 9i. I was
surprised when i was doing a search on bugs on dbms_stats i found a note
that said "fixed in 9.2.0.7". The patchset will be released sometime
this month for solaris (32 bit). But really could not find if ...

I'm trying to write a query that will, from Oracle 8i, query a Windows
Active Directory and return values based on the query.
I'm not finding anything useful on this topic and was wondering if
anyone else had tried this.

I've been asked to install the JVM on a Windows 2000 machine running
Oracle 8.1.7.3.
I've done this under Unix by running the initjvm.sql, but I'm looking
for documentation on whether or not it is the same on Windows.......

I have installed 10g in the PC and want to install 8i also.
What problems will be faced.
Is there a way to have both in the same PC and both running ?
What is to be done before installing 8i with 10g already installed.

Is it possible to create a db on my local machine and to connect to it with
the only full Oracle Client version?
My Oracle Client version is 8.1.7 and if i attempt to connect to it i obtain
the following error:

Having trouble getting the oracle management server discover nodes to
"automatically discover" a node on our newly installed Red Hat AS3
server. Can ping the ip address, sql plus it, but it does not appear in
our windows network. Manual entry is no problem but we would like to

Is it possible to have SSO authenticate certain users against OID and
another set against another directory such as Active Directory?  We may
have the need to authenticate and provision external users within OID.
Internal clients already exist in a corporate Active Directory so we