ITeye博客

killdbs

edwards0307 · 共 36 篇文章

Data Integirty

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); alter table mm add unique(name…

2011-12-01 17:47 · oracle · 评论(0)

Temporary Tablespace and Temporary Table

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 operations. 3.A temporary tables…

2011-11-30 14:40 · oracle · 评论(0)

ORA-25153: Temporary Tablespace is Empty

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 tablespace of the current user,…

2011-11-29 17:22 · oracle · 评论(0)

Temporary Segments

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 designat…

2011-11-29 15:52 · oracle · 评论(0)

oracle loading and unloading

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 database blocks, bypassing the en…

2011-11-29 14:13 · oracle · 评论(0)

Dedicated Server and Shared Server

1.concepts about DS and SS DS:Oracle will create a new process for me when I log in. This is commonly referred to as the dedicated server configuration, since a server process will be dedicated to me for the life of my session. One client process mapping to One DS process datafiles client----- DS s…

2011-11-17 18:00 · oracle · 评论(0)