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

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

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

 

Importing data to oracle fails. The error IMP-00013 is reported. only DBA can import files exported by other DBAs.

Grant the imported user the DBA permission, or find a user with the DBA permission to import the data.

I want to import the dmp file to oracle. only DBA can import files exported by other DBAs.

Do not use accounts with dba permissions when exporting data.
Or, you can use an account with dba permissions during import.
As shown above, are you sure the data in mc2data. dmp is owned by scott?

-----
Sqlplus sys as sysdba
Grant dba to scott