Wt are ways in oralce for data transfering between oracle databases
of same version or different
scenerio#1
1)4 databases runninge oracle 9i

          Can anyone provide some information in the form of documents
regarding "Database Infrastructure Design ". It would be better if the
document is matured enough to implement the concepts in it .
Its very urgent .

Oracle 9i on Solaris -- I'm running a query that shows the object and
how many blocks each object has in the buffer pool.  Is it possible or
does anyone have a query that differentiates between the recycle,
default, and keep pool?

I need to delete a number of old DBs for which I do not have the
passwords (these are failed restore attempts of a customers DB).  Since
I can not access them I want to remove the from Oracle 10G completely,
however I am finding it very difficult to find information on how to

Can anyone point me in the direction of comparisons between Oracle 9i code
and sqlanywhere code?
TIA
Liz

I would like to use in Oracle Reports Russian Language Whot I must
change????
Thanks!!!

I have seen db-links used in views, triggers etc.
This results in very bad performance.
Is there an good reference to read about, when and when not to use db-links?
Greetings

As part of finding low cost Backup and Restore solution for an
Oracle(single node, unix) server, we are thinking of using 'Legato'
networker without using the NSR-DBM-ORA module. If anybody uses such a
setup already, kindly provide more information on whether it will work

Oracle database 9.2.0.5 or 10.1.0.3
Platforms - Windows 2000 or HP UNIX 11i
When I do  a RMAN database backup, I do not see tempfiles backed up.
Only database files are backed up and shown in RMAN backup log.

I need some help creating a QUERY..
here's an example of what I need to do: say for instance my database
contains 3 values:
4012345

In Oracle10g, I have a Type with several Subtypes. I have an object
table of that type in which I can store the master type or any of its
subtypes. I know I can extract specific types with a where clause
including IS OF (ONLY MYTYPE). But if I'm selecting all objects out of

this may sound very silly, but I need to ask anyway, because I spent 1/2
day already trying to figure it out, mabey I'm missing something basic.
I have an Oralce 8.1.7 database on AIX. It was backed up regurlary, but
in my silliness, I never backed up the init.ora file for it.

My company has just begun to comply with Sarbanes-Oxley.  I would like
to know how other companies are handling support issues for Oracle
Windows DBAs.
Is your company documenting why an Oracle DBA needs Local Windows

Hi all,I have translated this procedure from T-SQL to PL/SQL.As you see it is
a mixed operation
procedure,I mean if some condition is true it does a DML and if other
condition is true it does a Query.

during the installation of Oracle 9.2.0.1. server in the part of
configuration of TNS listener Windows show error message and TNS listener
stopped.
after that installation continue and finish properly.