ORA-01552: cannot use system rollback segment for non-system tablespace 'xxx'

| Login

You are here: > >

Welcome to the website of FieldIT Limited The business FieldIT was established in 2006, with FieldIT Limited being formed in 2011, securing the future of services and products we have reliably provided to customers for many years. We provide a professional, honest, personnel service to a small customer base both in our local area Buckinghamshire/Oxfordshire and customer as far away as America. Please select from the menu to view the services FieldIT Limited provides. We will support and help advance your business untimely putting you a step ahead of your competitors. We provide and maintain a high quality service we constantly check and prices. Contact Us / Enquiries	ORACLE 10g Problem Description After trying to start a logical standby by using "ALTER DATABASE START LOGICAL STANDBY APPLY" I got the following error: LOGSTDBY status: ORA-01552: cannot use system rollback segment for non-system tablespace 'xxx' Solution To solve the problem I set the undo management to auto and restarted the apply process. ALTER system set undo_management=AUTO scope=spfile; ALTER DATABASE START LOGICAL STANDBY APPLY
Tweets by @FieldITLimited
*Legal Section* Unauthorised Resellers Policy/Notice End User Licence Agreement Email Acceptable Use Policy Privacy Policy IT Security Policy/Procedures Website Terms and Conditions Consultancy, Service and Product T&Cs Email/Online Storage We offer professional, fast, reliable email/secure file storage from a little as £3.99 per month (less with multiple account discount). The email we offer comes with encrypted (https) webmail, celendar, online file storage, out of office and push email for your Blackberry, iPhone, HTC or any other Smartphone. We can set you up with shared mailbox, shared calendar, shared online file storage for an entire company. Click here for more information

FieldIT Limited Registered in England and Wales No: 7585947
Registered Address: Elsinore House, 43 Buckingham Street, Aylesbury, Buckinghamshire, HP20 2NQ

Before; using our web sites (or any other site hosted/provided by FieldIT Limited), actioning any advice given to you by FieldIT Limited (via phone, fax, email), accepting/purchasing any product or service provided by FieldIT Limited you must read and agree the documents in the Legal section at http://www.FieldIT-Limited.com. You should periodically check the http://www.FieldIT-Limited.com website for updates.

ORACLE 10g

Problem Description

Solution