Re: Synonym in trucate table, drop table ...

From: Palooka <nobody_at_nowhere.com>
Date: Thu, 18 Dec 2008 22:13:38 +0000
Message-ID: <nWz2l.13445$Gh5.6474@newsfe16.ams2>


joel garry wrote:
> I suppose it would be, when you are doing DDL, you want to do it on
> the proper object.

Yep, that would seem to be the case, and as you impute, not unreasonable:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table x (y varchar2(100));

Table created.

SQL> insert into x values ('Hello World');

1 row created.

SQL> commit;

Commit complete.

SQL> create synonym z for x;

Synonym created.

SQL> delete from z;

1 row deleted.

SQL> rollback;

Rollback complete.

SQL> truncate table z;
truncate table z

                *

ERROR at line 1:
ORA-00942: table or view does not exist

SQL> drop table z;
drop table z

            *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> drop table x purge;

Table dropped.

SQL> drop synonym z;

Synonym dropped.

Palooka Received on Thu Dec 18 2008 - 16:13:38 CST

Original text of this message