Teradata to Oracle migration

Database
Not applicable

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)