Aqua Data Studio 15.0.0-dev-142
Build #: 36450
Built on: 2014-Mar-04 02:16:34 PM
OS : Windows 8 , 64 bit
Database : Oracle 12c
Issue: RENAME TO option should be provided in Alter Trigger script in Oracle 12c
Steps to Reproduce:
Connect To Oracle 12c
Create Tables and Trigger (Execute the below scripts, please use different Tablespace while executing scripts)
create table TestEmployee_A(
ID VARCHAR2(4 BYTE) NOT NULL,
First_Name VARCHAR2(10 BYTE),
Last_Name VARCHAR2(10 BYTE),
Start_Date DATE,
End_Date DATE,
Salary Number(8,2),
City VARCHAR2(10 BYTE),
Description VARCHAR2(15 BYTE)
)tablespace TUSHAR
Go
create table TestEmployee_audit_A (
id VARCHAR2(4 BYTE),
salary Number(8,2),
delete_date Date,
deleted_by VARCHAR2(15 BYTE)
)tablespace TUSHAR
Go
create trigger after_insert_A
after insert on TestEmployee_A
for each row
begin
insert into TestEmployee_audit_A(id,salary) values(:new.id,:new.salary);
end;
1] Now go to trigger "after_insert_A" and right click on it
Select option Script object To window As -> ALTER
2] Alter Trigger Script Generated.
Here we observed that RENAME TO option is missing in the script, while we can Alter trigger name successfully.
Please Execute the below script
Alter Trigger "AFTER_INSERT_A" rename to "AFTER_INSERT_B"
go
Trigger Renamed successfully.
[Please see attached image]
