Show TOC

Function documentationSpecial Export and Import Functions with BRSPACE Locate this document in the navigation structure

 

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

You can use the exports and imports listed below with Oracle Data ump, except the export to NULL device.

Features

Note Note

In the first three points below, it is particularly important to use -t "*" because this makes sure that not only tables and their dependent objects are exported

End of the note.

  • Export all objects of the database owner

    brspace -f tbexport -o <owner>[,<owner>,...] -t "*"

  • Export all objects of all SAP database owners

    brspace -f tbexport -o all -t "*"

  • Full database export

    brspace -f tbexport -o full -t "*"

  • Export to NULL device (not for use with Data Pump)

    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.

    Caution Caution

    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 even use 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 export tool to fail.

    End of the caution.

  • 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 about import, see BRSPACE -f tbimport.