Use expdp/impdp for oracle Import and Export
My colleague in version 11gR2 11.2.0.1.0 is 11gr1. You need to specify the version 11.1.0.6.0.
I installed oracle 11gR2. My colleague installed 11gR1 and used expdp to export impdp import. The system prompts that the version is incompatible.
After reading the oracle document, we can see that this parameter version is successfully imported with the oracle version = 11.1.0.6.0.
SQL code
-- Create a dump file directory
Create directory dump_test as 'd: \ test \ dump'
-- Grant the read/write permission to the user you want to operate on
Grant read, write on directory dump_test
Username
-- Query whether a self-created file directory exists.
Select * from dba_directories;
Select * from da. user_tables
-- Note that earlier versions cannot be imported. For example, if my database is 11gR2 and the other database is 11gr1, you must specify the version 11.1.0.6.0.
Expdp username/password directory = dump_test dumpfile = data. dmp version = 11.1.0.6.0
-- The Directory 'd: \ test \ dump' created in the previous directory is imported by default'
-- Import files
Impdp username/password directory = dump_test dumpfile = data. dmp
This article is from "aline"