Re: in which location our table or data are stored in oracle

pawan.abes_at_gmail.com wrote:
> hi
> sir
> in which location our table or data are stored in oracle
>

Query USER_TABLES or DBA_TABLES and that will show you which tablespace(s) holds the table. From there, query DBA_DATA_FILES to see the file and location on disk of the tablespace's datafiles. If you want to know which exact file(s) and the blocks in that file, then querying DBA_EXTENTS can also help.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown