su oralce用户下,system用户进入sqlplus操作:
--创建表空间
CREATE TABLESPACE "EAS_D_HAIYA_STANDARD" DATAFILE '/kingdee/oradata/oradata/HY/EAS_D_HAIYA_STANDARD.ora' SIZE 5000M;
ALTER DATABASE DATAFILE '/kingdee/oradata/oradata/HY/EAS_D_HAIYA_STANDARD.ora' AUTOEXTEND ON;
--创建临时表空间
CREATE TEMPORARY TABLESPACE "EAS_T_HAIYA_STANDARD" TEMPFILE '/kingdee/oradata/oradata/HY/EAS_T_HAIYA_STANDARD.DBF' SIZE 1000M;
ALTER DATABASE TEMPFILE '/kingdee/oradata/oradata/HY/EAS_T_HAIYA_STANDARD.DBF' AUTOEXTEND ON;
--创建用户
CREATE USER HY0728 IDENTIFIED BY kingdee DEFAULT TABLESPACE EAS_D_HAIYA_STANDARD TEMPORARY TABLESPACE EAS_T_HAIYA_STANDARD;
--用户赋权
grant dba to HY0728;
--用户赋予密码
alter user HY0728 identified by kingdee;
su oralce用户下操作:
--备份正式数据库
exp kingdee1/lsjygs@oral file='D:/20101210x.dmp' log='D:/20101210x.log' statistics=none full=y
statistics=none的作用是去掉报统计错误
--导入DMP格式的备份文件,不用上传100727x.log文件imp HY0728/kingdee fromuser=haiya touser=HY0728 file='/kingdee/100727x.dmp' log='/kingdee/100727x.log' ignore=y