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

ORA-01646: tablespace 'string' is not read only - cannot make read write

1 Answers  


TNS-00281: Connection Manager: Forced Log output

1 Answers  


TNS-00243: Connection Manager: Tracing is now OFF

1 Answers  


ORA-38102: Invalid column in the INSERT WHERE Clause: string

1 Answers  


ORA-01511: error in renaming log/data files

1 Answers  






ORA-16631: Operation requires shutdown of database/instance "string"

1 Answers  


ORA-13706: Invalid value "string" specified for parameter "string" in "string" analysis mode.

1 Answers  


ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


ORA-30655: cannot select FOR UPDATE from external organized table

1 Answers  


SQL*Loader-00100: Syntax error on command-line

1 Answers  


TNS-12525: TNS:listener has not received client's request in time allowed

1 Answers  


ORA-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

1 Answers  


Categories