Re: change table name
From: Geoff May <Geoff.May_at_NOSPAMMERALLOWEDdoka.de>
Date: Wed, 12 Dec 2001 15:45:00 +0100
Message-ID: <3c176d6a$0$189$4d4ebb8e_at_read.news.de.uu.net>
Date: Wed, 12 Dec 2001 15:45:00 +0100
Message-ID: <3c176d6a$0$189$4d4ebb8e_at_read.news.de.uu.net>
"Jean-baptiste Guignard" <guignardjeanbaptiste_at_yahoo.fr> schrieb im
Newsbeitrag
news:a322a4d66598dbf77c34f721975cdee6.50058_at_mygate.mailgate.org...
> How can we modify table name physically.
>
> Is the following request enough?
>
> UPDATE USER_OBJECTS
> SET OBJECT_NAME = 'NEW_TABLE_NAME'
> FROM USER_OBJECTS owing
> WHERE OBJECT_NAME = 'OLD_TABLE_NAME';
>
> COMMIT;
>
> ALTER SYSTEM FLUSH SHARED POOL;
>
>
> Last question: What does the last line mean?
>
> Regards before any help.
>
> Jean-Baptiste
In SQL-Plus there is a RENAME command. Why not use that?
MfG
Geoff. Received on Wed Dec 12 2001 - 15:45:00 CET