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!

how to find out a specific record in which datafile?

ArunFeb 5 2013 — edited Feb 5 2013
Hi All,

Database version :11gR2

I am inserting a table a record called 'xx'. and the table is in a tablespace which has lets say 10 datafiles. How to find out the datafile which stores this 'xx' record.

Thank you,
Arun
This post has been answered by LaserSoft on Feb 5 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2013
Added on Feb 5 2013
27 comments
3,597 views