创建oracle表空间与用户

/*创建数据表空间*/
create tablespace LIMS
logging datafile 'D:\datebase\Oraclexe\oradata\XE\LIMS.dbf'
size 50M
autoextend on
next 10M maxsize 512M
extent management local;

/*创建用户*/
create user lims identified by limspwd
default tablespace LIMS;

/*授权*/
grant connect,resource,unlimited tablespace to lims;

/*导入数据*/

$imp lims/limspwd@xe fromuser=lims touser=lims file=D:\limsl_20141230.dmp