Oracle简单操作

--创建用户
createuser username IDENTIFIED BY username;
--用户授权
grant dba to username;
---删除用户
drop user user_name cascade；
--创建逻辑目录
create or replace directory data_dump  as 'e:\aa';
--查询逻辑目录
select * from dba_directories;
--导出数据库
exp username/pwd@orcl  owner=username file=d:/dpdump/test.dmp LOG=d:/dpdump/test.log
expdp username/pwd@orcl schemas=username(多个可用逗号隔开) DIRECTORY=DATA_DUMP dumpfile=test.dmp  logfile=test.log 
--导入数据库(ignore忽略错误full完全导入)
imp username/pwd@orcl file=d:\dumpfile\test.dmp ignore=y full=y logfile=d:\dumpfile\test.log
imp username/pwd@orcl file=d:\dumpfile\test.dmp fromuser =username touser =username1 logfile=d:\dumpfile\test.log
impdp username/pwd@orcl directory=DATA_DUMP dumpfile=test.DMP logfile=test.log REMAP_SCHEMA=username:username1
--查看表空间及大小
select tablespace_name, file_id,file_name, ROUND(bytes/(1024*1024),0)||'M' total_space from dba_data_files order by tablespace_name