Entering content frameSyntax documentation sapdba -export Locate the document in its SAP Library structure

Use

You can use this SAPDBA command with the Oracle database to export objects. This command is important for testing tables and indexes for corrupted Oracle blocks. No export dump file is generated.

Prerequisites

A list or a LIKE value can be defined for tablespaces.

A table must always be specified singly by its name.

If there are no further specifications, the export is made to the null device, that is, /dev/null .

You can, however, run a normal export by specifying a target for the export dump file (directory or tape device, specification of tape size, if required). Only the regular SAPDBA export scripts and logs are generated.

Syntax

sapdba -export <tablespace(s)/table>

 

See also:

Export and Import of Database Objects

Leaving content frame