Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OSDM import issue - ‘alter table .. rename ..’ does not work

897831Jun 14 2012
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2012
Added on Jun 14 2012
0 comments
152 views