1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials


Steps to find the physical location of a table in a database


Steps to find the physical location of a table in a database
Tables are loical data structures in an Oracle database. They are formed of rows and columns that are physically laid out of OS files formatted on disks.

Oracle provides set of data dictionary views to identif the physical location of database objects like table in a database.(OS file system).

Some most commonly used views are:

1) dba_extents
2) dba_tablespaces
3) v$datafile

To locate a table in a database - extents,blocks that comprise the table issue the following commands.

1) Find the extents,blocks,bytes allocated to the database object (table) by issuing the following query:
SQL> select tablespace_name,extent_id,file_id,block_id,bytes from dba_extents where owner='SYS' and segment_name='table-name';

Note: Segment name is the name of the database object to be located.

2) Find the datafile to which the extent belongs using file_id.
SQL> select name from v$datafile where file#=&file_id;

3) To identify the point in the tablespace at which the extent begins issue the following command:

SQL> select block_size * &block_id from dba_tablespaces where tablespace_name='&tablespace_name';

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy