oracle数据库sql语句

  drop user 用户名  cascad

  select * from v$instance     select * from v$database    select * from v$version

create user 用户 identified by 密码 account lock 或者unlock

create tablespace 表空间名 datafile‘    路径＼ｄｂ.dbf’ size 5120m reuse autocextend on next 1024m 

maxsize unlimited;

create user us profile default identified by us default  tablespace us account unlock;

grant dba,create any table,create any jpb ,create any directory,create database link ,create any sequence,

alter any procedure ,drop any sequence ,unlimited tablespace to us;

create database link fmis connect to fmisss  identified by fdsss using   '(decsription =(address=

(peotocol=tcp)(host=ip(port=1521)))(connect_data=(server=dedicated)(service_name=gr)))' 

imp us/us file=d:\dd\db\dd_db.dmp log=d:\ddd\db_gg.log ignore=y full=y

create session ,create table connect resource dba

  grant  角色、权限 to 用户

rovoke   角色或者权限 from 用户

alter ueser   ；（create  ，grant  to，revoke from ，drop， aliter，）