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: Alex Molochnikov <NOBODY_at_NOSPAM.COM>
Date: Sun, 14 Mar 2004 07:44:37 GMT
Message-ID: <F3U4c.798599$ts4.144552@pd7tw3no>

It worked.
Thank you very much for your help.

Best regards,

Alex.

"Martin Mølskov Hansen" <mmh_at_kab-bolig.dk> wrote in message news:405349f4$0$1598$edfadb0f_at_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 Sun Mar 14 2004 - 01:44:37 CST

Original text of this message

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