The TAR archive includes a set of SQL, DDL, and administrator scripts. The scripts contain information on the data and structure export. You use the scripts to import the data in the target system. The utility generates the scripts based on the command arguments that you specify.
The TAR archive file includes the following files:
idvmeta_sctlist_target.txt
Text file that includes a list of all required data files for the target system. When you import the data in the target, the ssadbcopy utility validates that all of the data files in the text file exist on the target.
idvmeta.sql
SQL script that creates the database on the target system if the database does not already exist.
idvmeta.ddl
DDL script that contains the DDL structure of the data that you want to extract. When you import the data, the script replicates the source structure on the target. The script creates the schemas, domains, and tables on the target system.
idvmeta_regtable.adm
Data Vault administrator script that registers tables in the Data Vault repository on the target system.
idvmeta_regsct.adm
Data Vault administrator script that registers data files in the Data Vault repository on the target system. To register the data files, the script uses the target data file location that you provide in the ssadbcopy command.
idvmeta_unregtable.adm
Data Vault administrator script that unregisters tables on the target system. The utility uses the script if you import data in drop and create mode.
idvmeta_cleanup.sql
DDL script that drops the schema, domains, and table structure on the target system. The utility uses the script if you import data in drop and create mode.
You can find the TAR archive file in the following location: