I'm having trouble finding a good source of information on exporting/importing a full database.
I used the following command to export my database:
exp system/manager FULL=Y FILE=backup.exp
Since then, some undesirable changes were made and I'd like to go back and restore the database I exported. What exactly do I need to do this?
Can I just run
imp system/manager FULL=Y FILE=backup.exp
Do I have to delete the database? If I delete the database, do I have to add the tablespace, etc or will the import do that? I'm basically looking for the filler steps between the export and import.
The import utility REQUIRES an "operational" database to be up and running at the time the "imp" is launched. However this database can be an "empty" database (with essentially only SYS objects in it).
For example, tablespaces will get (re)created if they do not exist at the time the import is started.