The procedure for dumping user table contents is similar to the procedures for dumping table contents and sequence values.

To dump user table contents:

  1. Access the appropriate Data tool (the Data Administration tool if you are using a graphical interface or the Data Dictionary if you are using a character interface).
  2. Make sure you are using the database from which you want to dump the table data.
  3. Choose Admin > Dump Data and Definitions > User Table Contents. The Data tool prompts you for the file to write the user file contents to. The default filename is _user.d.
  4. Specify the filename or accept the default. After dumping the user file contents to the specified file, the Data tool displays a status message and prompts you to continue.
  5. Choose OK to return to the Data Administration or Data Dictionary main window.