| Schema Export, table compares across schemas [message #489007] |
Wed, 12 January 2011 20:59  |
oruorainfo
Messages: 46
Registered: May 2010
|
Member |
|
|
Hello, would anyone be able to help with some pointers on the following items. Not sure if these are possible. Thanks!
1)Want to perform an Export from a Production Schema and Import the results into Test Schema.
BUT, do not want to export ALL objects from Production (only a subset of tables). Is this possible?
If yes, can you point me to any doco on how to do
this? (rather than a complete Export and then a complete Import).
2)I have 2 test instances of Oracle on the same development server, UNIT and SIT. Am using Oracle SQL Developer tool.
While in the UNIT instance, is there a way to select data
from the SIT instance? An example of syntax to use?
3) Can tables in the UNIT instance be compared to tables
in the SIT instance, through any existing Oracle utilities,
if yes, any pointers as to what these utilities might
be called?
Many Thanks!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
