oracel cmd 命令总结

登录

sqlplus/ as sysdba

创建数据表空间 

create tablespace zhbh_db logging datafile 'D:\app\HowardGe\oradata\zhbh_db.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;  

创建用户并指定表空间：

create user zhbh_odm identified by zhbh_odm$howard default tablespace zhbh_db;  
create user zhbh_itf identified by zhbh_itf$howard default tablespace zhbh_db;
create user zhbh identified by  zhbh$howard default tablespace zhbh_db;

给用户授予权限

grant connect,resource,dba to zhbh,zhbh_itf,zhbh_odm;

 删除用户

drop user zhbh cascade

ps：删除了user，只是删除了该user下的schema objects，是不会删除相应的tablespace的。

删除数据表空间 

drop tablespace zhbh_db including contents and datafiles;

整盘数据库导出

exp zhbh/zhbh$howard@zhbh_db file='D:\app\HowardGe\oradata\zhbh.dmp' grants=y full=n;

整盘数据库导入

imp zhbh_odm/zhbh_odm$howard file=D:\app\HowardGe\oradata\zhbh.dmp fromuser=user1 touser=user2 commit=y ignore=y rows=y indexes=y;