Home » RDBMS Server » Backup & Recovery » ORA-01655 on CREATE USER (splitted from RMAN backup error)
ORA-01655 on CREATE USER (splitted from RMAN backup error) [message #573171] Sat, 22 December 2012 21:21 Go to next message
Messages: 1
Registered: December 2012
Location: Dhaka
Junior Member
I created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:

SQL> create user rman identified by rman default tablespace data
temporary tablespace temp

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace

OS:Windows XP
Oracle 10g

Thanks & Regards

[Updated on: Sun, 23 December 2012 01:35] by Moderator

Report message to a moderator

Re: RMAN backup error [message #573172 is a reply to message #573171] Sat, 22 December 2012 21:27 Go to previous messageGo to next message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:


01655, 00000, "unable to extend cluster %s.%s by %s in tablespace %s"
// *Cause:  Failed to allocate an extent of the required number of blocks for
//          a cluster segment in tablespace indicated.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//          files to the tablespace indicated.
Re: RMAN backup error [message #573179 is a reply to message #573171] Sun, 23 December 2012 01:34 Go to previous message
Michel Cadot
Messages: 67954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, do no hijack another topic with your not related question.
Create a new topic.

Previous Topic: running RMAN commands in RUN file to duplicate a database
Next Topic: what are the minimum files which are required to open the db ?
Goto Forum:

Current Time: Tue Sep 28 02:19:58 CDT 2021