Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
-- LIMSHQ as your DBA account, from within SQL
dp export -directory dmpdir -dumpfile to###-geodcat.dmpdp -logfile to###-geodcat.log -schemas geodcat
-- pick up the output file from s1:/backup/export/

-- To restore on ship
dp export -directory dmpdir -dumpfile geodcat-yyyymmdd.dmpdp -logiflelogfile geodcat-yyyymmdd.log -schemas geodcat         -- Backup up the current state
drop user geodcat cascade constraints;                                                                              -- Delete the current schema
dp import -directory dmpdir -dumpfile to###-geodcat.dmpdp -logfile to###-geodcat-import.log -schemas geodcat        -- Restore from copy transported

...