View the location of a specified record in a data file in an Oracle table

View the specified record location in an Oracle table
Select rowid,user_id from Sshr.xx_user where user_id=3010586

Select rowID,
Dbms_rowid.rowid_object (ROWID) object_id,

DBMS_ROWID.ROWID_RELATIVE_FNO (ROWID) file_id,

Dbms_rowid.rowid_block_number (ROWID) block_id,

Dbms_rowid.rowid_row_number (ROWID) row_id

From Sshr.xx_user where rowid= ' Aaanemaamaabimzaas ';

To use EXPDP/IMPDP to import a user to change a table space:
Http://blog.itpub.net/10271187/viewspace-1283100/

To delete all tables under a user:
http://blog.itpub.net/7865774/viewspace-612287/

View the location of a specified record in a data file in an Oracle table