y*h 发帖数: 107 | |
B*****g 发帖数: 34098 | 2 do you have toad?
【在 y*h 的大作中提到】 : thanks
|
w*******e 发帖数: 1622 | 3 RedGate?
【在 B*****g 的大作中提到】 : do you have toad?
|
y*h 发帖数: 107 | 4 no, I don't have toad
【在 B*****g 的大作中提到】 : do you have toad?
|
B*****g 发帖数: 34098 | 5 if you use oracle try oracle sql developer.
【在 y*h 的大作中提到】 : no, I don't have toad
|
y*h 发帖数: 107 | 6 yes, I downloaded oracle sql developer already, and can access to
each schema.
next, how do I compare two schemas for missing indices
【在 B*****g 的大作中提到】 : if you use oracle try oracle sql developer.
|
B*****g 发帖数: 34098 | 7 I did not use sql developer for 3 years, try below, not sure will it work
for you
http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm
Schema Diff
Compare and create SQL Difference statement between 2 schemas
Select objects to compare
Report of objects to be compared
List of differences and SQL Code to be executed
Run script output to SQL Worksheet to be executed against connection
of choice.
Or
Just compare in all_indexes table
【在 y*h 的大作中提到】 : yes, I downloaded oracle sql developer already, and can access to : each schema. : next, how do I compare two schemas for missing indices
|
y*h 发帖数: 107 | 8 thanks
【在 B*****g 的大作中提到】 : I did not use sql developer for 3 years, try below, not sure will it work : for you : http://www.oracle.com/technology/products/database/sql_developer/files/featurelist_1_5.htm : Schema Diff : Compare and create SQL Difference statement between 2 schemas : Select objects to compare : Report of objects to be compared : List of differences and SQL Code to be executed : Run script output to SQL Worksheet to be executed against connection : of choice.
|