零、连接
使用disql连接:
./disql SYSDBA/SYSDBA@192.168.199.123:5238
或者:
./disql /nolog
SQL> conn sysdba/123456@192.168.40.40:5236
一、表空间
创建表空间(表空间名:UUMS):
create tablespace "UUMS" datafile 'D:\ProgramFiles\dmdbms\data\MyData\UUMS.dbf' size 128 autoextend on maxsize 16777215 cache = NORMAL;
删除表空间:
drop tablespace "UUMS";
扩展表空间:
1.resize 表空间数据文件的大小 (所有的数据文件大小都应该一致,修改其中一个,另外的都要更改)
alter tablespace tbs1 resize datafile '/dm8/data/DAMENG/tbs01.dbf' to 256;
2.增加数据文件
Alter tablespace tbs1 add datafile ‘/dm8/data/DAMENG/tbs02.dbf’ size 50 autoextend on next 1 maxsize 100;
二、用户
创建用户(用户名:UUMS,密码:uums123456):
create user "UUMS" identified by "uums123456" limit failed_login_attemps 3, password_life_time 7, password_lock_time 1, password_grace_time 10 default tablespace "UUMS";
删除用户(用户名:UUMS):
drop user "UUMS";
授权用户(用户名:UUMS,授权角色:DBA、PUBLIC、RESOURCE):
grant "DBA","PUBLIC","RESOURCE" to "UUMS" with admin option;
查看所有用户:
select username,user_id,default_tablespace,profile from dba_users;
修改用户密码:
alter user sysdba identified by "seeyon";
三、查询
查看达梦数据库的初始化配置参数信息:
select para_name,para_value from v$dm_ini limit 5;
过滤查看数据库的配置端口:
select para_name,para_value from v$dm_ini where para_name like '%PORT%';
查看达梦数据库库名:
select name,create_time from v$database;
查看达梦数据库实例名及状态:
select name,instance_name,start_time,status$ from v$instance;
查看数据库里所有使用用户:
select username,user_id,default_tablespace,profile from dba_users;
查看所有角色:
select role from dba_roles;
查看所有表空间:
select id,name,max_size,total_size,status$ from v$tablespace;
select tablespace_name,status from dba_tablespaces;
查看所有数据文件:
select id,path,max_size,free_size,status$ from v$datafile;
查看日志文件路径信息:
select path,rlog_size from v$rlogfile;
查看所有对象:
select from dba_objects;
select from dba_objects where objectname like 'DBA%';
select * from dba_objects where object_name like 'V$%';
查看用户表对象:
select owner,table_name,tablespace_name,status from dba_tables where owner='TEST1' limit 5;
查看角色类型:
select * from dba_roles;
新建模式并授权:
CREATE SCHEMA "V3X-SPACE" AUTHORIZATION "V3XUSER";
如若转载,请注明出处:https://www.ozabc.com/jianzhan/24194.html