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 |
ORA-07486: scg_get_inst: cannot convert(get) instance number lock.
NCR-03018: NCRO: Failed to make RSLV connection
ORA-36274: (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
ORA-15122: ASM file name 'string' contains an invalid file number
ORA-22955: The cardinality parameter is not within the allowed limits
ORA-06547: RETURNING clause must be used with INSERT, UPDATE, or DELETE statements
ORA-12230: TNS:Severe Network error occurred in making this connection
ORA-01295: DB_ID mismatch between dictionary string and logfiles
ORA-09810: Unable to get process ID from connection
ORA-13153: invalid high water mark specified
ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory
ORA-02440: Create as select with referential constraints not allowed