Oracle: dump File Import error: only DBA can import files exported by other DBAs

Oracle: dump File Import error: only DBA can import files exported by other DBAs

Export the dump file of a table from schepaa (DBA permission) and import it to scheab (non-DBA permission). An error is returned.

Use the OB tool to set scheaa to DBA (the previous tables and views are gone ),

Check the following two statements online and click OK;

Grant dba to schepaa;
Alter user SchemaAdefault role DBA;

Then dump imports the OK file. After you cancel the DBA permission of scheqp using the OB tool,

The error "ora-01045: user system lacks create session privilege; logon denied" is reported again (the user has no permission to create session sessions)

Then run the following statement OK:

Grant create session to scheaa