Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PUBLIC SYNONYM Difficulty

Re: PUBLIC SYNONYM Difficulty

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Apr 2006 16:10:17 -0700
Message-ID: <1144192217.532241.98420@u72g2000cwu.googlegroups.com> 





Yes, truncate is a DDL statement.  For anyone other than the owner to
truncate the table the owner name must be specified.  For example:



truncate table bob.some_table reuse storage;



To truncate a table that does not belong to you the DBA or delete any
table privilege is required.



HTH -- Mark D Powell --
Received on Tue Apr 04 2006 - 18:10:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US