Get Oracle database schema information using ODP.NET

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Does anyone know how to retrieve database schema information (tables,
columns, indexes, etc) using Oracle's ODP.NET provider. It does not support
the OracleConnection.GetSchema() method.

I don't want to have to use another provider such as OleDB or MS's
OracleClient to do this because then I have to support and test multiple
providers.

Tony
 
Hi Tony,

One option is to query database. For example to get all columns of all
tables you would use something like:
select * from sys.ALL_TAB_COLUMNS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AD.Net and Oracle Provider 2
ODP.NET 10.1.3.0 (Beta) Connectivity 2
Using ODP.NET 10 to connect to oracle 9 database 4
Unleash XML support from native Oracle Database driver 1
.NET Framework Data Provider for Oracle does not support batched SQL statements 1
Oracle .NET driver / ODP.NET: how to deal with user defined types? 2
Oracle Data Provider for .NET (ODP.NET) 3
Microsoft Oracle Data Provider 3

Back
Top