Oracle 数据库创建--创建表空间，用户 ，导出 ，导入

//创建表空间，用户
create tablespace lenovo
datafile 'E:\mylenovo\lenovo.dbf'
size 100M;
create user lenovo
identified by admin
default tablespace lenovo;
grant connect,resource to lenovo;


//导出
create directory lenovo_bak as 'E:\mylenovo';
grant read,write on directory lenovo_bak to lenovo;
exit;
expdp lenovo/admin schemas=lenovo dumpfile=lenovo_emp.dmp 
logfile=lenovo_bak.log directory=lenovo_bak
//导入
create directory lenovo_bak as 'E:\mylenovo';
grant read,write on directory lenovo_bak to lenovo;

impdp lenovo/admin directory=lenovo_bak logfile=lenovo_bak1.log dumpfile=lenovo_emp.dmp schemas=lenovo