Options
Oracle 12c Identity Columns Are Not Scripted using v5.3.0.2255
DEVilish
Posts: 4 New member
I created a test table for 12c that has an identity column using GENERATED BY DEFAULT AS IDENTITY. When I use Source Control for Oracle to script out the tables, all of them come through as just a number without the identity information. Since this is a development database, I am logged in as an administrator. I thought support for identity columns was added in v4. Can someone help?
Table script:
CREATE TABLE REDGATE.SCO_TEST( SCO_TEST_ID NUMBER GENERATED BY DEFAULT AS IDENTITY, PROPERTY_NAME VARCHAR2(20) NOT NULL,
PROPERTY_TYPE VARCHAR2(50) NOT NULL,
PROPERTY_VALUE VARCHAR2(100),);
Script preview from Source Control for Oracle:
CREATE TABLE redgate.sco_test (
sco_test_id NUMBER NOT NULL,
property_name varchar2(20) NOT NULL,
property_type varchar2(50) NOT NULL,
property_value varchar2(100)
);
Table script:
CREATE TABLE REDGATE.SCO_TEST( SCO_TEST_ID NUMBER GENERATED BY DEFAULT AS IDENTITY, PROPERTY_NAME VARCHAR2(20) NOT NULL,
PROPERTY_TYPE VARCHAR2(50) NOT NULL,
PROPERTY_VALUE VARCHAR2(100),);
Script preview from Source Control for Oracle:
CREATE TABLE redgate.sco_test (
sco_test_id NUMBER NOT NULL,
property_name varchar2(20) NOT NULL,
property_type varchar2(50) NOT NULL,
property_value varchar2(100)
);
Tagged:
Answers
Here are the things I've tried several times and always got the same result:
- drop and recreate the table
- alter the column to generate an updated script
- delete and recreate the project
I saved the changes in the tool but never committed them to source control because the output script is wrong.
I have attached screenshots of the various project configuration and tool version information.
Update: I am using the 32-bit version of the tool as I have the 32-bit version of Oracle 12c installed locally.
Thanks,
Thanks for all the help!