Compare does not work after table rename with wildcard.
Here is reproducible steps.
1. create table
- source
$ sqlplus sq1/sq1
SQL> create table tbl (name varchar2(10) primary key, first varchar2(15));
- target
$ sqlplus sq1/sq1
SQL> create table tbl (name varchar2(10) primary key, first varchar2(15));
2. activate config
< config file >
---
expand sq1.% sq1.% hostname@o.orcl
---
3. run "ALTER TABLE RENAME"
$ sqlplus sq1/sq1
SQL> alter table tbl rename to tbl_wk;
4. run compare
sp_ctrl > compare sq1.tbl_wk
WORKAROUND:
Re-activate the same config file.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center