We are replatforming our datawarehouse from Oracle 9i in Sun Solaris
to 10g in IBM AIX 5.3. There is a direct connect network link
(Gigabit) setup between the two servers. The plan is to transfer the
data over a dblink.

Bear with me, DBAs. I am an AIX specialist with only basic Oracle 9i
exposure.
I have two AIX servers:
ServerA has a primary database PRIML01

In 10g, I use dbca to create RAC service names but in 11g dbca, I
could no longer use service management to create services. Is there
another way of creating service names other than srvctl? I used srvctl
to create services but the tnsnames.ora was not updated with the new

I've created an union query like this:
select 'DB' AS SRC, some fields from a table
union
select 'UP' AS SRC, some fields from a view

I've got a personal project for myself and a group of friends. we've
been playing poker together for about 5 years and decided to make a
website to keep track of our league results using apex. The data model
is pretty simple, it could be more complicated depending on what I

I'm writing an application using C++ and OCCI driver.
try
{
 MetaData tabInfo = conn->getMetaData( tab_name,

I've got Oracle XE installed on my desktop so I can explore and learn
Oracle preparatory to converting our apps from Sybase to Oracle. I
also have BEA Weblogic installed on my desktop so I can test my
webapps before deploying them.

How can I encrypt a field in a Oracle table ( Oracle 8i) so that apart
from any specific user it will show the encryted figure to the rest
while browsing the table ?

I'm trying to import a fixed-length ASCII file using SQLLDR.
The end-of-line is 0D 0A, as usual.
But some notes fields in the data use 0D 0D 0A within them.  SQLLDR
interprets this as end-of-line.

I am a junior dba. I was wondering if anyone could point me how to do
the following?:
I am currently trying to verify/calculate the size of my current
oracle db/schema. I've been using:

I've recently installed Oracle Grid control 10G to monitor a number of
db instances which is working well.
My manager is currently setting up a system that will include various
Key Performance Inidcators for oracle based systems e.g. uptime etc.

Is there a way to reset the DBID of a database to a specific value? For
example in the case if a duplicated database, I want to reset the DBID
of the auxiliary DB to it's original DBID after the duplication is
complete to make maintenance on the old backups easier. The auxiliary

I am a junior dba. I was wondering if anyone could point me how to do
the following?:
I am currently trying to verify/calculate the size of my current
oracle db/schema. I've been using:

Hi - We have a small Oracle server used by three programmers.
We would like programmer working on Schema A to be able to backup the
schema (at T1) and subsequently (at T2) restore it for the purposes of
testing etc.

hello group,
10g:
i've got this table "z" with following attributes:
id