f*******4
发帖数: 345 | 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*******4
发帖数: 345 | 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*****r
发帖数: 1536 | 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
|
s**o
发帖数: 584 | 4 purge 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
|
