ORA-12039: unable to use local rollback segment "string"
- 1 Answers
- 2452 Views
- I also Faced
- E-Mail Answers
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 |
PROC-00006: User does not have permission to perform a cluster registry operation on this key.
ORA-03230: segment only contains string blocks of unused space above high water mark
ORA-27467: invalid datatype for string value
ORA-31012: Given XPATH expression not supported
ORA-23397: global name "string" does not match database link name "string"
PLS-01703: Cursor name in CLOSE statment must be of length 1
ORA-16176: background dictionary build cannot be running
RMAN-10003: unable to connect to target database
ORA-23458: inappropriate flavor string at string
ORA-30389: the source statement is not compatible with the destination statement
ORA-06932: CMX: error in local name
ORA-27142: could not create new process
Oracle Errors 
