I am having an opening in Data Warehousing for Chennai/ Bangalore: 5+
Years
Primary Skill: Data Warehousing
Skill: Exp: 5 + Years

One of the best technologies Oracle has released in recent years is ASM.
And as much as many Oracle DBAs would like to learn ASM, and how to work
with RAW devices, they have been stymied by the lack of hardware on
which they can learn. That problem has been solved.

Can you restore an Oracle 8i database that is one build on an Oracle
8i installation that is another build?
If not, i guess my only option is to install the correct Oracle 8i build?
Thank you

Hi. Sorry I think i posted this message in the wrong forum...
I was hoping someone could help me. I am trying to display the time part
of a datetime datatype in my query (in this isntance the column containing
the datetime datatype is called 'starttime'). How does one accomplish ...

Hey all,
 Anyone know why orablogs is down?  The last time I was able to get
there was about 2 days ago, since then nada.
Any ideas?

I've recently had to take over responsibility for a number of Oracle
databases, and armed with a week of training from a certain member of
this list :) I'm embarking on solving my first little problematic issue...
I need to set up the local JVM in Oracle.  Currently, the databases ...

I am trying to drop a table but can't because it says I have to drop a
materialized view which doesn't exist ...I found this out when I tried
to follow the suggestion below!
ORA-12083: must use DROP MATERIALIZED VIEW to drop

I am having a problem with specifying the amount of memory for the indexing
process to use when creating or syncing an index. I have sat both the
max_index_memory and the memory parameter of create index and
ctx_ddl.sync_index, but the settings seems to be ignored. The memory on the

I did a network trace yesterday for the results coming back from an Oracle
9.2 server running a stored procedure in a package.  This was called from
ADO from a windows 2003 server.
the expected resultant record set is a 15 byte customer id.  The network

I am trying to install middle tier on machine 'avanur' and my
infrastrucutre is on machine 'ps0887'. During installation "Portal
Configuration Assistant" is failing with following error :
***********************************************************************

I have a client/server application that work on the client with oracle 8i
client connected to
oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g)
, and

I'm a beginner so please bear with me on this: I've been using the WITH
clause in SELECT statements in 10g, and its a great. However, it cannot
be used with UPDATEs, only SELECTs. Does anyone have any tips on how
this could be emulated? For example if a subquery S is to be used ...

Someone (not me) has installed Oracle 9.2.0.1.0, and I do not know what the
password for SYS is. In Oracle 8.1.7 the password was CHANGE_ON_INSTALL if
nothing was done to the default setup.
Is there another default for 9.2.0.1.0 ?

I'm using OEM with Oracle 9i (9.2) on Windows, and I've noticed that
when I viewing the contents of a table (Table Editor), that when I
refresh, it is not showing the most current data.  It doesn't show the
current data even if I disconnect and re-connect in OEM.

On a customers db-server, we have a single Oracle service that should
be started automatically when the system boots.
This used to work well, but the machine has been moved into the
customers windows-domain, and the instance won't be started