Re: Rebuild table
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 24 Jun 2011 13:03:30 +0200
On 23/06/2011 23:39, Wayne Smith wrote:
Am I missing something?
Public and private synonyms?
If you're using CTAS + rename you don't need to worry about them (unless
I'm missing something):
SQL> create table t as select * from dual;
Table created.
SQL> create public synonym t_pub for t;
Synonym created.
SQL> create synonym t_priv for t;
Synonym created.
SQL> create table tt as select * from t;
Table created.
SQL> drop table t;
Table dropped.
SQL> rename tt to t;
Table renamed.
SQL> select * from t_pub;
D
-
X
SQL> select * from t_priv;
D
-
X
The status of those synonyms changes after the drop
but they become valid again the first time they are referenced after the
rename.
Regards
Dimitre
Other related posts:
