CODEWITHSUNDEEP
oracle-databasedockerclone
Sandeep540
Sandeep540

Reputation: 977

Cloning a Oracle Database Schema

I have an Oracle 12c Instance with a scheme 'wadmin' user, this instance has tables, view, data, triggers, sequences etc.

For quick spinning of docker images, I need to clone the db schema as fast as possible , so that I can create another user 'wadmin1' link it to new docker and start my testing.

Any CLI/tools for the same, does oracle provide any options?

Upvotes: 0

Views: 1124

Answers (1)

Bartosz Gawron
Bartosz Gawron

Reputation: 187

I do not know if this is exacly what you are looking for but you can export your Oracle schema using ORACLE DataPump tool. This involves storing exported schema in the Oracle directory. While exporting schema to file you can transform the schema name, omit unnecessary tables or data etc. Exported files with database schema can be later used for imported to new database instance. More information regarding Oracle DataPump you can find here. https://oracle-base.com/articles/10g/oracle-data-pump-10g#SchemaExpImp.

Alternatively you can have scripts that create the database stored in the Git repository and integrate your builds with too called Flyway https://flywaydb.org/ which can be used to automatize of database schema creation. This is also really convenient from source control point of view. All changes on the schema are pull requested.

In my team we use OracleDataPump when we want to recreate the database together with the data, Flyway is used as a part of our continues integration.

Upvotes: 2

Related Questions