How to get all tables in a schema in Oracle 9i using its JDBC driver? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

How to get all tables in a schema in Oracle 9i using its JDBC driver?

How to get all tables in a schema in Oracle 9i using its JDBC driver?# Java - 爪哇娇娃

f*42007-01-22 08:01

1 楼

I tried DatabaseMetaData.getTables(catalog, schema, "%", new String[]{"TABLE
"}) and got nothing.
I used ResultSetMetaData.getSchemaName(column) and got an empty String.
Anything wrong with the code or Oracle 9i JDBC driver hasn't implemented
those APIs properly?

f*42007-01-22 08:01

2 楼

TABLE
I got it, that was because I didn't specify catalog properly. BTW: I found
out the catalog names using DatabaseMetaData.getSchemas().
But the problem now is, the tables I got are like this
ATSI_CODES
BIN$J5XxEKjaSRfgQAtua5lq1w==$0
BIN$J5XxEKjkSRfgQAtua5lq1w==$0
BIN$J5XxEKjvSRfgQAtua5lq1w==$0
COUNTRY_CODES
ESL_PHASES
EVIDENCE_TYPES
What are those with '$' in them ?
Any nice way to filter them out from the ResultSet?

M*r2007-01-22 08:01

3 楼

They are deleted tables in Oracle recyclebin.

【在 f*******4 的大作中提到】

: TABLE
: I got it, that was because I didn't specify catalog properly. BTW: I found
: out the catalog names using DatabaseMetaData.getSchemas().
: But the problem now is, the tables I got are like this
: ATSI_CODES
: BIN$J5XxEKjaSRfgQAtua5lq1w==$0
: BIN$J5XxEKjkSRfgQAtua5lq1w==$0
: BIN$J5XxEKjvSRfgQAtua5lq1w==$0
: COUNTRY_CODES
: ESL_PHASES