oracle 数据字典视图之 DICT / DICTIONARY
1.当你猛然间忘记通过什么视图可以查看procedure内容时，隐约记得所需的视图包含“SOUR”字段，此时查询dict/dictionary视图是最好的选择
sys@ora10g> col COMMENTS for a78
sys@ora10g>select * from dict where TABLE_NAME like '%SOUR%';
TABLE_NAME COMMENTS
------------------------------ -----------------------------------------------------------
USER_RESOURCE_LIMITS Display resource limit of the user
ALL_SOURCE_TABLES Source tables available for Change Data Capture
DBA_SOURCE_TABLES Source tables available for Change Data Capture
USER_SOURCE_TABLES Source tables available for Change Data Capture
USER_SOURCE Source of stored objects accessible to the user
ALL_SOURCE Current source on stored objects that user is allowed to create
DBA_SOURCE Source of all stored objects in the database
DBA_TSM_SOURCE Transparent session migration source session statistics
DBA_HIST_RESOURCE_LIMIT Resource Limit Historical Statistics Information
DBA_RESOURCE_INCARNATIONS Resource incarnations that are running or eligible for HA status notification
RESOURCE_C
相关文档：
刚才在EYGLE的博客中看到一篇帖子，讲的是DELETE的操作流程，很简短，同时也精辟。
===================================================================================
Oracle中，一个Delete操作的流程
删除(DELETE)
1.Oracle读Block到Buffer Cache(如果该Block在Buffer中不存在)
2.在redo log buffer中记录delet ......
一次奇怪的数据库启动和关闭经历。
SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> conn / as sysdba
Co ......
在oracle中调用java程序,注意:java方法必须是static类型的,如果想在JAVA中使用system.out/err输出log.
需要在oracle 中执行"call dbms_java.set_output(5000);".
一、helloWord
1 编写JAVA程序,也是在SQL/PLUS中写,并执行.
create or replace and compile java source named hello as
public ......
创建临时表空间
创建临时表空间
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
创建用户表空间
创建用户表空间
CREATE TABLESPACE test_data
LOGGING ......
