SAPDBA Scripts and Files
SAPDBA automatically starts each required script. For more information on a script, refer to the chapter that describes the corresponding function. If an error occurs, you can use the Restart function to resume the reorganization or the export/import. If this attempt also fails, you can start the required scripts manually. See "Starting the Scripts".
SAPDBA stores all the scripts (and also the named pipes in case of compression) in subdirectories of the working directory. This is generally the directory
<ORACLE_HOME>/sapreorg (see exireo_dumpdir) with the corresponding <timestamp> directories, which specify the date and time of the executed operation.The export dump files (possibly compressed) are stored in
<timestamp> subdirectories of the dump directory or on tape (as defined in Export dump destination). The default value for the dump directory is also the directory specified in exireo_dumpdir.If several export dump destinations were defined, there will be a corresponding number of export dump files, export/import shell scripts and parameter files. See "Information in the Export Dump Destination - Script Names".
Some script names change when you use the export/import tools SAPDBA unload/SAPDBA load or SAP unload/SQL*Loader for test purposes. See
SAP unload/load, SQL*Loader.Overview of scripts and files
Name |
Use |
alt<TSP>.sql |
Deletion of index analysis. Only before exporting tables and their data, reorganizing lists of objects and reorganizing tablespaces with or without data files. |
cssvg<DBSID>.sql |
Script for creating constraints, grants, synonyms, sequences, and views. |
con<TSP>.sql |
Script for creating constraints. |
drc<TSP>.sql |
Script used during reorganization of tablespaces that deletes the constraints. |
dro<TSP>.sql |
Script that contains the DROP commands required during a reorganization. |
grants.sql |
Script for defining grants; is only generated during the export of table and index definitions (structure export). |
ind<TSP>.sql |
Script for creating indexes. When an export with data is performed, this script is not used in certain cases. |
inx<TSP>.sql |
SQL script created during a test import. (It is not used in reorganizations). |
nam<TSP>.sql |
Script for temporarily renaming tables during a reorganization. |
rnm<TSP>.sql |
Script for temporarily renaming a table during the a reorganization, with delayed deletion of the data (deferred mode). |
ren<TSP>.sql |
Script containing the necessary rename commands if the data file assignment of a tablespace is changed (move/rename). It can also be used to reset temporary renaming of tables during reorganizations. |
swi<TSP>.sql |
Script used during a reorganization with data files that triggers certain security mechanisms (redo log file switch, backup of the control file). |
tab<TSP>.sql |
Script for creating tables. |
tsp<TSP>.sql |
Script used to create tablespaces during the reorganization of tablespaces with data files. |
exc<TSP>.sh |
Script for compressing (compress) or splitting (R3chop) export dump files. |
exp<TSP>.sh |
ORACLE export of tables and their data. |
exc<TSP>.par |
Parameter file for R3chop |
exp<TSP>.par |
Parameter file for export and import. |
exp<TSP>.dmp |
Export file or named pipe (if you compress data or split it with R/3 chop) that contains tables with data. |
exp<TSP>.dmp.Z |
Compressed export file. |
exp<TSP>.dmp.<m> exp<TSP>.dmp.Z.<m> |
Export dump files can be split into several smaller files <m> with R3chop. |
imc<TSP>.sh |
Script for decompressing or merging (R3chop) split export dump files for the ORACLE import. |
imp<TSP>.sh |
ORACLE import of tables and their data (incl. grants) |
imx<TSP>.sh |
Shellscript for test import (dump file check) |
ldr<TSP>.dmp |
Unloader dump directory |
ldr<TSP>.par |
Parameter file for unload and load |
ldr<TSP>.sh unl<TSP>.sh |
Script for unload or load; cannot be executed as a separate shell script, contains internal information for SAPDBA. |
del<TSP>.sh |
Script containing operating system commands for deleting old files, links, and directories and commands for creating new directories and links in case of a reorganization with data files or a change to the data file assignment of a tablespace. |
The following scripts are not generated when only indexes are involved in an export or reorganization:
exc|exp<TSP>.sh
, imp|imc<TSP>.sh , tab<TSP>.sql , grants.sql , exp<TSP>.dmp , exp<TSP>.dmp.Z , exp<TSP>.par ,Information in the Export Dump Destination - Script Names
Script names:
exc|exp|imp|imc|imx|unl|ldr<TSP>.<ext>All export dump files are saved in the specified directory. If you export to tape, only one export dump file is generated for all the tables to be exported.
Script names:
exc|exp|imp|imc|imx|unl|ldr<TSP>_<n>.<ext>Depending on the degree of parallelism (see
Parallel Export/Import), both cases can be edited either sequentially or in parallel.Starting the Scripts
When a reorganization, export or import process is terminated, you can use the restart functionality of the SAPDBA to repeat the process starting at the corresponding location. You only have to resort to alternative possibilities for starting the individual scripts if such an attempt fails.
If you start the scripts using one of the options specified below, you must adhere to the order in which you call the scripts! Refer to the relevant information in the log written during the corresponding process and in the restart file.
The options for starting the individual scripts described in this section should only be used in case of an emergency.