Oracle Schema Provider using System.Data.OracleClient

        <add key="ExtendedPropertiesTableOwner" value="SYSTEM" />

                Setting this to true creates the table in the schema specified by the 'ExtendedPropertiesTableOwner'

                the column schema information. Allowing this can result in a change in the state of the database due to

public TableKeySchema[] GetTableKeys(string connectionString, TableSchema table)
        {
            ArrayList tableSchemaList = new ArrayList();

            using (OracleConnection conn = new OracleConnection(connectionString))
            {
                // Open a connection
                conn.Open();

                string sql = string.Format( 
                    @"select 
                    cols.constraint_name, 
                    cols.column_name, 
                    cols.position, 
                    cons.table_name,
                    r_cons.table_name related_table_name, 
                    r_cols.column_name related_column_name 
                from
                    all_constraints     cons,
                    all_cons_columns    cols,
                    all_constraints     r_cons,
                    all_cons_columns    r_cols
                where cons.OWNER = '{0}'
                  and (cons.table_name = '{1}' or r_cons.table_name = '{1}')
                  and cons.constraint_type='R'
                  and cols.owner = cons.owner
                  and cols.table_name = cons.table_name   
                  and cols.constraint_name = cons.constraint_name 
                  and r_cols.owner = cons.r_owner 
                  and r_cols.constraint_name = cons.r_constraint_name 
                  and r_cons.owner = r_cols.owner 
                  and r_cons.table_name = r_cols.table_name 
                  and r_cons.constraint_name = r_cols.constraint_name 
                order by cons.constraint_name, cols.position",
                    table.Owner,
                    table.Name);

                // GKM - Should we change to OracleDataReader implementation?
                OracleDataAdapter da = new OracleDataAdapter( sql, conn ); 

                DataSet ds = new DataSet();
                using (ds)
                {
                    da.Fill( ds );

                    string lastConstraint = string.Empty;
                    foreach (DataRow row in ds.Tables[0].Rows )
                    {
                        if (lastConstraint!=row["constraint_name"].ToString())
                        {
                            lastConstraint=row["constraint_name"].ToString();

                            string pkTable = row["related_table_name"].ToString();

                            DataRow [] distinctColumns = ds.Tables[0].Select(
                                string.Format("constraint_name = '{0}'", lastConstraint) ); 

                            ArrayList fkMemberCols = new ArrayList();
                            ArrayList pkMemberCols = new ArrayList();

                            foreach( DataRow rdc in distinctColumns)
                            {
                                fkMemberCols.Add( rdc["column_name"].ToString());
                                pkMemberCols.Add( rdc["related_column_name"].ToString());
                            }

                            TableKeySchema tks = null;
                            if (pkTable != table.Name)
                            {
                                tks = new TableKeySchema( 
                                    table.Database,
                                    lastConstraint,
                                    (string[])fkMemberCols.ToArray(typeof(string)),
                                    table.Name,
                                    (string[])pkMemberCols.ToArray(typeof(string)),
                                    pkTable );
                            }
                            else
                            {
                                tks = new TableKeySchema( 
                                    table.Database,
                                    lastConstraint,
                                    (string[])fkMemberCols.ToArray(typeof(string)),
                                    row["table_name"].ToString(),
                                    (string[])pkMemberCols.ToArray(typeof(string)),
                                    pkTable );
                            }
                            // Don't forget to add it to our result
                            tableSchemaList.Add( tks );
                        }
                    }

                }
            }
            
            return (TableKeySchema[]) tableSchemaList.ToArray(typeof(TableKeySchema));
        }