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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dba_segments

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

Previous Topic: ASM ON AIX
Next Topic: Create a copy of an existing oracle database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 20:57:49 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.