ORACLE

IOTN :: Field Book :: ORACLE

회원가입

alter table add column large table [ 11gR2 부터 빠르다 ]

최길호 [LIST]

2021-09-29 17:53:16, 조회 : 261

 http://www.dba-oracle.com/t_alter_table_add_column_default_value_performance.htm

11gR2 부터 빠르다.

It stores the default value only in data dictionary instead of updating each physical row.



alter table fred add column new_col default value 'hello' not null';



Oracle 11.2.0.4 

기존 데이터 추가된 컬럼 값들은 null , 새로 들어가는 데이터만 default 값 적용 받는다 [ alter는 빠르다 ]

18.207.157.152

LIST

	제목	작성자	작성일	조회
Install and Config	ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk	최길호	2021/10/07	288
Troubleshoot	sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found	최길호	2021/10/06	692
Troubleshoot	19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9	최길호	2021/10/05	889
Troubleshoot	ORA-12609: TNS: Receive timeout occurred	최길호	2021/10/03	1009
Troubleshoot	EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp	최길호	2021/10/02	796
Troubleshoot	grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축	최길호	2021/10/01	834
Troubleshoot	ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT	최길호	2021/09/30	277
Admin	alter table add column large table [ 11gR2 부터 빠르다 ]	최길호	2021/09/29	261
Troubleshoot	ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1	최길호	2021/09/29	487
Troubleshoot	alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk	최길호	2021/09/28	3970
Install and Config	create diskgroup data1 normal redundancy failgroup fg1 disk	최길호	2021/09/28	311
Troubleshoot	[INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.	최길호	2021/09/28	292
Troubleshoot	PRVG-11095 : The TCP system call "connect" failed with error "113"	최길호	2021/09/28	342
Troubleshoot	ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]	최길호	2021/09/25	346
Install and Config	ORA-24247: network access denied by access control list (ACL)	최길호	2021/09/24	315
Troubleshoot	ORA-12805 Parallel Query Server Died	최길호	2021/09/23	370

목록보기 이전페이지 다음페이지

[1][2][3][4][5][6] 7 [8][9][10]..[145] [다음 10개]

http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]