exportdb

Purpose

Exports the given database schema.

Location

<Installation_Directory>\InForm\bin\DBOra folder.

Usage

exportdb [connection string] [dump-file-directory-path] [dump-file-name] /prompt [log options]exportdb [connection string] [dump-file-directory-path] [dump-file-name] /accountparams:[paramfile] [log options]

exportdb [connection string] [dump-file-directory-path] [dump-file-name] [version] /prompt [log options]

exportdb [connection string] [dump-file-directory-path] [dump-file-name] [version] /accountparams:[paramfile] [log options]

Where:

Parameter Description
connection-string Database TNS Instance Name
dump-file-directory-path Physical path on database server where the dump should be created. The path must conform to the proper OS path format, and that it should be expected that the path is case-sensitive.
dump-file-name Filename to give the exported dump file. Note that the name must conform to the proper OS format for the database server, and that it should be expected that the name is case-sensitive.
version Target database version. Only specify if the dump will be imported into a lower version database.
paramfile Path to text file containing the list of parameters.
log options Optional parameters for specifying the log file name and/or location.

The log file defaults to being named ExportDB.log.

The log file path defaults to the current working directory.

Options:

  • /LogFile:[filespec]
    • filespec = fully qualified name and path for created log file. If a relative path is given, it is based from the current working folder.
    • Overrides the logfile-path to be the resolved path to the given filespec.
    • Overrides the logfile-name to be the resolved name of the given filespec.
    • Do not specify this if either of the other logging options are specified.
  • /LogFilePath:[pathspec]
    • pathspec = fully qualified path to create the log file in. If a relative path is given, it is based from the current working folder.
    • Overrides the logfile-path to be the resolved path to the given pathspec.
    • Does not change logfile-name.
  • /LogFileName:[filename]
    • filespec = Filename for the log file.
    • Overrides the logfile-name for the log file.
    • Does not change logfile-path.

Command line prompts

If using prompting, you are prompted for the following parameters:

  • Schema Owner User ID—Database trial/schema owner user ID.
  • Database Administrator User Name—Name of the Database Administrator User (for example, pfdbadmin).
  • Database Administrator User Password—Password for the Database Administrator User.

Parameter file contents

When using a parameter file, the path to a text file is given. The format of the parameter file is parameter=value, with each value on a separate line, and no spaces between the parameter name, =, and value.

The parameter file must contain the following parameters

  • Trial_user—Trial/Schema Owner User ID for the study to export.
  • Admin_user—Name of the Oracle InForm Database Administrator (for example, pfadmin)
  • Admin_user_pass—Password for the Oracle InForm Database Administrator User.

Example

exportdb trial1 /backups backup.dmp /prompt
exportdb trial1 /backups backup.dmp /accountparams:myparamfile.txt
exportdb trial1 /backups backup.dmp /prompt
    /logfilepath:c:\exportlogs

Parent topic: Command and script reference