Database
文章平均质量分 57
yexianyi
Software Architect @ Siemens
Email: yexianyi@hotmail.com
Linkedin: http://cn.linkedin.com/in/yexianyi/
Github: https://github.com/yexianyi/
展开
-
Gremlin: How to connect to gremlin server console
:remote connect tinkerpop.server conf/remote.yaml:remote consolegraph = TinkerGraph.open()g = graph.traversal()g.V()# g.close()原创 2021-05-20 12:01:21 · 322 阅读 · 0 评论 -
Oracle12c: How to create PDB in manually
Pre-condition: Go through my last blog.Install:Mount and open CDB sqlplus / as sysdba;startup nomount ;alter database open ;conn sys@NDLNE as sysdba ; Create PDB create pluggable database pdb1admin user pdb1_admin identified by pdb1_admin原创 2021-03-10 16:25:51 · 219 阅读 · 0 评论 -
Oracle12c: How to create CDB in manually
Set ORACLE_SID, for example, NDLNE export ORACLE_SID=NDLNE Create PFILE vi /u01/app/oracle/admin/NDLNE/pfile/init.oradb_name='NDLNE'memory_target=1Gmemory_max_target=1GDB_CREATE_FILE_DEST='/u01/app/oracle/oradata'control_files='/u01/app/oracle原创 2021-03-04 13:30:52 · 190 阅读 · 1 评论 -
ORA-00845: MEMORY_TARGET not supported on this system
Issue:When trying to startup Oracle Instance, you may encounter following error:ORA-00845: MEMORY_TARGET not supported on this systemRoot Cause:Your shm size is smaller than Memory_Target.Solution:Open pfile in "/u01/app/oracle/admin/<..原创 2021-02-23 14:48:11 · 171 阅读 · 0 评论 -
HOWTO: install Oracle 12c Database on Centos8
Step:PrepareCentOS Linux release 8.3.2011 with 4 core, 4G RAM and 40G DIsk space at least. Download Oracle 12c fromhttps://edelivery.oracle.com/osdc/faces/SoftwareDelivery You will see several ZIP file, like following Unzip all the ZIP files to a cu..原创 2021-02-19 12:33:51 · 330 阅读 · 0 评论 -
MSSQL: sql危险存储过程
如果不删除sql危险存储?如果不删除sql危险存储,可以按下面的方法执行系统命令sql server 2005下开启xp_cmdshell的办法EXEC sp_configure show advanced options, 1;RECONFIGURE;EXEC sp_configure xp_cmdshell, 1;RECONFIGURE;SQL2005开启OPENROWSET支转载 2008-08-19 08:43:00 · 1249 阅读 · 0 评论 -
MYSQL:Using JDBC with MySQL, Getting Started
Using JDBC with MySQL, Getting StartedJava Programming Notes # 662Preface Preview Installation and Preparation of MySQL Discussion and Sample Code for JDBC Programs Run the Programs转载 2008-11-01 18:50:00 · 1481 阅读 · 0 评论 -
MSSQL:改变数据库对象所有者
MSSQLServer:改变数据库对象所有者 利用SQL Server内置命令可以实现,在查询分析器里面使用下列命令:EXEC sp_changeobjectowner dbo.CUSTOMER , admin 其中,dbo是表CUSTOMER的原所有者,admin是该表的新所有者。原创 2009-01-23 20:46:00 · 805 阅读 · 0 评论 -
MSSQL:SQL Server 自增字段归零
SQL Server 自增字段归零假设有一数据库表admin.ROLE,现已在其中多次插入删除数据,使得自增字段当前值混乱。于是可通过下列语句,重新设定自增字段的起始值。但要注意在数据库表中不能存在相同的自增字段值。DBCC CHECKIDENT (admin.ROLE, RESEED, 0) 其中,admin.ROLE为表明,0为新的自增字段起始值。原创 2009-01-24 11:11:00 · 1339 阅读 · 1 评论 -
DB Concept": Identifying and Non-Identifying Relationships
• Relationship Type > Identifying Relationships: Identifying relationships are always mandatory. A foreign key value must exist in the child entity and the foreign key value must be found in the prima转载 2009-08-17 22:03:00 · 882 阅读 · 0 评论 -
Postgre: How to import UUID function into Postgre 9.3
1. Open a command console and go to the directory where you installed Postgre server.e.g. D:\Program Files\PostgreSQL\9.3\bin>2. Drill down into BIN folder and issue following command.psql -d -原创 2014-11-12 17:52:51 · 1259 阅读 · 0 评论 -
JDBC 驱动程序揭密
JDBC 驱动程序揭密对 Java 产生混淆的常见根源是:JDBC 有不同的版本,JDBC 驱动程序有不同的类型,它们可以被不同版本的 Java 使用。而且,新的 Java 规范总是在开发之中,因为通过 Java 社区过程(Java Community Process,http://www.jcp.org),相关的功能在不断地扩展中。JDBC 版本DB2 通用数据库 V8.1 支持 J转载 2008-08-21 15:19:00 · 2263 阅读 · 0 评论 -
DB2: 为DB2数据库创建新用户帐户并为其分配特定特权
目标到目前为止,一直使用实例管理员帐户(SYSADM)来执行所有数据库命令。这个帐户对所有实用程序、数据和数据库对象具有完全访问权。因此,为了避免无意或有意的数据损失,必须要保护这个帐户。在大多数情况下,需要创建不同的用户和/或组,并授予有限的权限集。在本次实验中,将创建一个新的用户帐户,然后为它分配特定的特权。回页首步骤1.转载 2008-08-20 21:46:00 · 2446 阅读 · 1 评论 -
Impala SQL: Unable to LOAD DATA from HDFS path due to WRITE permissions
Issue:While you are using Impala Official docker image "cloudera/quickstart", following exception might be thrown while executing LOAD DATA command to do data migration.Error:[Simba]原创 2017-03-09 11:36:28 · 5027 阅读 · 0 评论 -
MySQL InnoDB: Intention Lock
This artical states how doesIntention Lock work inMySql Server 8.0. Firstly, atesting database and table with seed data will be created. After that, we will see the difference when the table with U...原创 2019-05-13 17:02:59 · 357 阅读 · 0 评论 -
Mysql Lock with different isolation level
0. PreparationCREATE TABLE `test` ( `id` int(11) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, UNIQUE KEY `test_id_IDX` (`id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;1.Read...原创 2019-05-28 11:24:31 · 149 阅读 · 0 评论 -
事务隔离级别
Read uncommitted Read committed Repeatable read Serializable 定义 允许一个事务可以读取另一个未提交事务的数据 一个事务只能读取另一个已提交事务的数据 ...原创 2020-10-21 10:48:59 · 60 阅读 · 0 评论 -
MSSQL异常:JDBC连接SqlServer2000出现"Connection refused: connect"解决方案
For this kind of database connection problem, there are always two distinct issues:The SQL server itself is not running or TCP/IP is disabled. That can be confirmed by runnetstatand see it is li转载 2009-05-28 22:18:00 · 1975 阅读 · 0 评论 -
Oracle Database Undo space explained
Oracle Database Undo space explainedIan Hoogeboom29 Aug 2010 in Oracle14 CommentsIn this blog post I will talk about the basic workings of Automatic Undo Management, which can cause ORA-01转载 2013-03-11 16:08:46 · 1121 阅读 · 0 评论 -
Oracle 10g 异常:ORA-01658:unable to create INITIAL extent for segmnet in tablespace SYSTEM
问题描述:ORA-01658:unable to create INITIAL extent for segmnet in tablespace DATA01原因:表空间DATA01空间不足,导致数据无法插入。Solution:重新定义表空间大小: ALTER TABLESPACE DATA01 RESIZE 5G ;将表空间删除后重新定义表空间: DR原创 2009-08-23 21:19:00 · 4219 阅读 · 0 评论 -
Oracle 10g Admin: Create EM (创建EM)
Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:/Documents and Settings/Administrator>emca -repos create EMCA 开始于 2009-8-15 20:13:03 EM Configuration Assist原创 2009-08-15 20:46:00 · 826 阅读 · 0 评论 -
Oracle 10g 异常:ORA-01092: ORACLE 实例终止。强制断开连接 解决方案
问题:SQL> connect sys/password @RAOASYS as sysdba 已连接到空闲例程。 SQL> startup ORACLE 例程已经启动。 Total System Global Area 109051904 bytes Fixed Size 1295272 bytes Variable Size原创 2009-08-16 21:16:00 · 5017 阅读 · 0 评论 -
Oracle 10g 异常:ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 解决方案
问题:SQL> connect sys/password @RAOASYS as sysdba ERROR: ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 Solution:1.打开/network/admin/listener.ora文件,找到: SID_LIST_LISTENER = (SID_LIST = (S原创 2009-08-16 14:06:00 · 2143 阅读 · 1 评论 -
Oracle 10g 异常:ORA-12518: TNS: 监听程序无法分发客户机连接 解决方案
问题:SQL> connect sys/password @RAOASYS as sysdba ERROR: ORA-12518: TNS: 监听程序无法分发客户机连接 Solution:检查是否启动了oracle实例。C:/Documents and Settings/Administrator>net start OracleServiceRAOASYS原创 2009-08-16 13:03:00 · 5038 阅读 · 2 评论 -
Oracle 9i Exception: ORA-01504 错误解决方案
ORA-01504 错误解决方案 ORA-01504 database name string does not match parameter db_name string Cause: The name in a database create or mount does not match the name given in the initialization原创 2008-10-29 10:08:00 · 2245 阅读 · 0 评论 -
Oracle 10g 异常:ORA-01950: no privileges on Tablespace
Issue:ORA-01950: no privileges on Tablespace Solution:login as sysdba; GRANT UNLIMITED TABLESPACE TO youruser;原创 2009-12-03 12:21:00 · 1302 阅读 · 0 评论 -
Oracle 10g 异常:ORA-01092: ORACLE 例程终止。强行断开连接
问题描述:ORA-01092: ORACLE 例程终止。强行断开连接 Solution:检查initSID.ora中描述的参数与Create Database中的参数是否一致。尤其检查Temp Tablespace名称是否一致。原创 2009-08-23 21:10:00 · 1713 阅读 · 0 评论 -
Oracle 9i Exception:ORA-01034: ORACLE not available解决方案
登陆到SqlPlus后出现以下异常:SQL> SELECT host_name, instance_name, version FROM v$instance ; SELECT host_name, instance_name, version FROM v$instance * 第 1 行出现错误: ORA-01034: ORACLE not availableS原创 2009-08-16 12:48:00 · 1333 阅读 · 0 评论 -
Oracle 9i Exception: ORA-00911: 无效字符异常解决方案
ORA-00911: 无效字符 SQL> CREATE TABLESPACE data 2 DATAFILE ‘C:/oracle/product/10.2.0/oradata/ssvc/data.dbf SIZE 6G 3 extent management local autoallocate segment s原创 2009-05-19 15:45:00 · 2576 阅读 · 0 评论 -
Oracle 10g Exception: ORA-12638 Solution
Issue: When you create a instance and a database after your install Oracle 10g. You may come across following exception in D:/oracle/produ原创 2010-07-09 20:09:00 · 2249 阅读 · 0 评论 -
Oracle 11g: ORA-00907: missing right parenthesis solution
Issue:When you create table using sql like this.SQL> create table ships 2 ( 3 ship_id number , 4 ship_name varchar2(20), 5 home_PORT_ID number, 6 constrain ships_ports_原创 2011-12-21 13:19:41 · 1696 阅读 · 0 评论 -
Oracle 11g:Scalar Subquery expression Limitation
Scalar subqueries are not valid expressions in the following places: - As default values for columns- As hash expressions for clusters- In the RETURNING clause of DML statements- As the basi转载 2012-01-17 15:12:22 · 1446 阅读 · 0 评论 -
Oracle 11g: USER_TAB_PRIVS and ALL_TAB_PRIVS
SQL> SET LINESIZE 400SQL> SET PAGESIZE 400SQL> SELECT * FROM USER_TAB_PRIVS WHERE GRANTEE='XIAYE';GRANTEE OWNER TABLE_NAME原创 2012-02-10 15:07:24 · 2173 阅读 · 0 评论 -
Oracle 11g: The difference between WHERE and HAVING
SQL> select * from sys.SHIP_CABINS ;SHIP_CABIN_ID SHIP_ID ROOM_ ROOM_STYLE ROOM_TYPE WINDOW GUESTS SQ_FT BALCONY_SQ_FT------------- ---------- ----- ---------- -------原创 2012-02-13 16:34:14 · 1363 阅读 · 0 评论 -
Oracle 11g: How to add/enable/disable/drop a constraint
Table Sample:SQL> desc orders ; Name Null? Type ----------------------------------------- -------- ---------------------------- ORDER_ID原创 2012-02-23 17:13:34 · 1192 阅读 · 0 评论 -
Oracle 异常:ORA-00959: 表空间 'TEMP' 不存在
今日在创建EM 资料档案库时发生以下异常oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00959: 表空间 TEMP 不存在 at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:14原创 2009-08-15 20:24:00 · 3600 阅读 · 0 评论