<div>
you need to create an undo (rollback) tablespace <br />
<br />
<br />
for example....<br />
<br />
CREATE UNTO TABLESPCE YOUR_UNDO DATAFILE '/your/path/undo.dbf' SIZE 300M AUTOEXEND ON NEXT 100M MAXSIZE UNLIMITED<br />
ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON;<br />
<br />
<br />
adjust path, sizing and other parameters as appropriate for your instance
</div>


you need to create an undo (rollback) tablespace


for example....

CREATE UNTO TABLESPCE YOUR_UNDO DATAFILE '/your/path/undo.dbf' SIZE 300M AUTOEXEND ON NEXT 100M MAXSIZE UNLIMITED
ONLINE RETENTION NOGUARANTEE BLOCKSIZE 8K FLASHBACK ON;


adjust path, sizing and other parameters as appropriate for your instance

<div>
Before you just create a new undo tablespace:<br />
<br />
What happened since the last time the database 'worked'?
</div>


Before you just create a new undo tablespace:

What happened since the last time the database 'worked'?

<div>
<div class="content wysiwyg-content">
Enter user-name: ap@IAQ<br />
Enter password:<br />
ERROR:<br />
ORA-00604: error occurred at recursive SQL level 1<br />
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'<br />
ORA-06512: at line 6<br />
<br />
<br />
They are getting this error<br />
<br />
please provide me with some solution.
</div>
</div>


Enter user-name: ap@IAQ
Enter password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-01552: cannot use system rollback segment for non-system tablespace 'TOOLS'
ORA-06512: at line 6


They are getting this error

please provide me with some solution.

users can not login into the database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.