Siebel Database Upgrade Guide > Upgrading the Siebel Database > Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table Under Windows >

Backing Up the S_LST_OF_VAL Table Under Windows


This task is a step in Process of Deleting Unshipped Languages from the S_LST_OF_VAL Table Under Windows. You back up your original S_LST_OF_VAL table before you begin deleting obsolete or unshipped languages.

To back up the S_LST_OF_VAL table under Windows

  1. In Siebel Tools, backup the original S_LST_OF_VAL table.
  2. From the Windows command prompt, navigate to ..\siebsrvr\bin directory.
  3. From this directory, execute the following command to run 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. Close the command window, and check the log file for errors, and verify that the data file was created.
Siebel Database Upgrade Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.