- 博客(20)
- 资源 (3)
- 问答 (1)
- 收藏
- 关注
原创 EXP-00068
连接到: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the OLAP and Oracle Data Mining optionsJServer Release 9.2.0.6.0 - Production已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集
2014-06-30 10:46:23 1313
原创 privs与roles
SQL> create user a identified by a default tablespace users;User created.SQL> create user b identified by a default tablespace users;User created.SQL> create user c identified by a default
2014-06-26 20:15:27 681
转载 列值为null相关知识
39. View the Exhibit and examine the description of the PRODUCT_INFORMATION table.Which SQL statement would retrieve(检索) from the table the number of products having LIST_PRICE as NULL?比较null值用is
2014-06-26 19:23:47 694
原创 EXP-00008: ORACLE error 904 encountered
C:\Users\Administrator>exp huang1/huang1@redhat tables=t file=c:\exp.dmpExport: Release 11.2.0.1.0 - Production on Thu Jun 26 11:34:33 2014Copyright (c) 1982, 2009, Oracle and/or its affil
2014-06-26 12:02:28 1580
原创 ORA-12545: Connect failed because target host or object does not exist
[oracle@ybdbtest oradata]$ sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Thu Jun 26 10:16:29 2014Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> c
2014-06-26 11:57:57 10013
转载 ocp-047-30 timestamp with local time zone 和timesatamp with time zone
30. You need to create a table for a banking application with the following considerations: 1) You want a column in the table to store the duration of the credit period. 2) The data in the colum
2014-06-24 23:46:13 743
转载 ocp-047-29 子查询
29. A non-correlated subquery can be defined as ____. A. a set of sequential queries, all of which must always returna single value B. a set of sequential queries, all of which must return valuesf
2014-06-24 23:08:03 652
原创 maxdatafiles 与db_files
MAXDATAFILES:The MAXDATAFILES option of CREATE DATABASE determines the number of data files a database can have. With Oracle Real Application Clusters, databases tend to have more data files and
2014-06-23 22:49:48 645
转载 ALTER SYSTEM KILL SESSION
一个用户进程偶尔会挂起或占用过多资源而拒绝其它会话。如果DBA依然能够访问数据库,她通常可以发出以下查询:
2014-06-23 11:45:54 1347
原创 OBJECT_ID、DATA_OBJECT_ID与truncate的本质
OBJECT_ID和DATA_OBJECT_ID可以这样区别:OBJECT_ID可以看做是对象的一个逻辑ID,在对象创建时分配,一经分配即不再改变;而DATA_OBJECT_ID则是一个物理ID,在对象存储发生变化时可能会发生改变。
2014-06-22 22:01:53 673
转载 EM daemon is not running
文章laizOracle 10G第二版,Win XP SP2问题是刚安装好的Oracle企业管理器(EM)无法使用,启动是一切正常,但是登入企业管理器页面后有个错误“Error:Java.lang.Exception Exception in sending Request null”,数据库状态显示未知。emctl status dbconsole 查看状态显示EM da
2014-06-21 23:47:44 1986
原创 TNS-12541: TNS: 无监听程序
C:\Users\Administrator>tnsping redhatTNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 14-6月 -2014 21:56:20Copyright (c) 1997, 2010, Oracle. All rights reserved.已使用的参数文件:
2014-06-14 22:28:32 828
原创 remote_os_authent
SQL> show parameter os_NAME TYPE VALUE------------------------------------ ----------- ------------------------------optimizer_index_cost_adj
2014-06-12 14:36:42 680
原创 temp表空间与tempfile
SQL> alter tablespace temp read only;alter tablespace temp read only*ERROR at line 1:ORA-03217: invalid option for alter of TEMPORARY TABLESPACESQL> alter tablespace temp offline;a
2014-06-06 11:51:26 827
转载 db_block_checking与db_block_checksum
文章来自:http://blog.csdn.net/leshami/article/details/6628679 db_block_checking与db_block_checksum两个参数都是对block进行检查,然而两者很容易混淆。事实上,两个参数中前者是对块做逻辑性检查,后者则是做物理性检查。两者各司其职,并不矛盾。下面分别给出具体描述。1.db_bl
2014-06-04 21:48:54 448
原创 系统shedule
告警日志里面baoErrors in file /usr/oracle/admin/szyth/bdump/szyth_j001_22675616.trc:ORA-12012: error on auto execute of job 8898ORA-00376: file ORA-00376: file 15 cannot be read at this timeORA-0111
2014-06-04 16:27:02 621
转载 Oracle中JOB的创建方法以及一个细节的探究
在Oracle中可以使用JOB来实现一些任务的自动化执行,类似于UNIX操作系统crontab命令的功能。简单演示一下,供参考。1.创建表T,包含一个X字段,定义为日期类型,方便后面的定时任务测试。sec@ora10g> create table t (x date);Table created.2.创建存储过程p_insert_into_t,每次执行该存储过程都会
2014-06-04 13:22:32 474
转载 oracle中关于时区的一些资料
1. How to check the session time zone ?=======================================Answer------The new SESSIONTIMEZONE built-in SQL function returns the value of the currentsession's time zone.
2014-06-03 15:55:00 1144
oracle 11.2.0.1升级到11.2.0.4
2015-02-05
TA创建的收藏夹 TA关注的收藏夹
TA关注的人