Table in System Tablespace [message #362517] |
Tue, 02 December 2008 09:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
traheja
Messages: 5 Registered: November 2008
|
Junior Member |
|
|
Hi,
I have been given task to find out which application user tables/indexes belongs to system tablespace and move them out of system tablespace. Is there any sql that I can use to find out which tables (besides system) are in system tablespace?
Any help will be appreciated.
Thanks
Tajinder
|
|
|
|
|
Re: Table in System Tablespace [message #362664 is a reply to message #362662] |
Wed, 03 December 2008 11:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.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 |
|
|
Not if the table is partitioned.
dba_segments is the view to query.
tablespace_name in dba_tables is an error of Oracle that leads to this common misleading.
Regards
Michel
|
|
|