BioHackersNet|
Size: 1783
Comment:
|
Size: 1223
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 10: | Line 10: |
| CharacterSet변경문제 {{{ SQL> alter system enable restricted session; |
CharacterSet변경문제, 혹은 [http://database.sarang.net/?inc=read&aid=18388&criteria=oracle&subcrit=&id=&limit=20&keyword=character&page=3 관련질답] |
| Line 14: | Line 12: |
| System altered. SQL> alter system set job_queue_processes = 0; System altered. SQL> alter system set aq_tm_processes = 0; System altered. SQL> alter database open; Database altered. SQL> alter database character set WE8ISO8859P1; Database altered. SQL> select VALUE$ from PROPS$ where NAME = 'NLS_CHARACTERSET'; VALUE$ -------------------------------------------------------------------------------- WE8ISO8859P1 }}} 혹은 [http://database.sarang.net/?inc=read&aid=18388&criteria=oracle&subcrit=&id=&limit=20&keyword=character&page=3 관련질답] ---- 일반적인 접속절차 및 인코딩변경 |
가장 널리 알려진 상업용 RelationalDatabase Management System
관련정보
[http://www.puschitz.com/InstallingOracle9i.shtml installing 9i on redhat7]
[Python] interface
DCOracle2 : http://www.zope.org/Members/matt/dco2
cx_oracle : http://www.computronix.com/utilities.shtml
CharacterSet변경문제, 혹은 [http://database.sarang.net/?inc=read&aid=18388&criteria=oracle&subcrit=&id=&limit=20&keyword=character&page=3 관련질답]
# su - oracle $ export ORACLE_SID=sid $ echo $ORACLE_SID sid $ sqlplus /nolog > connect / as sysdba > shutdown > startup mount exclusive > alter database enable restricted session; > alter database set job_queue_processes = 0; > alter database open; > alter database character set internal_use utf8; > alter database national character set internal_use utf8; > select * from nls_database_parameters where parameter like '%CHARACTERSET%'; > update sys.props$ set value$='UTF-8' where name='NLS_CHARACTERSET'; > update sys.props$ set value$='UTF-8' where name='NLS_NCHAR_CHARACTERSET'; > update sys.props$ set value$='UTF-8' where name='NLS_LANGUAGE'; > commit; > shutdown immediate > startup > exit