Skip to content

Instantly share code, notes, and snippets.

@jpina

jpina/oracle_backup_restore.md

Last active January 8, 2016 21:49
Show Gist options
  • Save jpina/aaec7b4751aac79abcd4 to your computer and use it in GitHub Desktop.
Save jpina/aaec7b4751aac79abcd4 to your computer and use it in GitHub Desktop.
Download ZIP
Restore an Oracle database backup
Raw
oracle_backup_restore.md

Restore an Oracle database backup

unzip zipped_file_with_sql_contents.zip
sed -i 's/SCHEMA/SCHEMA2/g' file.sql
sqlplus sys/PASSWORD@xe as sysdba

sqlplus> @/path/to/file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment