Oracle 11g backup file imported 10g, *. dmp file imported to 10g encountered a lot of problems
The following error occurs when I export data from 11 GB and then import the data to 10 Gb.
- IMP-00010: the exported file is not valid and the header verification fails.
- IMP-00000: Import failed
Use a tool to open the dmp file. The first line has a version
- CEXPORT: V11.01.00
Then I change it
- CEXPORT: V10.02.01
Ps: My Oracle 10g
The first problem is solved.
Next, the prompt for importing again is displayed.
- EXPORT files created by EXPORT: V09.02.00 in the normal path
- IMP-00013: only DBA can import files exported by other DBAs.
- IMP-00000: Import failed
This file is exported by a user with DBA permissions, and the user to be imported has no DBA permissions.
Okay. Grant the DBA permission to this user.
- Grant dba to "myuser"
Run imp drp/drp
I forgot what the prompt is, but it is about terminating the import.
The reason is that the file name to be imported is SQLTips. dmp.
The schema I log on to is drp, which may not match.
- Create user sqltips identified by sqltips
- Grant create session to sqltips
- Authorize tablespace grant unlimited tablespace to sqlpits