DBA相关知识

<script>function StorePage(){d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();}</script>

createNewUser

1、backup scott
exp
2、create user
create user wesley indentified by wesley default tablespace users quota 10M on users
grant create session 登陆权限
grant create table,create view to wesley 建表权限，建试图权限
3、import the data
imp 导入备份数去