Teradata to Oracle migration

Database

Teradata to Oracle migration

Hi,

I'm new to Teradata,working in Teradata to Oracle migration project, converting Teradata DDL to Oracle.

For UNIQUE PRIMARY INDEX ( TRSY_ID,TRSY_STM,TAX_ID ): converted like below

TRSY_ID as Primary key , TRSY_STM as not null Unique , TAX_ID as not null Unique.

How to convert the below 2 concepts into oracle:

1. PRIMARY INDEX ( TRSY_STM,TRSY_ID,TAX_ID );

2. SPNS_ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY

           (START WITH 1 

            INCREMENT BY 1 

            MINVALUE 1 

            MAXVALUE 999999999999999 

            NO CYCLE)

Any of your help is appreciated and also please correct me if i'm wrong...

-Thanks

 Sakthi

Tags (1)