sqlplus system/system@LMS
SPOOL lms.log;
//若LMS用户已存在,则先删除LMS用户以及LMS,LMS_IND表空间
drop user LMS cascade;
drop tablespace LMS including contents;
drop tablespace LMS_IND including contents;
//创建LMS,LMS_IND表空间以及LMS用户
CREATE TABLESPACE LMS
DATAFILE 'C:\ORACLE\ORADATA\LMS\LMS.DBF' SIZE 400M
DEFAULT STORAGE (
INITIAL 200K
NEXT 200K
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 0)
ONLINE;
CREATE TABLESPACE LMS_IND
DATAFILE 'C:\ORACLE\ORADATA\LMS\LMS_IND.DBF' SIZE 50M
DEFAULT STORAGE (
INITIAL 200K
NEXT 200K
MINEXTENTS 1
MAXEXTENTS unlimited
PCTINCREASE 0)
ONLINE;
CREATE USER LMS IDENTIFIED BY oracle
DEFAULT TABLESPACE LMS
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON LMS;
GRANT connect, resource, alter session TO LMS;
SPOOL off;
//导入数据
imp LMS/oracle@LMS touser=LMS file=D:\oracle\exp\LMS.dmp log=D:\oracle\imp\LMS.log
==========导出LMS用户的所有对象=================
exp LMS/oracle@LMS file=D:\oracle\exp\LMS.dmp owner=LMS log=D:\oracle\exp\LMS.log