OSDM import issue - ‘alter table .. rename ..’ does not work
I need rename a table, its constraints etc which already exists in my OSDM model.
I tried importing DDL script which has rename commands but it doesn’t work.
Also because table is not renamed, other DDL statements to create FK pointing to this table fail.
I tried import following DDL script –
CREATE TABLE W_EHA_RSLT_FILE_TYPE
(
ROW_WID NUMBER (38) NOT NULL ,
FILE_TYPE_CODE VARCHAR2 (80) NOT NULL ,
FILE_TYPE_NAME VARCHAR2 (200) ,
FILE_TYPE_DESC VARCHAR2 (2000) ,
FILE_TYPE_VERSION VARCHAR2 (30) NOT NULL ,
W_INSERT_DT DATE ,
W_UPDATE_DT DATE ,
ETL_PROC_WID NUMBER (10) NOT NULL ,
ENTERPRISE_ID NUMBER (38)
)
;
ALTER TABLE W_EHA_RSLT_FILE_TYPE
ADD CONSTRAINT W_EHA_RSLT_FILE_TYPE_PK PRIMARY KEY ( ROW_WID )
USING INDEX TABLESPACE &&INDEX_TS ;
ALTER TABLE W_EHA_RSLT_FILE_TYPE
ADD CONSTRAINT W_EHA_RSLT_FILE_TYPE_UK UNIQUE ( FILE_TYPE_CODE , FILE_TYPE_VERSION )
USING INDEX TABLESPACE &&INDEX_TS ;
alter table W_EHA_RSLT_FILE_TYPE rename to W_EHA_FILE_TYPE;
ALTER TABLE W_EHA_FILE_TYPE RENAME CONSTRAINT W_EHA_RSLT_FILE_TYPE_UK TO W_EHA_FILE_TYPE_UK;
ALTER TABLE W_EHA_FILE_TYPE RENAME CONSTRAINT W_EHA_RSLT_FILE_TYPE_PK TO W_EHA_FILE_TYPE_PK;
create synonym W_EHA_RSLT_FILE_TYPE FOR W_EHA_FILE_TYPE;
I also tried incremental DDL ( script with just rename commands) but that doesn’t work either.