# vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora ----------------------- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = owl)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /home/oracle/app/oracle ----------------------- # vi /etc/hosts ----------------------- 127.0.0.1 owl ----------------------- […]
oracle session Hint
select * from v$resource_limit where resource_name in ('processes','sessions');
oracle : move & relocate dbf datafile Hint
Manual Online SQL> SELECT name FROM v$datafile WHERE name LIKE '%test%'; SQL> ALTER TABLESPACE test OFFLINE NORMAL; SQL> HOST mv /oracle0/test0.dbf /oracle1/test1.dbf SQL> ALTER TABLESPACE test RENAME DATAFILE '/oracle0/test0.dbf' TO '/oracle1/test1.dbf'; SQL> ALTER TABLESPACE test ONLINE; SQL> SELECT name FROM v$datafile; SQL> SHUTDOWN IMMEDIATE Manual Offline SQL> HOST MOVE /oracle0/test0.dbf /oracle1/test1.dbf SQL> STARTUP MOUNT […]
oracle : the password has expried to unlimited Hint
Conn as sysdba $ sqlplus /nolog SQL> conn /as sysdba Change password first! SQL> ALTER USER [USERID] IDENTIFIED by [PASSWORD]; Check password life time SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; PROFILE RESOURCE_NAME RESOURCE ------------------------------ -------------------------------- -------- LIMIT ---------------------------------------- DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 Set password life time to […]
MySQL : Change Table Charset Hint
SELECT CCSA.character_set_name FROM information_schema.TABLES T, information_schema.COLLATION_CHARACTER_SET_APPLICABILITY CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "test_db" AND T.table_name = "test_tb"; ALTER TABLE test_tb CONVERT TO CHARACTER SET utf8;
oracle : change charset test => csscan
$ sqlplus /nolog SQL> conn /as sysdba SQL> @/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/csminst.sql $ csscan $ csscan Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on 일 9월 13 23:11:54 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: derp Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With […]
oracle : impdb : dbms_metadata_util
Import: Release 11.2.0.1.0 - Production on Thu May 28 06:46:52 2015 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available connect […]
oracle : ALTER DATABASE CHARACTER SET INTERNAL_USE
[oracle@owl110]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Thu May 28 06:38:32 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> SQL> SQL> conn /as sysdba Connected. SQL> SHUTDOWN IMMEDIATE; Database closed. Database dismounted. ORACLE instance shut down. SQL> STARTUP MOUNT; ORACLE instance started. Total System Global Area 6.3068E+10 bytes Fixed Size 2219392 bytes […]
MS ACCESS : SaveAttachments file
Option Compare Database Private Sub Command65_Click() If MsgBox("Confirm?", vbYesNo, "Confirm") = vbYes Then SaveAttachments "C:\Users\owl\Documents\pic\foldname", "tablename", "fieldname", "key_fieldname" Else End If End Sub Public Function SaveAttachments(strPath As String, strTable As String, strField As String, strKeyField As String, Optional strPattern As String = "*.*") As Long Dim dbs As DAO.Database Dim rst As DAO.Recordset2 Dim rsA […]
MySQL Join 관련 잘 정리한 정보
출처 : Rapapa Dev Story