Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ALTER TABLE RENAME TO
Hi,
I recently discovered that, along with the old RENAME command, that can be used to RENAME a table (and some other database object type too) we can now use the command ALTER TABLE <table_name> RENAME TO <new_name>;
The first improve of this new syntax is that we can now, logged with a DBA enable login, rename a table from another user.
Is there any other improvements? Since which version is this feature enabled?
-- Best regards Luis SantosReceived on Thu Apr 20 2006 - 15:11:19 CDT