Tablespace issue [message #483680] |
Wed, 24 November 2010 03:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hari_bk
Messages: 110 Registered: March 2006
|
Senior Member |
|
|
Hi I am checking in Toad that my tablespace TEST_TS is almost full. To check the tables in this tablespace, I given below commands.
select * from user_tables where tablespace_name='TEST_TS'
select * from user_tab_partitions where tablespace_name='TEST_TS'
Both are displaying no rows.
My doubt is when the tablespace is not used by any tables how It's usage is nearly full? Is there any way to check?
I want to make use of unused tablespace.
Thanks
HK
|
|
|
|
Re: Tablespace issue [message #483694 is a reply to message #483693] |
Wed, 24 November 2010 03:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hari_bk
Messages: 110 Registered: March 2006
|
Senior Member |
|
|
Frank Naude wrote on Wed, 24 November 2010 15:06USER_TABLES will only show your user's tables.
Try DBA_TABLES instead.
Thanks Frank.
I checked DBA_TABLES as well. Yet the query returns no rows.
Also I am creating an index and specified a tablespace name with Create index(Index_tablespace) and I am getting error ORA-01652: unable to extend temp segment by 1024 in tablespace Index_tablespace.
Thanks
HK
|
|
|
|
|
Re: Tablespace issue [message #483702 is a reply to message #483696] |
Wed, 24 November 2010 04:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hari_bk
Messages: 110 Registered: March 2006
|
Senior Member |
|
|
cookiemonster wrote on Wed, 24 November 2010 15:22Could be there are no tables in there but lots of indexes. Try querying dba_extents.
Yes! the tablespace is having only Indexes. Will move these indexes to another tablespace. Thanks a lot.
Now the other question is I can see a particular tablespace usage is only 1%. Yet when i tried to create index in that tablespace, I am getting error ORA-01652: unable to extend temp segment by 1024 in tablespace TEMP_TS.
Thanks
HK
|
|
|
Re: Tablespace issue [message #483703 is a reply to message #483702] |
Wed, 24 November 2010 04:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Enlarge the tablespace.
Do not explain what you have as you don't understand what happens you are not able to clearly, precisely and accurately explain it.
Instead, show it: copy and paste your SQL*Plus session.
Regards
Michel
[Updated on: Wed, 24 November 2010 04:02] Report message to a moderator
|
|
|
Re: Tablespace issue [message #483706 is a reply to message #483703] |
Wed, 24 November 2010 04:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
hari_bk
Messages: 110 Registered: March 2006
|
Senior Member |
|
|
Michel Cadot wrote on Wed, 24 November 2010 15:32Enlarge the tablespace.
Do not explain what you have as you don't understand what happens you are not able to clearly, precisely and accurately explain it.
Instead, show it: copy and paste your SQL*Plus session.
Regards
Michel
ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 1024 in tablespace TEMP_INDEX_TS
But I can see in Toad TEMP_INDEX_TS usage is less than 1%
Thanks
|
|
|
|
|
|
|
|
|