BioHackersNet|
Size: 1223
Comment:
|
Size: 1452
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| * [http://www.oracleclub.com/profile/OracleFirst.jsp 오라클공부를 처음 시작하시는 분들께...] | |
| Line 6: | Line 7: |
| [Python] interface * DCOracle2 : http://www.zope.org/Members/matt/dco2 * cx_oracle : http://www.computronix.com/utilities.shtml |
[Python]으로 연동하여 쓸 경우, [cx_Oracle] 사용. |
| Line 10: | Line 9: |
| == 특징 == 1. WikiPedia:Tablespace == 사용 팁 == Oracle 시작과 종료 {{{ # su - oracle $ export ORACLE_SID=ORANLRI $ sqlplus "/as sysdba" > startup > exit }}} ---- |
가장 널리 알려진 상업용 RelationalDatabase Management System
관련정보
[http://www.puschitz.com/InstallingOracle9i.shtml installing 9i on redhat7]
[http://www.oracleclub.com/profile/OracleFirst.jsp 오라클공부를 처음 시작하시는 분들께...]
[Python]으로 연동하여 쓸 경우, [cx_Oracle] 사용.
특징
사용 팁
Oracle 시작과 종료
# su - oracle $ export ORACLE_SID=ORANLRI $ sqlplus "/as sysdba" > startup > exit
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