This illustration shows that the inst1.example.com
database and the inst2.example.com
database share a computer file system. The inst1.example.com
database contains two tablespaces: sales_tbs1
and sales_tbs2
. The illustration shows a tablespace repository with two versions of this tablespace set: v_q1fy2005
and v_q2fy2005
. Other versions can also be added to the tablespace repository. The illustration also shows the directory objects that store the data files, export dump file, and export log file in each version. The q1fy2005
directory object stores the files for version v_q1fy2005
, and the q2fy2005
directory object stores the files for version v_q2fy2005
.
When a version of the tablespace set is attached to the inst2.example.com
database, the data files and export dump file in the version are copied to a different directory object. The illustration shows the data files and export dump file in the q1fy2005
directory object being copied to the q1fy2005_r
directory object during attach. After the tablespace set is attached, the inst2.example.com
database contains the sales_tbs1
and sales_tbs2
tablespaces. Also, an import log file generated during the attach is added to the q1fy2005_r
directory object.