Creating a DDL for a baseline for flyway

Question

I've got an oracle 11 XE database, with 3 schemas in it, that I want to create a DDL file for to make a baseline script to use with flyway.

I've tried to export just the DDL of all 3 schemas, but the resulting sql doesn't include the creation of the users, or the creation of the tablespaces. It just starts off with sql to create tables, which will not work as the users or the tablespaces don't exist.

Is there any way to do this with sql-developer or am I using the wrong tool for the job here?

I'm thinking I may need to include all the SYSTEM objects in the DDL, but no idea how importing that into a running oracle instance will work.

Any tips or hints I'd be grateful for, I'm starting to think this plan just isn't possible. :-(

Thanks

Matt

Answer 1

when we generate the ddl for a schema, we grab the schema objects, not the definition of the user that owns the schema, nor the tablespaces used IN the schema

you can still get those though, just open the DBA Panel -