Yes,There are precautions that you need to take into consideration before migration to Redshift view .
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.
 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
Setting up refresh schedules for Amazon Redshift materialized viewAccepted Answerasked 2 years ago
Oracle materialized view replication to postgres using DMS CDCasked 2 months ago
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 5 months ago
Redshift User Permission to View Granted Schema Only in Database Explorerasked 2 months ago
Save / backup Athena viewAccepted Answerasked 2 years ago
[Bug] AVG() function does not work in Redshift materialized viewasked a month ago
Does redshift serverless support aqua?asked a month ago
redshift does not create view with no schema binding with recursive cte insideasked 8 months ago
AWS DMS - Data from Oracle EBS database - from Viewasked a month ago
Does SCT support converting Oracle View to Redshift View?asked 4 months ago