#48 Can't see Table with $ symbol

[Anonymous]

I've launched SchemaSpy on an Oracle DB 10.2, with a schema that contains system-table with $ symbol in name, such as WWSEC_PERSON$... I can see the view WWSEC_PERSON build on table WWSEC_PERSON$ but not the table itself!
I've make a try with -i flag but nothing change... I can see the table... Can you help me?

[John Currier]

Logged In: YES
user_id=1264584
Originator: NO

Oracle 10g introduced "flashback" tables that caused SchemaSpy to choke on their bizarre illegal names. The solution that I put in place was to ignore any tables that contain a $ symbol in their name. That's reasonable for 99.9% of the users, but...

The only reasonable option that I can think of is to add another command-line flag that says to include tables with $'s in them.

Any ideas on what that flag should be?

John

[John Currier]

Closing bug due to lack of response. Please log on before submitting bug reports!

[SourceForge Robot]

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

[Anonymous]

Can we re-open this bug? I'm experiencing the same problem with version 5.0.0.

Unfortunately we don't have control over the table names (which all contain $'s). Therefore SchemaSpy skips over them.

Suggested command-lines? Not sure... -alltables : /?

If I don't hear anything from this report, I can create a new bug report.

[Anonymous]

I hadn't heard anything from this bug request, so I recompiled with the code removed from src\..\net.sourceforge.schemaspy.model\Database.java.

It's picking up all tables now, which works as expected!

A switch would be beneficial...

[Sascha Szott]

Hi John,

are there any plans to fix this "bug". What about a CLI switch to enable the processing of tables with a $ character in their name?