Shulou(Shulou.com)06/01 Report--

I. Environmental platform

Version

Machine A:

Linux RHEL 5.8 X64

Oracle 11.2.0.3 X64

Single instance oral

Machine B:

Win2003 X32

Oracle 11.2.0.1 X32

Single instance oral

Bring only the data files that come with the system, without custom tablespaces and users

Second, A machine executes full library export [oracle@oracle ~] $sqlplus / nolog

SQL > conn / as sysdba

SQL > create directory dump_dir as'/ u01amp oracle DMP'

SQL > grant read,write on directory dump_dir to system

[oracle@oracle ~] $expdp system/oracle directory=dump_dir dumpfile=full.dmp log=full.log full=y

[oracle@oracle dmp] $pwd

/ u01/oracle/dmp

[oracle@oracle dmp] $ls

Export.log full.dmp

Copy the dmp file to the B machine E:\ app\ Administrator\ admin\ oral\ dpdump directory

4. Machine B creates the same instance using dbca by default.

Fifth, B machine to create the same custom tablespace is the premise to create the same tablespace, there is no need to create custom users, user objects will be automatically created during import

Create tablespace xxx datafile'e:\ app\ Administrator\ oradata\ oral\ xxx.dbf' size 2000m autoextend on next 10m maxsize unlimited

6. B machine imports dmp file impdp system/oracle dumpfile=full.dmp full=y log=fullback.log

Query results:

Data is normal.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.