change table name

From: Jean-baptiste Guignard <guignardjeanbaptiste_at_yahoo.fr>
Date: Wed, 12 Dec 2001 14:29:49 +0000 (UTC)
Message-ID: <a322a4d66598dbf77c34f721975cdee6.50058_at_mygate.mailgate.org>

[Quoted] [Quoted] 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; [Quoted] Last question: What does the last line mean?

[Quoted] Regards before any help.

Jean-Baptiste

-- 
Posted from mix-dijon-117-2-185.abo.wanadoo.fr [80.9.65.185] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed Dec 12 2001 - 15:29:49 CET