how to find the instance for null-control item?



how to find the instance for null-control item?..

Answer / Chandra Bhushan Singh

To find the Oracle instance associated with a null control item, you can use the dba_registry view. Here's an example SQL query:n
SELECT name FROM dba_registry WHERE owner = 'NULL' AND name = 'CONTROL_FILE_NAME';

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Install Base Interview Questions

how to define install base item?

1 Answers  


how the instance is controlled by serial-no?

1 Answers  


when the instance will generate for product?

1 Answers  


how to trace the history of product?

1 Answers  


how to find expired iteminstance?

1 Answers  


what are different transaction-status in install base?

1 Answers  


how install base integrate with service request?

1 Answers  


how to update the system for instance?

1 Answers  


how to create default-instance summary page?

1 Answers  


how to view the salesorder information of product in install base?

1 Answers  


how to view the history of instance?

1 Answers  


what is the accounting classification to the instance?

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)