Home » RDBMS Server » Server Administration » unable to allocate MINEXTENTS beyond 1 in tablespace USERS
unable to allocate MINEXTENTS beyond 1 in tablespace USERS [message #62394] Mon, 19 July 2004 22:59 Go to next message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
Hi friends,

I have a problem when i am importing a dump file in my database..
i have two tablespace users and imms and in dump file defualt tablespace is users..
so data is imported to users tablespace only even though i have created user by default tablespace imms.
I have no space in tablespace users and i am unable to add new more space to users tablespace
is there any solution for this problem.. it's very urgent for me..

prob error is : unable to allocate MINEXTENTS beyond 1 in tablespace USERS

thax.
bhavin

Report message to a moderator

Re: unable to allocate MINEXTENTS beyond 1 in tablespace USERS [message #62395 is a reply to message #62394] Mon, 19 July 2004 23:23 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Just revoke UNLIMITED TABLESPACE privelege from that user and try.

Daljit Singh.

Report message to a moderator

Re: unable to allocate MINEXTENTS beyond 1 in tablespace USERS [message #62411 is a reply to message #62395] Tue, 20 July 2004 23:28 Go to previous message
BhavinShah
Messages: 105
Registered: February 2004
Senior Member
hi daljit,

what will happen if i will revoke that prevaligies. can u explain me in details. and what will be the cause of prob..eventhough i have a enough space..

Report message to a moderator

Previous Topic: need to calculate average_row length for table
Next Topic: Hostnaming Method ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 03:46:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.