Exporting Tables with BR*Tools
Use
You can use BR*Tools for Oracle to export tables to an operating system file.
This section describes how you export tables with BR*Tools.
For more information on the approach to table export, see Export/Import.
Do not use this procedure for the transport of database objects between databases.
Do not use this procedure for restore.
Procedure
…
- Start the procedure using BRGUI or BRTOOLS, or from the command line:
¡ BRGUI or BRTOOLS:
- Choose Segment Management ® Export tables.
BRGUI or BRTOOLS displays the menu BRSPACE options for export tables, where you specify the options with which you call BRSPACE.
- Set the required options:
Menu Entry | Equivalent BRSPACE
Command Option |
BRSPACE profile (profile) | -p|-profile |
Database user/password (user) | -u|-user |
Tablespace names (tablespace) | -f tbexport -s|-tablespaces |
Table owner (owner) | -f tbexport -o|-owner |
Table names (table) | -f tbexport -t|-tables |
Export dump directory | -f tbexport -u|-dumpdir |
Confirmation mode (confirm) | -c|-confirm |
Scrolling line count (scroll) | -s|-scroll |
Message language (language) | -l|-language |
BRSPACE command line (command) | This shows you the -BRSPACE -f -tbexport command that is to be executed using the current settings. |
If required, in Table names you can enter the names of multiple tables. You can use wildcards. For more information, see “Selecting Objects“ in Segment Management with BR*Tools.
In Tablespace names and Table owner, you can specify multiple objects but you cannot use wildcards. BRSPACE processes all the tables in the specified tablespace name(s) or all tables belonging to the specified table owner(s).
You can also specify the dump directory using the parameter exp_dump_dir in the initialization profile init.sap, but the entry you make on the screen overwrites the profile parameter.
iii. Choose Continue.
BRGUI or BRTOOLS prompts you to start BRSPACE.
- Choose Continue to start BRSPACE.
¡ Command line:
…
Enter at least the following command:
brspace –f tbexport
You can enter more parameters, including the table names, if required. For more information, see -BRSPACE -f -tbexport.
Whichever way you start the procedure – with BRGUI or BRTOOLS, or from the command line – you can use quick mode if you know the final object names, in this case the table names. For more information, see How to Use BR*Tools.
BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log.
- If you have already entered the table names, continue with step 5 (quick mode).
If you have entered multiple tables, BRSPACE displays as confirmation a List of tables for export. If you have not already made a final selection, you can make a selection from this list.
Continue with step 5 (quick mode).
BRSPACE displays the Export tables main menu.
- Choose Export tables.
BRSPACE displays the table list:
List Entry | Meaning |
Pos. | List sequence number |
Owner | Table owner |
Table | Table name |
Part. | Partitioned |
Rows | Number of rows |
Space [KB] | Space occupied by the table |
Data [KB:%] | Amount of data in the table: percentage of occupied space |
- Select a table or multiple tables.
These examples only apply to input in character mode:
To select the first three tables in the list, enter 1-3.
To select the first and third tables, enter 1,3.
To select the first three tables and the fifth, enter 1-3,5.
To select all tables, select 0.
BRSPACE displays the menu, Main options for export of tables.
- Set the required options:
Menu Entry | Meaning |
Tablespaces for export (tablespaces)
– display only |
The tablespace that you selected above, if any |
Owners for export (owner)
– display only |
The table owner that you selected above, if any |
Export table rows (rows) | -f tbexport -r|-rows |
Export table indexes (indexes) | -f tbexport -i|-indexes |
Export table constraints (constraints) | -f tbexport -c|-constraints |
Export table grants (grants) | -f tbexport -g|-grants |
Export table triggers (triggers) | -f tbexport -t|-triggers |
- When you have set the required options, choose Continue
BRSPACE displays the menu, Additional options for export of tables.
Menu Entry | Meaning |
Use direct path (direct) | -f tbexport -d|-direct |
Export buffer size in KB (buffer) | -f tbexport -b|-buffer |
Compress table extents (compress) | -f tbexport -m|-compress |
Consistent export (consistent) | -f tbexport -n|-consistent |
Max. size of dump file in MB (filesize) | -f tbexport -z|-filesize |
Force table export (force) | -f tbexport -f|-force |
EXP command | The EXP command that is to be executed using the current settings. For more information, see your Oracle documentation. |
- To start processing with the selected options, choose Continue.
Results
Check the results in the BRSPACE logs.
- The summary log space.log displays the return code.
- The detail log s.tbedisplays the details.
For more information on how to view the logs with BR*Tools, see Showing Logs and Profiles with BR*Tools.
Two files are created during the export:
- The export dump file, expdat.dmp, is created in subdirectory .edd of the dump directory.
- The parameter file parfile.expis created in subdirectory of the directory $SAPDATA_HOME/ sapreorg. It contains the parameters for the Oracle export tool, EXP.