Home » RDBMS Server » Server Administration » How to which object residing in which datafile in the Tablespace
How to which object residing in which datafile in the Tablespace [message #497596] Sun, 06 March 2011 06:42 Go to next message
sivakumarocp
Messages: 6
Registered: October 2009
Junior Member
Hi,

I have create one table emp under scott schema, and this schemas default tablespace is USERS and this tablespace has 3 datafiles.

Now how do I identify the object EMP is residing on which datafile in USERS tablespace?

I have searched this query on google but I couldn't get. please some one give query for this issue.


Regards,
Sivakumar

Report message to a moderator

Re: How to which object residing in which datafile in the Tablespace [message #497597 is a reply to message #497596] Sun, 06 March 2011 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I have searched this query on google but I couldn't get.

I have posted the query not so far than these a couple of days before, search for (or build the query by yourself with) "dba_extents" and "dba_data_files".

Regards
Michel

Report message to a moderator

Re: How to which object residing in which datafile in the Tablespace [message #497602 is a reply to message #497597] Sun, 06 March 2011 07:05 Go to previous message
sivakumarocp
Messages: 6
Registered: October 2009
Junior Member
thanks for your quick response Michel.

Report message to a moderator

Previous Topic: DEFAULT COUNT OF Oracle 11g Database
Next Topic: Jan PSU on 11gR2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 09:04:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.