Oracle 11g Backup File Import 10g

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.

1. IMP-00010: the exported file is not valid and the header verification fails.
2. IMP-00000: Import failed

Use a tool to open the dmp file. The first line has a version

1. CEXPORT: V11.01.00

Then I change it

1. CEXPORT: V10.02.01

Ps: My Oracle 10g

The first problem is solved.

Next, the prompt for importing again is displayed.

1. EXPORT files created by EXPORT: V09.02.00 in the normal path
2. IMP-00013: only DBA can import files exported by other DBAs.
3. 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.

1. 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.

1. Create user sqltips identified by sqltips
2. Grant create session to sqltips
3. Authorize tablespace grant unlimited tablespace to sqlpits

1 2 Next Page