schema compare / rename column issue

agent86

Member²
PL/SQL Developer version: 6.0.5.931

DB1:
SQL> desc auction_user
Name Type Nullable Default Comments
----------------------------- ------------- -------- ------- --------
AUCTION_USER_ID NUMBER
NAME VARCHAR2(255)
STATION_ID NUMBER 0
IS_EMAIL_CONFIRMED NUMBER
EMAIL VARCHAR2(255) Y
EMAIL_VALIDATION_TOKEN VARCHAR2(255) Y
CREDIT_CARD_WALLET_ACCOUNT_ID NUMBER Y
IS_IN_GOOD_STANDING NUMBER
STRIKES NUMBER 0
FROZEN NUMBER 0
BANNED NUMBER 0
PAYPAL_WALLET_ACCOUNT_ID NUMBER Y

DB2:

SQL> desc auction_user;
Name Type Nullable Default Comments
----------------------------- ------------- -------- ------- --------
AUCTION_USER_ID NUMBER
NAME VARCHAR2(255)
STATION_ID NUMBER 0
IS_SELLER NUMBER
IS_EMAIL_CONFIRMED NUMBER
EMAIL VARCHAR2(255) Y
EMAIL_VALIDATION_TOKEN VARCHAR2(255) Y
CREDIT_CARD_WALLET_ACCOUNT_ID NUMBER Y
IS_IN_GOOD_STANDING NUMBER
STRIKES NUMBER 0
FROZEN NUMBER 0
BANNED NUMBER 0
PAYPAL_WALLET_ACCOUNT_ID NUMBER Y

PL/SQL Developer Schema Compare (from DB1 to DB2):
----------------------------
-- No differences found --
----------------------------

The other way now:
PL/SQL Developer Schema Compare (from DB2 to DB1):
rem Differences between AUCTIONS@DB2 and AUCTIONS@DB1, created on 5/16/2005
rem Press Apply button, or run in Command Window or SQL*Plus, connected as AUCTIONS@DB1
----------------------------------
-- Changed table auction_user --
----------------------------------
-- Add/modify columns
alter table AUCTION_USER rename column IS_EMAIL_CONFIRMED to IS_SELLER;

Strange....no matter which way it points it gets it wrong in both cases. Any insight to this?

Thanks!
 
Back
Top