--#
--# 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');