Special Export Functions with BRSPACE

Use

You can use BRSPACE –tbexport to export tables and dependent objects, such as indexes, constraints, grants, and so on. With the following special export functions you can also export other “global” objects such as synonyms, views, procedures, and so on.

Features

·        Export all objects of the database owner

brspace –f tbexport –o <owner>[,<owner>,…] –t “*”

It is particularly important to use –t “*” because this makes sure that not only tables and their dependent objects are exported.

·        Export all objects of all SAP database owners

brspace –f tbexport –o all –t “*”

It is particularly important to use –t “*” because this makes sure that not only tables and their dependent objects are exported.

·        Full database export

brspace –f tbexport –o full –t “*”

It is particularly important to use –t “*” because this makes sure that not only tables and their dependent objects are exported.

·        Export to NULL device

UNIX: brspace –f tbexport –u /dev/null

Windows: brspace –f tbexport –u \nul

There is no export dump file created in this case. You can use this type of export to validate the data.

Use option -o (as described above) if you want to check all SAP tables, as in this example:

bspace –c force –f tbexport –o sapr3 –t “*” –u /dev/null

Or you can evenuse the full database export to check the Oracle dictionary:

bspace –c force –f tbexport –o full –t “*” –u /dev/null

This avoids creating a parameter file with several thousand table names, which can cause the EXT tool to fail.

·        Import all objects of the database owner

From the export dumps created in the first three points above, you can import all tables and their dependent objects either with or without global objects:

Ў        Import of tables of the database owner with their data and dependent objects, but without global objects:

brspace -f tbimport -y tables -o <owner>[,<owner>,...] -t "*"

Ў        Import of tables of the database owner with their data and dependent objects together with global objects:

brspace -f tbimport -y tables -o <owner>[,<owner>,...] -t "%"

Ў        Import of the objects of one database owner to another database owner

brspace -f tbimport -y tables -o "<old_owner>,->,<new_owner>" -t "*"
brspace -f tbimport -y tables -o "<old_owner>,->,<new_owner>" -t "%"

For more information on import, see BRSPACE -f tbimport.