Home » RDBMS Server » Server Administration » Table in System Tablespace (10.2.0.3 Windows 32 bit)
Table in System Tablespace [message #362517] Tue, 02 December 2008 09:56 Go to next message
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 #362518 is a reply to message #362517] Tue, 02 December 2008 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_segments

Regards
Michel
Re: Table in System Tablespace [message #362662 is a reply to message #362517] Wed, 03 December 2008 11:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
DBA_TABLES lists the owner and the tablespace
Re: Table in System Tablespace [message #362664 is a reply to message #362662] Wed, 03 December 2008 11:33 Go to previous message
Michel Cadot
Messages: 64120
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
Previous Topic: ASM ON AIX
Next Topic: Create a copy of an existing oracle database
Goto Forum:
  


Current Time: Tue Dec 06 16:27:54 CST 2016

Total time taken to generate the page: 0.11658 seconds