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‘ 路径\db.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,)