Does SCT support converting Oracle View to Redshift View?

Hello there

Yes,There are precautions that you need to take into consideration before migration to Redshift view [1].

you can convert Oracle view to Redshift view by using Schema conversion tool ,you can convert several relational OLTP schemas, or data warehouse schemas. Such as Amazon Relational Database Service (Amazon RDS) MySQL, MariaDB, Oracle, SQL Server, PostgreSQL DB, an Amazon Aurora DB cluster, or an Amazon Redshift cluster.

[1] Migrating LOBs to Amazon Redshift - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/agents.dw.html#agents.LOBs

Learn more About:

Schema Conversion Tool - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html

Migrating your Data to Amazon Redshift - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Converting.html#CHAP_Converting.MigrationRules