按类别查询搜索结果
关于关键词 的检测结果,共 20051
于秋1217 | 2019-05-30 17:37:31 | 阅读(6910) | 评论(0)
生产环境Oracle RAC集群测试最佳方法(支持Oracle 11g/12c/18c/19c RAC安装后期测试过程)【阅读全文】
hxl | 2019-05-17 10:56:48 | 阅读(0) | 评论(0)
1.启动pdbalter pluggable database ORA12CPDB1 open; 【阅读全文】
youlan878 | 2019-05-14 16:59:52 | 阅读(1180) | 评论(0)
华为向Oracle、SAP下战书 发布数据库替换Salesforce“数据库中的苹果”甲骨文中国刚刚裁员900余人,华为就被爆出将推出新的云数据库产品,大有取而代之之意?“数据库中的苹果”甲骨文中国刚刚裁员900余人,华为就被爆出将推出新的云数据库产品,大有取而代之之意?据外媒The Information于5月10日...【阅读全文】
level | 2019-05-14 09:34:36 | 阅读(7640) | 评论(0)
 RMAN在数据库服务器的帮助下实现数据库文件、控制文件、数据库文件与控制文件的映像副本、归档日志文件、数据库服务器参数文件的备份。  RMAN的特点:(1) 支持增量备份:传统的exp与expdp备份工具,只能实现一个完整备份而不能增量备份,RMAN采用备份级别实现增量备份,在一个完整的备份基础上采用增量备份可以...【阅读全文】
dbwatcher | 2019-04-10 16:14:09 | 阅读(5740) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。Oracle sysaux表空间使用过大处理第三篇,前两篇请见Oracle sysaux表空间使用过大处理-1(http://blog.chinaunix.net/uid-31396856-id-5819732.html)和Oracle sysaux表空间使用过大处理-2(http://blog.chinaunix.net/uid-31396856-id-5819835.html)前面2篇都是用了非常...【阅读全文】
dbwatcher | 2019-04-10 15:29:01 | 阅读(5350) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。接上文(Oracle sysaux表空间使用过大处理-1http://blog.chinaunix.net/uid-31396856-id-5819732.html)介绍另一种处理方法:基本情况如下:sysaux空间使用很大,检查相关对象,和awr设置发现dbid=3737847129不是当前数据库,并且sysaux使用对象如下:top segment...【阅读全文】
dbwatcher | 2019-04-08 16:04:47 | 阅读(5990) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。Oracle sysaux表空间占用过大处理办法:step1:检查表空间的使用情况sysaux表空间空间使用是很大的。step2:检查表空间被内容占用:主要是awr信息库使用了sysaux表空间,step3:检查awr相关的配置信息:有2个awr资料库,分别是dbid=3737847129,和dbid=357941...【阅读全文】
【Oracle】 Oracle重建索引
dbwatcher | 2019-04-08 13:36:39 | 阅读(720) | 评论(0)
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:Oracle普通索引是一种B树结构,在数据查询方面有很高的效率。但是有些时候需要重建索引。1、什么时候需要重建索引(1)索引失效,比如ORA-01502错误;(2)索引碎片较多,增加了索引的查询成本和维护成本;(3)统计信息不准确,导致SQL语句的执行的时候选择...【阅读全文】
lvxing | 2019-03-25 15:59:35 | 阅读(5710) | 评论(0)
oracle10 版本 jdbc 驱动中 OraclePreparedStatement 执行excuteQuery 时返回的ResultSet的日期类型字段使用getObject 获得对象时,返回的是 java.sql.Date 。 这一点和 oracle9i 及oracle 11g 驱动不同。更新驱动不慎,会造成显示的日期时间字段缺失 时 分 秒。...【阅读全文】
evan_china | 2019-03-06 12:40:00 | 阅读(6390) | 评论(0)
获取Oracle/SQL Server/MySQL获取表及字段数据字典,以及唯一索引的聚合信息【阅读全文】
unix_5359 | 2019-03-05 14:22:52 | 阅读(280) | 评论(0)
Evaluate the following SQL commands:INCREMENT BY 10MAXVALUE 9999SQL>CREATE TABLE ord_itemsitem_no NUMBER(3),expiry_date date CHECK (expiry_date > SYSDATE),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));A) You cannot use SYSDATE in the condition of a CH...【阅读全文】
unix_5359 | 2019-03-05 13:07:19 | 阅读(270) | 评论(0)
Which two statements are true regarding the USING and ON clauses in table joins?B) A maximum of one pair of columns can be joined between two tables using the ON clause.D) The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause...【阅读全文】
unix_5359 | 2019-03-05 11:32:05 | 阅读(300) | 评论(0)
Examine the structure of the BOORSTRANSACTIONS table:Examine the SQL statement:MEMBER_ID IN ('A101', 'A102');A) It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.C) It displays details for members who have borrowed before today with RM ...【阅读全文】
unix_5359 | 2019-03-05 10:17:29 | 阅读(280) | 评论(0)
Examine the structure of the DEPARTMENTS tableYou execute the following command:SET UNUSED (country);A) A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.C) Unique key constraints defined on the COUNTRY column are removed.E) Views created ...【阅读全文】
unix_5359 | 2019-03-04 14:35:16 | 阅读(260) | 评论(0)
You need to create a table with the following column specifications:2. Employee Name (character data type) that stores the employee name4. Status (character data type), that contains the value 'ACTIVE' if no data is enteredWhich is the correct syntax to create this table?(emp_id NU...【阅读全文】
unix_5359 | 2019-03-04 13:58:40 | 阅读(250) | 评论(0)
Which statement is true regarding the SESSION_PRIVS dictionary view?B) It contains the system privileges granted to other users by the current user session.D) It contains the current object privileges available in the user session.(解析:SESSION_PRIVS 查看的是该当前会话所有的系统权限。...【阅读全文】
unix_5359 | 2019-03-04 13:17:14 | 阅读(420) | 评论(0)
View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.You executed the following SQL statement:FROM order_itemsNATURAL JOIN orders;A) The statement would not execute because the WHERE clause is before the NATURAL JOIN clause.C) The statement would exec...【阅读全文】
unix_5359 | 2019-03-04 11:28:27 | 阅读(250) | 评论(0)
Examine the command to create the BOOKS table.(book_id CHAR(6) PRIMARY KEY,publisher_id VARCHAR2(4),The BOOK_ID value 101 does not exist in the table.SQL> INSERT INTO books(BOOK_ID, TITLE, AUTHOR_ID)Which statement is true?B) It executes successfully only if NULL is explici...【阅读全文】
unix_5359 | 2019-02-28 11:35:19 | 阅读(410) | 评论(0)
You need to calculate the number of days from 1st January 2007 till date.Which two SQL statements would give the required output?B) SELECT SYSDATE - TO_DATE ('01/JANUARY/2007') FROM DUAL;D) SELECT SYSDATE - TO_DATE ('01-JANUARY-2007') FROM DUAL;Answer:BD数据时,会实现隐式转换。...【阅读全文】
unix_5359 | 2019-02-28 10:14:47 | 阅读(450) | 评论(0)
Examine the data in the CUST_NAME column of the CUSTOMERS table.----------------------Renske LadwigJason Mallinplace of the first name as follows:-----------------------**** Manuel UrmanA) SELECT LPAD(SUBSTR(cust_name,INSTR(cust_name,' ')),LENGTH(cust_name),'*') "CUST N...【阅读全文】