Skip to Main Content
Forums

Oracle Database Discussions

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!

Partitioned table Constraint Enable

User_H7I9VMar 7 2012 — edited Apr 25 2012
Hi All,
I have two table t1 & t2 with pk & fk relation. Both are partitioned tables.t1 is parent and t2 is childe table.t2 having more than 600 milions records.Contraints for table t2 is at present in disable state.I am trying to enable the foreign key reference constraint with syntax

ALTER TABLE T2 ENABLE CONSTRAINT CONSTRAINT_NAME;

but It took more than 48 hrs and at last i got a error

ORA-20099: ORA-01555: snapshot too old: rollback segment number 3 with name


How can i enable the t2 table constraints ..Is there any other way.


Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2012
Added on Mar 7 2012
#general-database-discussions
15 comments
1,947 views