Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3898 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: Tried to use the system rollback segment for
operations involving non-system tablespace. If this is a
clone database then this will happen when attempting any
data modification outside of the system tablespace. Only the
system rollback segment can be online in a clone database.
Action: Create one or more private/public segment(s),
shutdown and then startup again. May need to modify the
INIT.ORA parameter rollback_segments to acquire private
rollback segment. If this is a clone database being used for
tablspace point in time recovery then this operation is not
allowed. If the non-system tablespace has AUTO segment space
management, then create an undo tablespace.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 0 No |
TNS-00263: Navigator: Request Failed
PLS-00303: qualifier 'string' must be declared
ORA-02234: changes to this table are already logged
DRG-11512: bad syntax for thesaurus load file at line string
ORA-30157: An invalid argument was given to operating system call
ORA-27003: cannot open file on device allocated with NOIO option
ORA-25220: enqueue failed, signature not specified for a non-repudiable queue
DRG-11838: Proxy Reauthentication Required
RMAN-08535: channel string: looking for autobackup on day: string
NID-00350: string (number) string
ORA-19703: device command string exceeds maximum length of string
ORA-04004: MINVALUE must be less than MAXVALUE
Oracle Errors 
