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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: rename table - insufficient privilege (ORA-01031) - more info

Re: rename table - insufficient privilege (ORA-01031) - more info

From: Martin Mølskov Hansen <mmh_at_kab-bolig.dk>
Date: Sat, 13 Mar 2004 18:56:47 +0100
Message-ID: <405349f4$0$1598$edfadb0f@dread14.news.tele.dk> 






Should be


 ALTER TABLE <schema>.<old_name> RENAME TO <new_name>;




Regards


Martin Mølskov Hansen



"Alexandr Molochnikov" <NOBODY_at_NO_SPAM.com> skrev i en meddelelse
news:oHr4c.162527$A12.121949_at_edtnps84...


> Oops - forgot to mention that Oracle version is 9.2, and it runs under

> Windows XP.

>

>

Received on Sat Mar 13 2004 - 11:56:47 CST












Original text of this message













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