Method 2: Database reconfiguration with export
With this method, the table is converted in these steps:
- The table data is exported
to a temporary file. The name of this file is
R.<table name><company
number>
, for example,
R.tfgld106590
. - Indexes that must be changed or dropped are dropped.
- The table is converted by
issuing multiple
SQL ALTER TABLE
commands to the database. - Indexes that must be changed or created are created.
After successful completion, the temporary file will be deleted. The temporary file is used by bdbreconfig to restore the original table when reconfiguration fails.