达梦数据库基本操作

查询所有schema

?

1	select distinct object_name TABLE_SCHEMA from all_objects where object_type='SCH';

 查询指定用户下的schema

?

1	select distinct object_name TABLE_SCHEMA from all_objects where object_type='SCH' AND OWNER='SYSDBA';

 查询表空间

?

1	select tablespace_name from dba_tablespaces;

 查询所有表

?

1	select TABLE_NAME from dba_tables;

查询表空间

?

1	select tablespace_name from dba_tablespaces;

 查询连接次数

?

1	select para_name,para_value from v$dm_ini where para_name='MVCC_RETRY_TIMES';