Exporting Tables with BR*Tools

You can use BR*Tools for Oracle to export tables to an operating system file.

Procedure

1. Start the procedure using BRGUI or BRTOOLS, or from the command line:

   • BRGUI or BRTOOLS:

     1. 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.

     2. Set the required options:

        Menu Entry	Equivalent BRSPACE Command Option
        BRSPACE profile (profile)	-p|-profile
        Database user/password (user)	-u|-user
        Export utility (utility)	-f tbexport -l|-utility
        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
        Extended output (output)	-o|-output
        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.

        Note

        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). But these entries are optional.

        You can also specify the dump directory using the parameter exp_dump_dir in the initialization profile init<DBSID>.sap, but the entry you make on the screen overwrites the profile parameter.

        You can also specify a list of tables to be processed with exp_table in the initialization profile init<DBSID>.sap.

     3. Choose Continue.

        BRGUI or BRTOOLS prompts you to start BRSPACE.

     4. 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.

2. If you have already entered the table names, continue with step 5 (quick mode).

   Note

   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.

3. 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
   Used [KB]	Space used by the table (HWM - high-water mark)
   Data [KB:%]	Amount of data in the table: percentage of used space

4. Select a table or multiple tables.

   Example

   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.

5. Set the required options:

   Menu Entry	Meaning
   Export utility (utility) - display only	Oracle export utility to be used: EXP or EXPDP
   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

6. 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 (only for EXP)
   Export buffer size in KB (buffer)	-f tbexport -b|-buffer (only for EXP)
   Compress table extents/data (compress)	-f tbexport -m|-compress
   Consistent export (consistent)	-f tbexport -n|-consistent
   Parallel degree (parallel)	-f tbexport -p|-parallel (only for EXPDP)
   Max. size of dump file in MB (filesize)	-f tbexport -z|-filesize
   Force table export (force)	-f tbexport -f|-force
   EXP/EXPDP command (command)	The EXP/EXPDP command that is to be executed using the current settings. For more information, see your Oracle documentation.

7. To start processing with the selected options, choose Continue.

Check the results in the BRSPACE logs.

The summary log space<DBSID>.log displays the return code.

• The detail log s<encoded timestamp>.tbe displays the details.

For more information on how to view the logs with BR*Tools, see Showing Profiles and Logs with BR*Tools.

These files are created during the export:

• The export dump file, expdat.dmp, is created in subdirectory <encoded timestamp>.edd of the dump directory.

• The parameter file parfile.exp is created in subdirectory <encoded timestamp> of the directory $SAPDATA_HOME/sapreorg. It contains the parameters for the Oracle export tool, EXP/EXPDP.

Special Export and Import Functions with BRSPACE