Hi Juan,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you can't get TableMappings to work in
your app. If there is any misunderstanding, please feel free to let me know.

Thanks for posting your code here. Based on the code you have provided, I
can see that the source table name is incorrect which make the Fill throws
exception. When filling, we have to fill to the source table and then
TableMappings will map it to the destination table.

Also the source column name and destination column name has to be swapped.

Here I made some changes to your code, and it works fine on my machine.

    DataTable table = new DataTable( "SYSTEM.Usernames");
    table.Columns.Add( "S1", typeof(decimal) );
    OracleCommand cmd = new OracleCommand();
    cmd.Connection = this.oracleConnection1;
    cmd.CommandType = CommandType.Text;
    cmd.CommandText = "SELECT SuperUserFlag FROM SYSTEM.Usernames WHERE
Username = 'JuanDent'";
    OracleDataAdapter da = new OracleDataAdapter( cmd );
    DataSet ds = new DataSet( "Temp ds");
    ds.Tables.Add( table );

    DataTableMapping map = da.TableMappings.Add( "Table", table.TableName );
    map.ColumnMappings.Add( "SuperUserFlag", "S1" );

               ds.EnforceConstraints = false;
    da.MissingSchemaAction = MissingSchemaAction.Error;
    try
    {
            da.Fill( ds, 0, 200, "Table");
    }
    catch( Exception ex )
    {
             MessageBox.Show( ex.Message, ex.Source);
    }

HTH.

Kevin Yu