Oracle Rename Table – Example Syntax and Dependencies

Posted on May 16, 2009 in Technical Tips | 0 comments



Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax:

1

ALTER TABLE current_table_name RENAME TO new_table_name;

In practice, you might realize you left off a prefix that you are using as a naming standard. Changing the table name can be accomplished with the following example syntax:

1

ALTER TABLE employee RENAME TO dw_employee;

If the table is already in use, I recommend that you review custom code, Oracle packages, stored procedures, and any other references to the table. You can use tools like TOAD to view dependencies on the table prior to renaming it. Below is a screenshot within TOAD of the “Used By” tab that can be used when your table is selected in the schema browser:

used_by

Bookmark and Share

Related Information:

  1. Oracle Rename Column – alter table, rename column Example SQL Syntax
    Following is simple example syntax...
  2. alter table, add column – Oracle Example Syntax
    Following is simple example syntax...
  3. Oracle Materialized View DDL
    Are you a TOAD fanatic...
  4. Copy Table Columns and Data
    As you may know, in...
  5. Oracle SUBSTR Function – SQL Syntax Examples
    The Oracle SUBSTR SQL Function...
  6. Oracle SUBSTR with INTSR Function – SQL Syntax Examples
    Oracle SUBSTR and INSTR SQL...
  7. Oracle INSTR Function – SQL Syntax Examples
    The Oracle INSTR SQL function...
  8. Create Table – ORA-00907: missing right parenthesis — CHECK and DEFAULT Order Swapped
    Most people, including myself, don’t...

Leave a Reply