dm8 创建数据库和dexp导出数据库

select * from v$datafile;
#查询文件路径 下一步要用到
select * from dba_data_files;

#FZLD 为tablespace  名称
create tablespace "FZLD" datafile
'/opt/dmdbms/data/DAMENG/FZLD_01.DBF' size 256 autoextend on next 1 maxsize 20480,
'/opt/dmdbms/data/DAMENG/FZLD_02.DBF' size 256 autoextend on next 1
maxsize 20480 CACHE = NORMAL;

#查询是否创建成功
select * from dba_free_space;
#创建用户 fzld 
CREATE USER fzld IDENTIFIED BY "fzld123456" DEFAULT TABLESPACE FZLD; 
#设置密码不失效
alter user fzld limit  password_lock_time unlimited;
#授权用户
GRANT RESOURCE TO fzld;

执行上面得命令后 用新用户登录即可

 在linux中导出数据库

cd 到数据库的安装目录

cd bin

./dexp USERID=username/password FILE=db_str.dmp DIRECTORY=~/ LOG=~/db_str.log FULL=Y  NOLOGFILE=Y INCLUDE=INDEXES

在linux中导人数据库

./dimp USERID=username/password FILE=db_str.dmp DIRECTORY=~/ LOG=~/db_str.log FULL=Y  NOLOGFILE=Y