Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-32794 in Oracle 12c using identity columns #1049

Closed
ringerl opened this issue Jul 8, 2015 · 5 comments
Closed

ORA-32794 in Oracle 12c using identity columns #1049

ringerl opened this issue Jul 8, 2015 · 5 comments

Comments

@ringerl
Copy link

@ringerl ringerl commented Jul 8, 2015

"flyway clean" can not clean a schema with identity columns, because the auto generated sequences can not be deleted. These must be purged from the recycle bin:

CREATE TABLE test
(
   test_id NUMBER GENERATED BY DEFAULT AS IDENTITY
)
@axelfontaine axelfontaine added this to the Flyway 4.0 milestone Jul 9, 2015
@ringerl ringerl changed the title ORA-32794 in Oracle 12c using idenity columns ORA-32794 in Oracle 12c using identity columns Jul 12, 2015
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Oct 28, 2015
@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Oct 28, 2015

This should be fixed now, unfortunately I don't have access to an Oracle 12 installation at this time. Could you build the latest sources of Flyway-core (it's easy with -DskipTests) and confirm that it is indeed working for you?

Cheers
Axel

@0x6e6562
Copy link

@0x6e6562 0x6e6562 commented Dec 3, 2015

I can confirm that this works with a 12.1.0.2.0 installation. I generated the command line utility by building b18394c using the following profile:

$ mvn install -P-InstallableDBTest -P-CommercialDBTest -DskipTests=true -P-CommandlinePlatformAssemblies

I also commented out the modules from the parent POM that caused the build to fail that were not required:

<modules>
    <module>flyway-core</module>
    <!--module>flyway-gradle-plugin</module>
    <module>flyway-gradle-plugin-largetest</module>
    <module>flyway-maven-plugin</module>
    <module>flyway-maven-plugin-largetest</module>
    <module>flyway-sample</module>
    <module>flyway-sample-webapp</module>
    <module>flyway-sample-osgi</module>
    <module>flyway-sample-osgi-fragment</module>
    <module>flyway-osgi-largetest</module-->
    <module>flyway-commandline</module>
    <!--module>flyway-commandline-largetest</module>
    <module>flyway-ant</module>
    <module>flyway-ant-largetest</module>
    <module>flyway-sbt</module>
    <module>flyway-sbt-largetest</module-->
</modules>

Is there any chance that this patch might get back ported to the 3.2.x series?

@davidkarlsen
Copy link

@davidkarlsen davidkarlsen commented Dec 9, 2015

@axelfontaine Any chance you could release - we really need this one. Additionally do you think it's a good idea to push out snapshots for the .travis.yml - so fresh builds will be available? In the mean time I can push one to our own private repo.

@gooeywizard
Copy link

@gooeywizard gooeywizard commented May 24, 2019

Was this ever put into a release? I'm using version 5.1.4, but I'm still seeing this same error when I run clean.
" ORA-32794: cannot drop a system-generated sequence"

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented May 24, 2019

@gooeywizard Yes and it works flawlessly with the latest code. If you are still seeing an error, please try the latest code, including 6.0.0-beta and if it persists, then open a new issue with clear steps how to reproduce.

@flyway flyway locked as resolved and limited conversation to collaborators May 24, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
5 participants
You can’t perform that action at this time.