Is dmp file suitable despite ORA-01555 'snapshop too old' warnings? Well, the title of the question is self-explanatory.


Export finished successfully with warnings.
Log shows several ORA-01555 snapshot too old errors.


- Is it OK to use that dmp file to perform an import full in another instance?

- Would running the export in restricted mode (no users connected) garantee no 'ORA-01555 snapshot too old' would occur?
Technically, you could, but it is incomplete, so better repeat the export after performing the necessary actions to avoid ORA-01555 errors (have an appropriately sized undo tablespace, set undo_retention and retention guarantee).