使用dmpdp导出：

     在cmd命令行输入：

       expdp username/password@orclstorage  dumpfile= db1125.dmp  directory= dump_dir full=y logfile=test.log;

       sqlplus sys/123456@db0214 as sysdba

        drop user username cascade;

        drop tablespace CREDIT including contents and datafiles cascade constraints;

CREATE TABLESPACE CREDIT

DATAFILE 'E:appadminoradatadb0214CREDIT01.DBF'

SIZE 2048M AUTOEXTEND ON NEXT 1024M

MAXSIZE UNLIMITED LOGGING

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user username identified by password

default tablespace credit

temporary tablespace temp

quota unlimited on credit;

grant create session to username;

grant Resource to username;

grant connect to username;

grant DBA to username;

使用sys账号登陆

SQL> conn sys/123456@db1201 as sysdba

drop directorydump_dir;

SQL> create directory dump_dir as 'e:databackup'; 

SQL> grant read,write on directory dump_dir to username;

 退出sqlplus,在命令行输入：

impdp username/password@db0214  directory=dump_dir dumpfile= CRTBS_20140213.DMP  full=y  logfile=impdp.log

如果导入时存在统计信息STATISTICS的报错，是oracle的一个bug,在上面命令后追加上exclude=STATISTICS