edwards0307
- 浏览: 26001 次
- 性别:
- 来自: 北京
-
最新评论
文章列表
Data Integirty
- 博客分类：
- oracle
1.Constraints
type: Not null ,PK,FK,Check,Unique
SQL> create table mm( 2 id number constraint con_pk primary key, 3 name char(10) not null, 4 uniqueid number unique, 5 sal number check(sal>100));
alter table mm modify name not null;
alter table mm add primary key(id) ...
Temporary Tablespaces: (sort segments and temp table data segments)
1.contains transient data that persists only for the duration of the session.
2.improve the concurrency of multiple sort operations, reduce their overhead, and avoid Oracle Database space management o ...
Today, I learned Temporary Table, I encountered for ORA-25153: Temporary Tablespace is Empty
Following Step:
1.create global temporary table tt(id number,name varchar2(10));
2.insert into tt values(1,'lsh');
ORA-25153: Temporary Tablespace is Empty
3.I check the temp ...
Temporary Segments
- 博客分类：
- oracle
Temporary Segments: including Temporary Segments for Queries and Temporary Tables and Indexes
Allocation of Temporary Segments for Queries(sort segments)
One or more temporary tablespaces can be used only for sort segments. A temporary tablespace is not the same as a tablespace that a user d ...
1.method of loading
Conventional path: employ SQL inserts on our behalf to load data.
Direct path: does not use SQL in this mode; it formats database blocks directly.
The direct path load allows you to read data from a flat file and write it directly to format-ted databas ...
1.concepts about DS and SS
DS:Oracle will create a new process for me when I log in. This is commonlyreferred to as the dedicated server configuration, since a server process will be dedicated to mefor the life of my session.
One client process mapping to One DS process
...