Home » RDBMS Server » Server Administration » ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace (Oracle 9.2.0.8.0 , windows)
ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615040] Thu, 29 May 2014 12:04 Go to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Hi ,

When i try to create Materilized view in test database, i get following error.

Quote:
ERROR at line 62:
ORA-01652: unable to extend temp segment by 16 in tablespace DATA_01

Current tablespace sizes are below.

Quote:
TBS_NAME MEGS_ALLOC MEGS_FREE MEGS_USED PCT_FREE PCT_USED MAX_MEGS_ALLOC MAX_PCT_FREE MAX_PCT_USED
------------------------------ ---------- ---------- ---------- ---------- ---------- -------------- ------------ ------------
DATA_01 16384 2343 14041 14.3 85.7 16384.1 14.3 85.7
MAINTENANCE 256 64 192 24.95 75.05 256.06 24.95 75.05
SYSTEM 2000 707 1294 35.33 64.67 2000 35.32 64.68
DEMO_04 14336 5961 8375 41.58 58.42 14336.09 41.58 58.42
UNDOTBS1 1536 1449 87 94.33 5.67 1536.06 94.33 5.67

Can you tell me how much space should be added to free up space to the tablespace DATA_01 based on the current sizes ?

Regds,
Mohan
Re: ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615043 is a reply to message #615040] Thu, 29 May 2014 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Can you tell me how much space should be added to free up space to the tablespace DATA_01 based on the current sizes ?


The question is meaningless. What you need does not depend on what you have but on what you ask/want.

Once more, use code tags (and not quote ones) and align your columns.

[Updated on: Thu, 29 May 2014 13:11]

Report message to a moderator

Re: ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615070 is a reply to message #615043] Fri, 30 May 2014 00:05 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Michel,

Quote:
The question is meaningless. What you need does not depend on what you have but on what you ask/want.

Does it mean we can add how much ever space to tablespace when it run out of space issue ?

Quote:
Once more, use code tags (and not quote ones) and align your columns.

I am sorry for using quote tags for displaying tablespace sizes.I am aware of using code tags but was running of time and by mistake i used quote tags.

Regds,
Mohan
Re: ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615072 is a reply to message #615070] Fri, 30 May 2014 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I am aware of using code tags but was running of time and by mistake i used quote tags.


Do you say you do not read what you post?

Quote:
Does it mean we can add how much ever space to tablespace when it run out of space issue ?


You can add how much space you want up to the limit detailed in the Database Reference for your version.

Re: ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615095 is a reply to message #615072] Fri, 30 May 2014 03:22 Go to previous messageGo to next message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

Michel,

Can you provide database reference link to me ?

Thanks
Re: ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615096 is a reply to message #615095] Fri, 30 May 2014 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Can you read the toc of the book I mentioned?
There is a limit to acceptable laziness or silliness, don't you think?

Re: ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615099 is a reply to message #615096] Fri, 30 May 2014 04:07 Go to previous message
Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA
Senior Member

nonsense
Previous Topic: How to reset sys user password
Next Topic: Managing DB users
Goto Forum:
  


Current Time: Sun Oct 21 04:53:55 CDT 2018