How can I backup a database using the export utility? Thank you in advance.
Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data files.
One of the advantages of exports is that one can selectively re-import tables, however one cannot roll-forward from an restored export file. To completely restore a database from an export file one practically needs to recreate the entire database.
Always do full system level exports (FULL=YES). Full exports include more information about the database in the export file than user level exports.
No one has followed this question yet.
I'm trying to backup a database in SQL Management Studio onto a hard drive with 931GB free space. I keep getting an error message saying there is not enough free space, but the database is only 52GB in size so there should be plenty of space.