Search
Navigation
Recent blog posts
- Oracle IN Condition and Multi Column Subqueries
- SQL For Dinosaurs
- Quickie script to run dbv on your database...
- Permissions for Autotrace
- Accuracy of PROFILER.SQL from Metalink Doc: 243755.1
- Recording Oracle System Stats for historical analysis...
- Shell Script to Run a SQLPLUS against all databases running on a server...
- Viewing command line args with Solaris ps utility...
- Orion IO Test Tool
- Documented Hints available in 11.2...
Books
User login
Instance Differences
dmann — Tue, 11/10/2009 - 17:48
A book to guide you though comparing two instances.
This will help when someone comes to you and asks "It runs fine on
For most of these you will want to log into the source database as SYSTEM and create a DB Link so you can query target database over a DB Link. For these examples I will call the DB links DATABASE1 and DATABASE2.