ORACLE

[ The imperialist Japanese military must officially acknowledge and apologize for the coercion of young women into sexual slaves. / 幼い女性を性の奴隷にした帝國主義日本軍の?制性を公式に認め、謝罪しなければならない. ]

사용자

ID:
PW:

INDEX

01.게시판

게시판 [72]

02.File Book

		File 자료실 [96]
		Site Link [14]
		개인폴더 [201]

03.Field Book

		Altibase [19]
		Tibero [31]
		MS-SQL [32]
		MySQL [47]
		DB2 [79]
		ORACLE [3202]
		PSQL [143]
		CUBRID [5]
		기타정보 [194]
		운영체제 [634]

04.Q/A Book

Q/A [53]

05.방명록

		방명록 [54]
		레벨업 [37]
		구인/구직 [2]

기념일

LINK

+ 가족 Hompy
+ DNSEver

IOTN :: Field Book :: ORACLE

회원가입

10g, 12c, 19c upgrade filename /dev/raw -> /oradata/ -> +DATA/ [ awr 추가 update ]

최길호 [LIST]

2021-09-19 02:34:42, 조회 : 687

-- awrp 10g, 12c 제거

select host_name||' '||version from DBA_HIST_DATABASE_INSTANCE;

delete DBA_HIST_DATABASE_INSTANCE where version not in ('19.0.0.0.0');

-- awr filename update

update DBA_HIST_DATAFILE set filename =

(select file_name from dba_data_files where file_id=file#);

-- awr tempfile [ temp 데이터 있는거만 찾아서 저장 되면 나중에 자동 정리 될지도... ]

delete DBA_HIST_TEMPFILE;

insert into WRH$_TEMPFILE

select (select max(snap_id) from DBA_HIST_SNAPSHOT),(select dbid from v$database),FILE#,CREATION_CHANGE#,NAME,TS#,'TEMP',8192,(select dbid from v$database),0

from v$tempfile;

-- or

delete DBA_HIST_TEMPFILE where not exists ( select 1 from dba_temp_files where file_id=file#);

update DBA_HIST_TEMPFILE set FILENAME=(select file_name from dba_temp_files where file_id=file#);



commit;

216.73.216.248

LIST

	제목	작성자	작성일	조회
Admin	KO16MSWIN949 to AL32UTF8 CLOB exp/imp 한글 TEST	최길호	2024/06/30	131
Admin	IMP-00017: following statement failed with ORACLE error 2304:	최길호	2024/06/28	132
Admin	dba_audit_trail = sys.aud$ dba_fga_audit_trail = sys.fga_log$ delete where sysdate -(365*5)	최길호	2024/06/27	107
Oracle GoldenGate	OGG-00423 OGG-03533	최길호	2024/06/26	86
Oracle GoldenGate	logdump filter / x ls / count log	최길호	2024/06/26	102
Admin	sys_guid json_object json_array / indextype is ctxsys.context	최길호	2024/06/25	164
Admin	recover copy of database / change copy of database uncatalog; / list copy	최길호	2024/06/22	104
Admin	create blockchain table / 19.10 이상 부터 가능 / ORA-05715	최길호	2024/06/21	151
Admin	create proxy users	최길호	2024/06/21	97
Admin	remote_os_authent=true / create user ops$oracle identified externally ;	최길호	2024/06/21	113
Oracle GoldenGate	logdump reclen env sfet sfnt count filter save	최길호	2024/06/20	67
Oracle GoldenGate	OGG-15161	최길호	2024/06/20	127
Backup and Recovery	RMAN-06053: unable to perform media recovery because of missing log	최길호	2024/06/15	69
Oracle GoldenGate	Replicate data using Oracle Cloud Infrastructure GoldenGate [ Memo ]	최길호	2024/06/12	104
Pro*C	proc test.pc Syntax error at line 185, column 45, file /usr/include/sys/cdefs.h	최길호	2024/06/10	95
Oracle GoldenGate	Oracle GoldenGate matrix and lastest patch	최길호	2024/06/10	87
Backup and Recovery	ORA-01207	최길호	2024/06/10	72
Install and Config	Linux 9 Oracle 10.2 [ 설치 불가 / 퍼와서 운영 가능 / 장애시 책임 없지만 보통 잘된다. ]	최길호	2024/06/07	80