ORA-12039: unable to use local rollback segment "string"



ORA-12039: unable to use local rollback segment "string"..

Answer / guest

Cause: A local rollback segment was specified in the CREATE
MATERIALIZED VIEW command, but automatic refresh parameters
were not specified. Therefore a refresh group was not
created to automatically refresh the materialized view and
the local rollback segment can't be registered for future use.

Action: Either supply the automatic refresh parameters so
that a refresh group will be created or do not specify a
local rollback segment.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-10018: error cleaning up channel context

1 Answers  


KUP-04059: found EOF in length portion of VARIABLE record in file string

1 Answers  


PLS-00384: type mismatch found at 'string' in UPDATE's SET clause

1 Answers  


ORA-06546: DDL statement is executed in an illegal context

1 Answers   Oracle,


ORA-09751: pw_attachPorts: server call pws_attach failed.

1 Answers  


ORA-13357: extent type does not contain 2 points

1 Answers  


NNL-01007: VERSION SKEW responses received: number

1 Answers  


RMAN-06554: WARNING: file string is in backup mode

1 Answers  


ORA-31218: DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.

1 Answers  


ORA-26027: unique index string.string partition string initially in unusable state

0 Answers   MeritTrack,


TNS-12650: No common encryption or data integrity algorithm

1 Answers  


ORA-07655: slsprom:$TRNLOG failure

1 Answers  


Categories