schema compare is really a good thing.
1. Main Functions of Schema compare
compared with the differences between the two databases, including stored procedures, triggers, and table structures.
2. Program Installation
1. first, execute plsqldev902.exe under the PLSQL 902directory for installation. (Same as PLSQL Installation Method)
2. After the installation is successful, click PLSQL developer on the desktop. In the displayed registration window, click keygen.exe in the keygenfolder under PLSQL 902directory. Copy the content of product code, serial number, and password to the product number, serial number, and password text box in the registration information, and click Register.
3. Click deploymentsuitefororacle2.exe in the deployment suite for oraclefolder under PLSQL 902. The installation directory is the same as plsqldev902.
3. comparison using schema compare
1. open PLSQL developer and import the standard library to the new user. Assume that the new user name is tphy_test, the password is tphy, and the database is tphy. Back up the on-site database to a local database and import it to a pre-created new user. Assume that the on-site database username is tphy_xc, password: tphy, and database: tphy.
2. click the blue right arrow in the toolbar above PLSQL developer, and then click the schema compare white label that appears. (if there is no blue arrow in the toolbar, right-click the toolbar and click the custom label that appears, find the blue arrow in the list on the left, click the right arrow in the middle, add it to the list on the right, and click OK in the lower left .)
see: http://download.csdn.net/detail/huang_xw/4676855
required tools: http://download.csdn.net/detail/huang_xw/4677244