How to get all tables without schema?  
Author Message
burlaka





PostPosted: 2006-4-28 19:53:00 Top

java-programmer, 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