1、获取Oracle某连接下的所有表名 假设数据库连接为conn: public DataTable GetConnectionTables() { DataTable dt = null; try { if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataAdapter da = new OracleDataAdapter("select Table_Name from user_tables", conn); dt = new DataTable(); da.Fill(dt); } catch (Exception ex) { error += "GetConnectionTables:" + ex.Message + "/r/n"; } finally { conn.Close(); } return dt; } 2、获取Oracle某连接下某表空间中的所有表名: public DataTable GetConnectionTables(string tableSpaceName) { DataTable dt = null; try { if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataAdapter da = new OracleDataAdapter("select Table_Name from user_tables where tablespace_name='"+tableSpaceName+"'", conn); dt = new DataTable(); da.Fill(dt); } catch (Exception ex) { error += "GetConnectionTables:" + ex.Message + "/r/n"; } finally { conn.Close(); } return dt; } 3、获取Oracle某连接下的所有视图名 public DataTable GetConnectionViews() { DataTable dt = null; try { if (conn.State == ConnectionState.Closed) { conn.Open(); } OracleDataAdapter da = new OracleDataAdapter("select View_Name from user_views", conn); dt = new DataTable(); da.Fill(dt); } catch (Exception ex) { error += "GetConnectionViews:" + ex.Message + "/r/n"; } finally { conn.Close(); } return dt; }