Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What tables are in a datafile

587671Jan 21 2008 — edited Jan 21 2008
Is there a sys table that will show me what oracle tables are in a particular data file .dbf

** An example **

there is a data file called /oracledata/data/data_large06.dbf, I was to see what tables are in large06.dbf
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2008
Added on Jan 21 2008
9 comments
3,721 views