strange lock (hang)
I have a big replication so I choose do not use "replication" but recreate mview on target site.
for that I do :
- create table a.tmp_copy_table from a.mymview
- create public synonym mymview for a.tmp_copy_table
- grant correct right for users
- drop materialized view a.mymview
- test a select * from mymview (so I use public synonym) => ok
- launch the creation the mview (create materiali.... as select ...@site).
my problem , during the creation of mview :
- I can't use my public synonym because it hang (select * from mymview )
- I can use may directly a.tmp_copy_table .
- I
0