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?
Best Answer
It would be time saving if you just backup the tables being errored in ORA-1555 after the warning full backups. Yes, to answer main question, it is good backup to be imported, you can exclude the errored tables or use table_exists_action=replace using tables only backup after taking the tables backup in above para.
Scenario warning = if the errored tables have any dependent primary key or foreign key referenced constraints, then the other tables being referenced also needs to be backed up maintaining consistency to make sure constraints don't get invalid.