Printable View
I have been asked to create a new database and as usual I have no experience in it whatsoever. The last guy made these scripts that I used to create the database. I am using Oracle 8i. Now when I try to insert data it is giving me this error.
ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
I have no idea what that means
You may need to create additional rollback segment(s).
Here are few recomendations:
http://ora-01552.ora-code.com/
http://www.experts-exchange.com/Data..._21673898.html
http://asktom.oracle.com/pls/ask/f?p...D:895028559085
ps, unlike SQL Server Oracle requires very solid DBA knowellege.
What version of Oracle are you using? Version 10g should be unsing an undo segment in an undo tablspace and you don't need to do anything else. For older version you should create a rollback tablesapce and assign public (or private) rollbacksegments in that tablespace that are available to be used by all users of the DB. The difference between public and private is that private rollbacks must be stated by being placed in the init.ora file and are avabilable to that instance only. A public rollback is stated when an instacne that uses that rollback segment is started and can be shared by more then one instance.