BLOG main image
Google
분류 전체보기 (26)
Book (1)
Tech (22)
Life (2)
뉴스를 위한 감사합니다…
2008 - nude women websites
정보를 위한 감사합니다.
2008 - bikini malfunction
여보세요, 좋은 아주 위치!
2008 - asian teens underground
유용한 정보. 좋은 디자인.
2008 - lander girls basketball regionals
중대한 축하!경이롭 위치 위치!
2008 - saab leather
많은 감사 우수한 위치! 나는 너..
2008 - group realty wisconsin
좋은 위치! 너를 감사하십시요.
2008 - adult genre mature
중대하고 유용한 위치!
2008 - biscuit dog homemade recipe
나의 친구는 너의 위치의 현재..
2008 - bbw sexy foot
아주 재미있는 지점. 감사.
2008 - free tit
10,032 Visitors up to today!
Today 0 hit, Yesterday 1 hit
daisy rss
tistory 티스토리 가입하기!
2008/09/22 16:06

create undo tablespace undotbs2 datafile '/<path>/undotbs02.dbf' size 2000M ;
ALTER SYSTEM SET UNDO_TABLESPACE = undotbs2 scope=both;

select

tablespace_name, contents, extent_management

from dba_tablespaces where contents = 'UNDO';

select segment_name, tablespace_name, status from dba_rollback_segs order by 2;

drop tablespace undotbs1;

이올린에 북마크하기(0) 이올린에 추천하기(0)
Trackback Address :: http://sowhat.tistory.com/trackback/43 관련글 쓰기
Name
Password
Homepage
Secret
2008/09/22 15:29
UPDATE a
  SET <update target column of a> = <value>
 FROM 
  <update target table> a, 
  <join target table > b
 where
  a.<column> = b.<column>;

ps.

In Oracle

update table a
set column = (select value from table b where a.<column> = b.<column>)
where
<boundary condition>;
이올린에 북마크하기(0) 이올린에 추천하기(0)
Trackback Address :: http://sowhat.tistory.com/trackback/42 관련글 쓰기
Name
Password
Homepage
Secret
2008/04/10 08:31

1. oinstall, dba, oper 그룹추가
  - groupadd oinstall
  - groupadd dba
  - groupadd oper

2. oracle 유저 추가
  - useradd -g oinstall -G dba,oper oracle

3. 시스템 환경 변수 수정 및 reboot
* /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Note: Include lines only for the kernel parameter values that you
want to change. For the semaphore parameters (kernel.sem), you
must specify all four values. However, if any of the current values
are larger than the recommended value, then specify the larger
value.

* /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

* /etc/pam.d/login
session required pam_limits.so

4. ORACLE_BASE, ORACLE_HOME, mount_point 생성
# mkdir -p /mount_point/app/oracle_sw_owner
# chown -R oracle:oinstall /mount_point/app/oracle_sw_owner
# chmod -R 775 /mount_point/app/oracle_sw_owner

5. 사용하고자 할 response 파일 수정
Response File Description
* enterprise.rsp  - Enterprise Edition installation of Oracle Database 10g
* standard.rsp    - Standard Edition installation of Oracle Database 10g
* custom.rsp      - Custom installation of Oracle Database 10g
* dbca.rsp         - Database Configuration Assistant
* netca.rsp        - Oracle Net Configuration Assistant
* emca.rsp        - Enterprise Manager Configuration Assistant

6. 설치 시작
<설치파일 위치>/runInstaller.sh -silent -responseFile <rsp File full path>

이올린에 북마크하기(0) 이올린에 추천하기(0)
Trackback Address :: http://sowhat.tistory.com/trackback/25 관련글 쓰기
nude women websites | 2008/05/23 05:28 | PERMALINK | EDIT/DEL | REPLY
뉴스를 위한 감사합니다…
Name
Password
Homepage
Secret
prev"" #1 #2 #3 #4 #5 ... #9 next