Home » RDBMS Server » Server Utilities » Problem with Tablespace (Oracle 10g, Windows)
Problem with Tablespace [message #383130] Tue, 27 January 2009 06:10 Go to next message
saiphani723
Messages: 36
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.
Re: Problem with Tablespace [message #383136 is a reply to message #383130] Tue, 27 January 2009 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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
Re: Problem with Tablespace [message #383139 is a reply to message #383136] Tue, 27 January 2009 06:42 Go to previous messageGo to next message
saiphani723
Messages: 36
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.
Re: Problem with Tablespace [message #383176 is a reply to message #383139] Tue, 27 January 2009 09:32 Go to previous message
Mahesh Rajendran
Messages: 10672
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
Previous Topic: flashback limit
Next Topic: Input data file as a parameter in control file of sql loader
Goto Forum:
  


Current Time: Fri Dec 09 03:45:33 CST 2016

Total time taken to generate the page: 0.10894 seconds