ODS Secondary Index - Data volume benchmarks?
When creating secondary index on ODS, are there any benchmarks for limits on data volumes? We have ODS in Production with 275 million records and no secondary indexes.
When transporting revised ODS definition to Production with secondary indexes defined, it runs for hours before failing. (Our secondary index contains only two objects)
Receive error "> ORA-30036: unable to extend segment by in undo tablespace" from system log.
Any help or thoughts appreciated.