oracle 常用语句收集
解锁用户
alter user setm account unlock;
删除用户
drop user setm;
修改用户密码
alter user setm identified by setm2019;
查看当前用户
show user;
执行sql文件(PATH表示文件的路径)
@PATH/filename.sql
查看当前数据库名
select name from v$database;
关闭数据库
shutdown immediate;
查询所有表
select table_name from all_tables;
测试环境授权模板
create tablespace testdb datafile ‘/data/orcl/datafile/cmisdb01.dbf’ size 5G autoextend on;
alter tablespace testdb add datafile ‘/data/orcl/datafile/cmisdb02.dbf’ size 2G autoextend on;
create user test_lmt identified by “after2019%”;
alter user test_lmt default tablespace testdb;
#alter user aftloan identified by “after2019%”;
grant connect,resource to test_lmt;
grant create view to test_lmt;
grant unlimited tablespace to test_lmt;