TimesTen ttmigrate

Usage: ttMigrate [-h | -help | -?]

   or: ttMigrate [-V | -version]

   or: ttMigrate {-a | -c} [-v<level>] [-nf] [-nr] [-fixNaN]

                 [-saveAsCharset <characterSet>]

                 [-relaxedUpgrade | -exactUpgrade]

                 [-convertTypesToOra | -convertTypesToTT]

                 {<DSN> | -connstr <connStr>} <dataFile>

                 [[<objectOwner>.]<objectName>...]

   or: ttMigrate -r  [-C <ckptFreq>] [-v<level>] [-nf] [-nr] [-fixNaN]

                 [-numThreads <n>]

                 [-updateStats | -estimateStats <percent>]

                 [-relaxedUpgrade | -exactUpgrade]

                 [-inline <rule>]

                 [-noCharsetConversion]

                 [-cacheUid <uid> [-cachePwd <pwd>]]

                 [-autorefreshPaused]

                 [-convertTypesToOra | -convertTypesToTT]

                 [-restorePublicPrivs]

                 [-localhost <host>]

                 {<DSN> | -connstr <connStr>} <dataFile>

                 [<objectOwner>.<objectName>...]

   or: ttMigrate {-l | -L | -d | -D} <dataFile>

                 [[<objectOwner>.]<objectName>...]

  -h                  Print this message and exit.

  -help               Same as -h.

  -?                  Same as -h.

  -V                  Print the version of ttMigrate and exit.

  -a                  Select Append mode.

  -c                  Select Create mode.

  -C <ckptFreq>       Specify the checkpoint frequency in megabytes.

                      (Restore mode only).

  -d                  Select Describe mode.

  -D                  Select Long-describe mode.

  -l                  Select List mode.

  -L                  Select Long-list mode.

  -r                  Select Restore mode.

  -nf                 Do not save or restore foreign key information.

  -nr                 Do not save or restore rows when saving or restoring

                      tables.

  -fixNaN             Convert invalid floating-point numbers (NaN/Inf/-Inf)

                      to 0.0 in saved/restored tables.

  -numThreads <n>     Restore database objects in parallel using <n> threads.

  -updateStats        Update statistics on every table as it is restored.

  -estimateStats <p>  Estimate statistics on every table as it is restored

                      by reading <p> percent of each table's rows.

  -exactUpgrade       Preserve existing table structure exactly, with respect

                      to table partitions and dropped columns (tables which

                      have been altered via ALTER TABLE), inline columns, and

                      datatype conversion (-exactUpgrade used to be called

                      -repUpgrade). This option should be used in combination

                      with replication schemes having STORE clause TABLE 

                      DEFINITION CHECKING EXACT. This is the default.

  -relaxedUpgrade     Do not preserve existing table structure. Instead, table

                      partitions (tables which have been altered via ALTER TABLE

                      ... ADD) will be condensed, which speeds up access to

                      these columns; and dropped columns (tables which have been

                      altered via ALTER TABLE ... DROP) will no longer waste

                      space in the database.  NOTE: -relaxedUpgrade must be used

                      if specifying -convertTypesToXXX or -inline with any but

                      the 'preserve' option (-relaxedUpgrade used to be called

                      -noRepUpgrade.) This option must be used in combination

                      with replication schemes having STORE clause TABLE

                      DEFINITION CHECKING RELAXED, or else replication between

                      the original tables and the restored tables may not work

                      properly.

  -inline <rule>      Indicate the rule to be used for converting variable-

                      length columns to INLINE in restore mode. <rule> is

                      one of:

     -inline preserve:     ttMigrate preserves the original INLINE status of

                           each column. This is the default rule, and it must

                           be used if -repUpgrade is used.

     -inline dsDefault:    ttMigrate uses the datastore's default rule for

                           restoring columns as INLINE or NOT INLINE.

     -inline <maxlen>:     ttMigrate restores as INLINE all variable-length

                           columns with length <= <maxlen>, and restores

                           as NOT INLINE all variable-length columns with

                           length > <maxlen>. If <maxlen> is 0 then all

                           variable-length columns are restored as NOT INLINE.

  -saveAsCharset <charset>  Indicate the character set that should be used to

                      store rows in the ttMigrate data file.  By default, rows

                      are stored in the database character set.  Only allowed

                      in combination with -c (create mode) or -a (append mode).

  -noCharsetConversion  Indicate that data in the ttMigrate data file should

                      be interpreted as being in the database character set

                      even if it is tagged as being in a different character

                      set.  Only allowed in combination with -r (restore mode).

  -v<level>           Set the verbosity level. <level> must be between 0

                      and 4 (default is 3).

                      -v0: Print nothing but error and warning messages.

                      -v1: Print names of objects being saved or restored.

                      -v2: Print names of objects (including indexes) being

                           saved or restored.

                      -v3: Print names of objects (including indexes) being

                           saved or restored and print a "progress dot" for

                           every 10,000 rows saved or restored.

                      -v4: Print names of objects (including indexes) being

                           saved or restored and print a "progress dot" for

                           every 10,000 rows saved or restored. Also prints

                           details about privileges as they are restored.

  -convertTypesToOra  Convert all tables using certain (backwards-compatibility)

                      TimesTen types to their corresponding Oracle types. See 

                      documentation for details. This operation allows users to

                      upgrade their databases to use the new Oracle-compatible

                      types with minimum hassle.

                      Must be used in combination with -relaxedUpgrade.

  -convertTypesToTT   Convert all tables using certain Oracle types to their

                      corresponding (backwards-compatibility) TimesTen types.

                      See documentation for details. This operation allows

                      users to reverse the -convertTypesToOra operation.

                      Must be used in combination with -relaxedUpgrade.

  -cacheUid <uid>     Cache admin user id to use when restoring autorefreshed

                      and asynchronous writethrough cache groups.

  -cachePwd <pwd>     Cache admin password to use when restoring autorefreshed

                      and asynchronous writethrough cache groups.

  -autorefreshPaused  Restores autorefresh cache groups with state paused.

                      Otherwise, the state is set to off.

  -restorePublicPrivs Restore access control privileges owned by user PUBLIC.

                      Default behavior is to not restore PUBLIC's privileges.

  -localhost <host>   Name or IP address of the host on which the destination

                      data store for a migrate operation is located.

  <objectOwner>       The owner of the data store object (table, view, index,

                      sequence, etc.) to be saved or restored.  During restore

                      this is a required parameter.

  <objectName>        The name of the data store object to be saved or

                      restored.