oracle rename table
oracle rename renames table, all constraints,indexes , grants will be transferred to new name.
SYNTAX:
Rename <old Name> to <new name>;
renames emp table to employees;
SQL>rename emp to employees;
CONS: once rename occurs on a table, all stored procedures, functions and views AND SYNONYMS WILL BE INVALID.
Note: rename will rename triggers associated with that table.
Tags: rename table in oracle,oracle rename table, oracle rename syntax, oracle rename cons,oracle rename pros, How to rename table in oracle,rename table affect on triggers.
Hello,
ReplyDeleteI want to rename tables but it is existing in another schema, like i am login as abc user and want to rename xyz schema table, it is not primiting to change name and giving me error
Error report:
SQL Error: ORA-01765: specifying owner's name of the table is not allowed
01765. 00000 - "specifying table's owner name is not allowed"
*Cause:
*Action:
please help me urgent