AWS Schema Tool allows you to export Oracle and Teradata warehouses to Amazon Redshift Aims to make it easier to migrate from relational databases and data warehouses to cloud-based services.

We keep the SQL (DDL's) in subversion for creating the schemas. In oracle users that have objects are schemas so you just export/import based on the user.