What are the challenges you face when working across database platforms? Take the survey
Options

Oracle 12c Identity Columns Are Not Scripted using v5.3.0.2255

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)
);
Tagged:

Answers

Sign In or Register to comment.