Want to import a oracle11g database to their local computer, direct exp export to get their own computer on the prompt error,
So I find a way on the internet
Here's how:
One, on the 11g server, use the EXPDP command to back up data
11g Export statement: EXPDP userid= 'Facial/[email protected]As Sysdba ' schemas=FacialDirectory=data_pump_dir dumpfile=Test. DMP logfile=Test. Log version=10.2.0.1.0
Where the red text part is rewritten as needed. For example, my user facial password is facial, the database SID is Orcl,schemas to be out of the username is facial, to be imported into the 10.2.0.1.0 version of the Oracle database. Test.dmp and Test.log will be generated in the 11g dpdump directory, for example, my 11g is installed under the E disk, so test.dmp will be generated in the E:\app\Administrator\admin\orcl\dpdump directory.
Second, on the 10g server, using the IMPDP command to recover data
Preparation: 1. Build a library 2. Build a table Space 3. Build a user and authorize 4. Copy the test.dmp to the 10g Dpdump directory
--Create TABLE space
Create tablespace ts_facial datafile ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\Facial.DBF ' size 500M autoextend on next 50M ;
--Create User
Create user facial identified by facial default tablespace ts_facial;
--Authorized to User
Grant CONNECT,RESOURCE,DBA to facial;
Test.dmp and Test.log are placed in the E:\oracle\product\10.2.0\admin\orcl\dpdump directory.
10g import statement: IMPDP userid= 'Facial/[email protected]As Sysdba ' schemas=FacialDirectory=data_pump_dir dumpfile=Test. DMP logfile=Test. Log version=10.2.0.1.0
Where the red part is rewritten as needed. For example, my user facial password is facial, the database SID is Orcl,schemas to import the user named Facial, to be imported into the 10.2.0.1.0 version of the Oracle database. The Test.log will be generated in the 10g Dpdump directory.
Oracle 11g 32&64-bit export imported to oracle10g 32-bit