OraFAQ Forum: Server Utilities » Problem with Tablespace

Home » RDBMS Server » Server Utilities » Problem with Tablespace (Oracle 10g, Windows)

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

Problem with Tablespace [message #383130]

Tue, 27 January 2009 06:10

saiphani723
Messages: 38
Registered: July 2006
Location: Hyderabad

Member

I am trying to import the database for one of the tablespace i am getting the below error
IMP-00003: ORACLE error 1659 encountered
ORA-01659: unable to allocate MINEXTENTS beyond 31 in tablespace RULES_TS
I tried by altering the tablespace adding one datafile. But after that also i am getting the same problem. Can anybody tell me the solution for this.

Report message to a moderator

Re: Problem with Tablespace [message #383136 is a reply to message #383130]

Tue, 27 January 2009 06:36

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

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

ORA-01659: unable to allocate MINEXTENTS beyond %s in tablespace %s
 *Cause:  Failed to find sufficient contiguous space to allocate MINEXTENTS
          for the segment being created.
 *Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
          tablespace or retry with smaller value for MINEXTENTS, NEXT or
          PCTINCREASE

Regards
Michel

Report message to a moderator

Re: Problem with Tablespace [message #383139 is a reply to message #383136]

Tue, 27 January 2009 06:42

saiphani723
Messages: 38
Registered: July 2006
Location: Hyderabad

Member

Dear Michel,

*Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE
I tried with all these ways. But still i am getting the same problem.

Report message to a moderator

Re: Problem with Tablespace [message #383176 is a reply to message #383139]

Tue, 27 January 2009 09:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

How was export taken?
Did you use compress=y ? If so, take another export with compress=n and try

Report message to a moderator

Previous Topic:	flashback limit
Next Topic:	Input data file as a parameter in control file of sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 16 04:48:15 CDT 2025