cg_ssh的博客

1.用 EXP 从服务器导出报 ORA-00091 原因是服务器字符集是 UTF-8 本地字符集是 ZHS16GBK.执行startup mount 报ORA-12514 请检查 listener.ora 中是否配置了红色部分内容。SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\admin\product\11.2.0\dbhome_1

异常代码:20:17:49.331 [http-nio-8081-exec-6] ERROR c.a.d.f.s.StatFilter - [mergeSql,169] - merge sql error, dbType oracle, druid-1.2.8, sql : WITH orgn AS(SELECT w.dwid,w.qk,w.qkdm,w.jhid FROM cd_orgn_source_attr w WHERE w.dwid='xAJLaafdjei321jlaj13

1.建表-- Create table 创建表 testcreate table TEST( testid NUMBER not null, name NVARCHAR2(20) not null)--comment 注释comment on column TEST.testid is 'ID';comment on column TEST.name is '名称';-- Create/Recreate primary, unique and foreign key