OraFAQ Forum: Backup & Recovery » ORA-01655 on CREATE USER (splitted from RMAN backup error)

Home » RDBMS Server » Backup & Recovery » ORA-01655 on CREATE USER (splitted from RMAN backup error)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01655 on CREATE USER (splitted from RMAN backup error) [message #573171]

Sat, 22 December 2012 21:21

csemar
Messages: 1
Registered: December 2012
Location: Dhaka

Junior Member

Hi
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
Md.Anis

[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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

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.

Report message to a moderator

Re: RMAN backup error [message #573179 is a reply to message #573171]

Sun, 23 December 2012 01:34

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition, do no hijack another topic with your not related question.
Create a new topic.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 05:55:28 CST 2024