数据库常用指令

C:\ShenTong\bin>osrimp -u sysdba/szoscar55 -d osrdb file="C:\2019-09-16.osr" level=schema schema=TEST;

create user TEST password ‘123456‘;

SELECT
    n . nspname AS  "SCHEMA" ,
    c . relname AS  "table_name" ,
    CASE c . relkind 
        WHEN ‘r‘ THEN ‘table‘ 
        WHEN ‘f‘ THEN ‘partition table‘ 
        WHEN ‘v‘ THEN ‘view‘ 
        WHEN ‘i‘ THEN ‘index‘ 
        WHEN ‘g‘ THEN ‘partition index‘ 
        WHEN ‘S‘ THEN ‘sequence‘ 
        WHEN ‘s‘ THEN ‘special‘ 
        WHEN ‘m‘ THEN ‘materialized view‘ 
        WHEN ‘k‘ THEN ‘table(kstore)‘ 
        WHEN ‘K‘ THEN ‘partition table(kstore)‘ 
        WHEN ‘e‘ THEN ‘table(external)‘ 
    END AS  "TYPE" ,
    u . usename AS  "OWNER" 
FROM 
    info_schem . v_sys_class c 
    LEFT JOIN 
        info_schem . v_sys_user u 
        ON u . usesysid = c . relowner 
    LEFT JOIN 
        info_schem . v_sys_namespace n 
        ON n . oid = c . relnamespace 
WHERE 
    n . nspdbid = current_database_id ()
    AND c . relname <> ‘SYS_JOBS‘ 
    AND c . relkind IN (‘r‘ , ‘f‘ , ‘k‘ , ‘K‘ , ‘e‘ , ‘‘ ) 
    AND n . nspname NOT IN (‘INFO_SCHEM‘ ) 
    AND n . nspname IN (‘ADP‘ ) 
ORDER BY 
    1 ,
    2;

ALTER TABLE DSAA.SYS_LOG ADD OPERATIONID VARCHAR(100) ;
COMMENT ON COLUMN DSAA.SYS_LOG.OPERATIONID IS ‘操作标识‘ ;

--重启服务
/etc/init.d/kstoredb_KSTOREd restart
--查看数据库的状态
/etc/init.d/kstoredb_KSTOREd status
--查看服务
ll /etc/init.d/

 <Connector URIEncoding="UTF-8" connectionTimeout="2000000" port="8180" protocol="HTTP/1.1" redirectPort="8443"/>

 SELECT COLUMN_NAME as "columnEn",REMARKS as "columnCn", 
      TYPE_NAME as "datatype",COLUMN_SIZE as "fieldLength"
 FROM V_SYS_COLUMNS 
WHERE TABLE_NAME = ‘AAAAA‘ 
  AND TABLE_SCHEM = ‘AAAAA‘
  AND COLUMN_NAME <> ‘SYSATTR_ROWVERSION‘ 
  AND COLUMN_NAME <> ‘ROWID‘
  AND COLUMN_NAME <> ‘ROWVERSION‘
  AND COLUMN_NAME <> ‘DATAPACKNO‘

SELECT TABLE_NAME FROM V_SYS_TABLES

SET SEARCH_PATH=‘SYSDBA‘,‘AAAAA‘,‘PUBLIC‘;