Error restoring multiple tables using data file with single table data; specify data file created using EXPORT DB or EXPORT USER

-25336: Error restoring multiple tables using data file with single table data; specify data file created using EXPORT DB or EXPORT USER

Explanation:

Error in the Loader command for importing data.

The data was exported with the EXPORT TABLE command. This command exports only one table. This can only be imported using the relevant IMPORT TABLE command.

Note

You cannot import more than one table using this data.

User Response:

If you want to import all tables, or those belonging to a particular database user, you must first export them using the EXPORT DB or EXPORT USER command.