orcal 导入导出数据库

来源：互联网发布：有域名了怎么建立网站编辑：程序博客网时间：2024/06/06 02:35

-- 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错误

0 0