> -----Original Message-----
> From: William Rogge [mailto:[EMAIL PROTECTED]]
>
> 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
----------
1
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
----------
2
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
