Oracle常用语句

--忘记数据库sys密码：

输入cmd命令，再输入sqlplus "/ as sysdba"

--更改密码
alter user sys identified by abcd1234; 

导入dmp文件方法：输入cmd

imp userName/password@127.0.0.1:1521/ORCL  file='D:\was_lib\oauth120190301.dmp' full=y
口令+as sysdba

用户名：sys as sysdba
密码：abcd1234

--创建临时表空间 表空间路径可根据实际情况更改
create temporary tablespace BOP_TEMP tempfile 'E:/Oracle_space/BOP_TEMP.ora' size 100M autoextend on next 50M maxsize unlimited; 

--创建数据表空间 表空间路径可根据实际情况更改
create tablespace BOP_DATA datafile 'E:/Oracle_space/BOP_DATA.ora' size 100M autoextend on next 50M maxsize unlimited; 

create user BOP identified by BOP default tablespace BOP_DATA temporary tablespace BOP_TEMP; 

--给用户分配权限BOP
GRANT CREATE SESSION,ALTER SESSION TO BOP;
GRANT CREATE SEQUENCE TO BOP;
GRANT CREATE TABLE TO BOP;
GRANT CREATE VIEW TO BOP;
GRANT SELECT ANY DICTIONARY TO BOP;
GRANT CREATE ANY PROCEDURE,EXECUTE ANY PROCEDURE TO BOP;

--给用户分配表空间的使用权限
--ALTER USER BOP UNLIMITED ON BOP_DATA;
CREATE SEQUENCE  "BOP"."HIBERNATE_SEQUENCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 10 NOORDER  NOCYCLE ;

--赋予dba权限
grant connect,resource,dba to CIFES;

GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO BOP;