This was tested on an Oracle 11 database. First I created a table and analyzed it:
SQL> create table andrew1 (one_col number)
SQL> create table andrew1 (one_col number)
2 /
Table created.
SQL> analyze table andrew1 compute statistics
2 /
Table analyzed.
SQL>
SQL> create synonym andrew2 for andrew1
SQL>
Then I created a synonym for the table:
SQL> create synonym andrew2 for andrew1
2 /
Synonym created.
SQL>
SQL> desc andrew2
SQL>
I found that I was able to describe the table via the synonym:
SQL> desc andrew2
Name Null? Type
----------------------- -------- ----------------
ONE_COL NUMBER
SQL>
... but I could not analyze it:
SQL> analyze table andrew2 compute statistics
2 /
analyze table andrew2 compute statistics
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>
SQL>
No comments:
Post a Comment