Search This Blog

Friday, April 18, 2008

Oracle Table Rename Syntax

There is a direct command to rename table.
The syntax is as follows


alter table
table_name
rename to
new_table_name;


Note: When the table is renamed the referenced object like PL/SQL, applications etc are not updated. Hence this may make those invalid. However the indexes, constraints etc are updated.

4 Comments:

Diego said...

i can rename several tables like this
alter table original rename to work;
alter tmp original rename to original;
alter table work rename to tmp;
but this is not atomic.
i want to rename all my tables in one line, how can i do this.

Y Kiran Kumar said...

how can i create a procedure for the dbms_output.put_line package. i dont want to type the command dbms_output.put-line all the time instead of that i want to write a procedure and want to call when ever required

Suresh Vaishya said...

Create private procedure and call that within your program

e.g.
CREATE PACKAGE BODY xx AS
PROCEDURE log(p_string VARCHAR2)
IS
dbms_output.put_line(p_string);
END;
...
...
-- main code
log('print message');
...
...

END xx;

Hope this is helpful.

Suresh

sap project management said...

Wow. I have always renamed the tables one by one and have not used any procedure to do this task atomic. As you have mentioned the procedure also I will implement this but what to do to make the relevant changes in other corresponding objects like PL/SQL & applications that make use of these tables.

Copyright (c) All rights reserved. Presented by Suresh Vaishya