-- SQL*Plus --

SQL> conn dryer@m
Enter password: *********
Connected.
SQL> desc fmmg_owners
 Name                      Null?    Type
 ------------------------- -------- ------------
 OWNER_ID                  NOT NULL NUMBER(38)
 OKPO                      NOT NULL VARCHAR2(10)
 CUST_OWN                  NOT NULL CHAR(1)
 CUST_ID                            NUMBER(38)
 OWNER_ADD                          DATE
 ZIP                                VARCHAR2(10)
 COUNTRY                            VARCHAR2(50)
 STATE                              VARCHAR2(50)
 REGION                             VARCHAR2(50)
 CITY                               VARCHAR2(50)
 STREET                             VARCHAR2(50)
 BUILDING                           VARCHAR2(20)
 OFFICE                             VARCHAR2(20)

SQL> conn dryer@f1
Enter password: *********
Connected.
SQL> desc fmmg_owners
 Name                      Null?    Type
 ------------------------- -------- ------------
 OWNER_ID                  NOT NULL NUMBER(38)
 OKPO                      NOT NULL VARCHAR2(10)
 CUST_OWN                  NOT NULL CHAR(1)
 CUST_ID                            NUMBER(38)
 ZIP                                VARCHAR2(10)
 COUNTRY                            VARCHAR2(50)
 STATE                              VARCHAR2(50)
 REGION                             VARCHAR2(50)
 CITY                               VARCHAR2(50)
 STREET                             VARCHAR2(50)
 BUILDING                           VARCHAR2(20)
 OFFICE                             VARCHAR2(20)
 OWNER_ADD                          DATE


-- PL/SQL Developer Compare User Objects output: --

rem Differences between DRYER@M and DRYER@F1, created on 25.08.2004
rem Press Apply button, or run in Command Window or SQL*Plus, connected as DRYER@F1
---------------------------------
--  Changed table fmmg_owners  --
---------------------------------
-- Add/modify columns 
alter table FMMG_OWNERS rename column STATE to COUNTRY;
alter table FMMG_OWNERS rename column REGION to STATE;
alter table FMMG_OWNERS rename column CITY to REGION;
alter table FMMG_OWNERS rename column STREET to CITY;
alter table FMMG_OWNERS rename column OFFICE to BUILDING;