Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle10g** are assumed to be specific to this version or features introduced in this version.

learn more… | top users | synonyms

6
votes
3answers
75k views

How to restore/import an Oracle database from dmp file?

I've recently recieved the dump file of the soon to be migrated Oracle Database. I've installed Oracle 10g and now i need to restore the original database. Can anyone give me a step to step ...
1
vote
1answer
986 views

Oracle RAC: Configure instance to depend on VIP

In previous version of Oracle RAC with Oracle clusterware, before 10.0.1 I believe, an instance was dependent on a VIP resource. Once a vip was failed or relocated, the Instance would be stopped. In ...
1
vote
2answers
3k views

Find Current open Cursors in Oracle

What is the query to find the no. of current open cursors in an Oracle Instance? Also, what is the accuracy/update frequency of this data? I am using Oracle 10gR2
1
vote
2answers
2k views

“Create global objects” rights on a terminal server

Talking about this security setting: link text We have been having problems with the oracle 10g client on our Citrix servers. Through google I figured out that granting users this security right ...
13
votes
6answers
19k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
1
vote
3answers
813 views

How can I install Oracle on my Windows XP machine which uses DHCP?

I'm installing a copy of Oracle on my development workstation because running tests against a remote database is terribly slow. However, it says something about me having to set the loopback adapter ...