How to get all tables without schema?



Hi all!

How to get all tables without schema from DatabaseMetaData on Oracle 9?
I have tables:

a,
b,
mdsys.a,
mdsys.b

How to get "a" and "b" tables only?

I try to get it the follow code, but this code return empty resultset.

String tableTypes[] = { "TABLE" };
ResultSet rs = databaseMetaData.getTables(null, "MDSYS", "%",
tableTypes);

Where my mistake?

thanks

.



Relevant Pages

  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >Access / Oracle problem, ... >referring to the proper server / SID of every branch. ... >table, when i try to query the second table under another schema, ODBC ... >shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)
  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >>Access / Oracle problem, ... >>referring to the proper server / SID of every branch. ... >>table, when i try to query the second table under another schema, ODBC ... >>shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)
  • Re: Synchronization Wizard weirdness
    ... Using the Oracle Enterprise Manager and Oracle Change Manager packages, ... :> I have a Test Schema in the same database as the Main schema and need to ... Wizard between the Main schema and Test schema -- obviously returned the full ...
    (comp.databases.oracle.tools)
  • App schema with SYS privileges?
    ... management to figure out how the Oracle database ought to be setup! ... The said app requires system privileges because, for each new project, ... It also requests for the Oracle username and ... Is there a way of creating a schema for the application with privileges ...
    (comp.databases.oracle.server)
  • linkserver error
    ... I created a job that uses a linkserver to Oracle db for the past year. ... It ran fine until a few days ago when Oracle db schema changed. ... OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. ... 130 at compile time and 5 at run time]. ...
    (microsoft.public.sqlserver.programming)