| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: "Drop & Recreate table" or "alter table drop column". Which
> -----Original Message-----
> From: William Rogge [mailto:William_Rogge_at_voltek.com]
>
> Because of any synonyms (which are based off of object
> numbers), Option 1
> is the only way to go. That is of course unless you want to
> perform extra
> work dealing with the synonyms.
I believe that your statment "synonyms are based on object numbers" is incorrect. I created a table, created a synonym to that table, then dropped the table, created another table with the same name, and the synonym "found" the new table.
SQL> create table t (n number) ;
Table created.
SQL> insert into t (n) values (1) ;
1 row created.
SQL> commit ;
Commit complete.
SQL> create synonym s for t ;
Synonym created.
SQL> select * from s ;
N
SQL> drop table t ;
Table dropped.
SQL> create table t (n number) ;
Table created.
SQL> insert into t (n) values (2) ;
1 row created.
SQL> commit ;
Commit complete.
SQL> select * from s ;
N
 |
 |