469,949 Members | 2,697 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,949 developers. It's quick & easy.

Problem with Oracle

Can anybody help me solve this problem in Oracle:

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

Thanks!
Jul 19 '05 #1
1 3725
r.**********@gmail.com (R.Saminathan) wrote in message news:<c2**************************@posting.google. com>...
Can anybody help me solve this problem in Oracle:

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

Thanks!

You'll need to create a second rollback segment in the tablespace
SYSTEM.
After that you can create other tablespaces, create rollback segments
in those tablespaces and put the extrarollback segment in the
tablespace SYSTEM offline.

BTW: did you look up this error on http://tahiti.oracle.com?
You would have found this explanation there.

--
Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by SerGioGio | last post: by
1 post views Thread by Cliff Cooley | last post: by
4 posts views Thread by BookerW | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.