Q
Problem solve Get help with specific problems with your technologies, process and projects.

Which datafile contains my table?

How to know which datafile contains my table?

Please help me -- I am in trouble. I have two datafiles in one tablespace; with the help of dba_tablespaces I came to know about my stored table, but how to find out the table from these two datafiles? Is there any way to know which datafile contains my table? Thanks in advance.
On my Web site, I have a script called ts_map.sql which shows you each extent in each datafile of your tablespace. You can find this in the Scripts section and it should help you answer your question.

Dig Deeper on Oracle database backup and recovery

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close