-- Create tablespace创建表空间
create bigfile tablespace TALENTBASE datafile 'F:\app\Administrator\oradata\orcl\TALENTBASE.dbf' size 5000m autoextend on;
-- Create the user 创建用户
create user xdsjk1
identified by "xdsjk1"
default tablespace TALENTBASE
temporary tablespace TEMP
profile DEFAULT
password expire;
-- Grant/Revoke role privileges
-- Grant/Revoke system privileges
grant unlimited tablespace to xdsjk1;
grant connect,resource,dba to xdsjk1;
grant create session to xdsjk1;
--修改用户密码
alter user xdsjk1 identified by 123456;
--查看目录
select * from dba_directories
grant read,write on directory DUMP to xdsjk1;
以上都有了然后开始在dos命令下执行这句话:cd F:\app\Administrator\product\11.2.0\dbhome_1\BIN>impdpxdsjk1/123456@10.1.234.183:1521/orcl directory=dump dumpfile=20160704shuyang.dmp logfile=20160704shuyang.log REMAP_SCHEMA=test_hcm_data:xdsjk1
1、新建directory的语法
CREATE OR REPLACE DIRECTORY directory AS 'dump1';
例如:
create or replace directory dump1 as 'e:\dump'
这样把目录d:\dump\d?>ir设置成dump_dir代表的directory
2、查询有哪些directory
select * from dba_directories
3、赋权
grant read,write on directory DUMP to xdsjk1;
---------------------------------------导出数据库命令----------------------------------------------------
C:\app\Administrator\product\11.2.0\dbhome_1\BIN>exp 用户名/密码@数据连接地址 file=d:\wandahr_test_3.dmp full=y
注意:在通过pl sql 导出时候,确保客户端版本和服务端版本一致。负责可能报错MAXSIZE错误