Is there anyway to retrieve sequences in oracle? Its important because Oracle(prior to v12) does not have identity columns. The only way to work around that was to create a sequence and trigger on the table to assign the value from the sequence. But since the schemcrawler autoincrement flag will always come back false, how can that be detected?
Are you using the API, or SchemaCrawler from the command-line. If you are using the command-line, as a short term solution, you can do a custom query on ALL_SEQUENCES. I will look into putting in API support later.
Nope. using the JAVA Api
Ok. I am in the process of putting in support for database sequences. You will see that soon in the next SchemaCrawler version.
I have put in support for sequences in SchemaCrawler 10.10.01. Please use this version. Thanks.
is there a include/exclude rule in schemacrawler.config.properties for sequences ?
I tried following with no scuccess:
I forgot to do that. I will add it in as soon as I can.
Please use SchemaCrawler 10.10.03, and let me know if it works for you.
sorry for the delay, i downloaded 10.10.03 and tried with following commandline:
sc -database=<db> -user=<user> -password=<pwd> -schemas=<schema> -infolevel=maximum -command=details -noinfo -portablenames -sequences=.* -outputfile=<file>
schemacrawler.config.properties includes following lines:
The outputfile still includes following lines:
minimum value 1
maximum value 9999999999999999999999999999
Where is my mistake ?
How can i exclude the "MDRS_298914$" (ORACLE spatial) sequence ?
Let me know if this helps. If it still does not work, I will have to test against my test Oracle database. Thanks.
did not got it to work, since -sequences default to showing no sequences.
What should i enter for the parameter -sequences to not override the configuration ?
I would appreciate a -sequences=true to override the default and enable the configuration file settings.
One more try, please. Can you try this:
I get following error:
"Der Befehl "MDRT_" ist entweder falsch geschrieben oder konnte nicht gefunden werden."
Please use SchemaCrawler 10.10.04, without the -sequences command-line option.
Did this work for you?
i tried with SchemaCrawler 10.10.04 and 10.10.05 but in both cases i got without keywort -sequences=<expr> no sequences at all in the outputfile.
What did you have in your config file? That is, what did you use for schemacrawler.sequence.pattern.include and schemacrawler.sequence.pattern.exclude?
thanks for the hint, i found my mistake - wrong setting of schemacrawler.sequence.pattern.include
after setting to:
everything (include/exclude) is working fine, thanks Sualeh.
Glad that it is working for you, Günter.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.