Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to backup complete schema with all objects, user etc.

Nico van de KampOct 5 2018 — edited Oct 5 2018

Hello, For my understanding/learning I have in the past installed a Oracle database with a few new database schema's under Windows 7. This was working fine. I have a new computer and I have installed Apex with Oracle database XE on this new computer. This is also working fine. I have made a backup with SQL-developer of the 'old' database schema which I created by myself on the old computer. But this backup is only the database tables and data. I want to make a complete backup of the schema with all his objects. Also that in this script the database schema is created. My goal is that only have to run this script and the complete database schema is 'cloned' from the 'old' environment to the new environment. Is that possible with a SQ-Developer or with a SQL script? If so, can someone help with the beginning of that script or does somebody know an example of it Or is this only possible in SQL+? Or has this to be done in a few different scripts, in a few different steps? With Regards, Nico

Comments
Post Details
Added on Oct 5 2018
7 comments
20,106 views