Backing Up the S_LST_OF_VAL Table on UNIX

This task is a step in Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table on UNIX. You back up your original S_LST_OF_VAL table before you begin deleting obsolete or unshipped languages. You can later import languages from this data file.

To back up the S_LST_OF_VAL table on UNIX

  1. In Siebel Tools, back up the original S_LST_OF_VAL table.

  2. On the Siebel Server computer, navigate to the SIEBSRVR_ROOT\bin directory.

  3. From this directory, execute a command like the following to run the Siebel dataexp utility (replacing $ tokens with actual values that represent the environment):

    dataexp /u $UserName /p $Password /c "$ODBCDataSource" /d $SiebelTableOwner /f 
    $DataFileToExport.dat /l $LogFile.log
    

    The utility connects to the database, and displays the following prompt:

    Connecting to the database...
    Connected.
    Exporting Tables
    Enter table name: 
    
  4. Type S_LST_OF_VAL, and hit Enter.

    When the action is completed, the utility will display the following message:

    Exporting Tables
    Enter table name: S_LST_OF_VAL
    Reading tables matching "S_LST_OF_VAL" ...
    Exporting table S_LST_OF_VAL ... exported 30102 rows
    Enter table name:
    
  5. Check the log file for errors, to verify that the data file was created.