Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

master.sql file generating "DEFAULT NEXT VALUE..."

TimmmVOct 7 2015 — edited Oct 29 2015

I am currently trying to migrate a MS SQL Server database over to Oracle 12c using the Migration tool built into SQL Developer

After the migration runs there is the below error in the log file that I am struggling to fix:

ALTER TABLE Filters MODIFY (Id DEFAULT NEXT VALUE FOR [compass].[FiltersId])

Error report -

SQL Error: ORA-00907: missing right parenthesis

00907. 00000 - "missing right parenthesis"

*Cause:

*Action:

which occurs on this line of code

ALTER TABLE Filters MODIFY (Id DEFAULT NEXT VALUE FOR [compass].[FiltersId]);

I pasted the above line into an SQLDeveloper worksheet, and it is saying that the error is a syntax error when there is the VALUE clause, but having had a look online I cannot see what syntax is expected for this to work properly

Would anyone be able to help with this please?

Thanks

Tim

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 26 2015

Added on Oct 7 2015

#database-and-application-migrations

12 comments

2,410 views