Re: Rebuild table

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: