--#
--# Manuelle Erstellung der neuen Indexe und Constraints
--#
create unique index TABLE_OWNER.ID_PK_NEW on
TABLE_OWNER.NEW_TABLE (ID, START_TIME)
local;
alter table TABLE_OWNER.NEW_TABLE add constraint
ID_PK_NEW primary key (SERVICE_LOG_ID, START_TIME)
novalidate;
--#
--# Registrierung des manuell erstellten neuen Indexes
--#
exec DBMS_REDEFINITION.register_dependent_object('TABLE_OWNER',
'SOURCE_TABLE',
'NEW_TABLE',
DBMS_REDEFINITION.cons_index,
'TABLE_OWNER',
'ID_PK',
'ID_PK_NEW');
--#
--# Registrierung des manuell erstellten neuen Constraints
--#
exec DBMS_REDEFINITION.register_dependent_object('TABLE_OWNER',
'SOURCE_TABLE',
'NEW_TABLE',
DBMS_REDEFINITION.cons_constraint,
'TABLE_OWNER',
'ID_PK',
'ID_PK_NEW');