Differences between revisions 3 and 5 (spanning 2 versions)
Revision 3 as of 2005-11-11 20:05:09
Size: 1783
Editor: 203
Comment:
Revision 5 as of 2007-02-06 08:37:36
Size: 5468
Editor: 219
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 관련질답]

----
일반적인 접속절차 및 인코딩변경
Line 59: Line 28:
> update sys.props$ set value$='UTF-8' where name='NLS_CHARACTERSET';  > update sys.props$ set value$='UTF-8' where name='NLS_CHARACTERSET';
Line 70: Line 39:
 [http://homepage.mac.com/absurd2/68.html webcam teenagers] | [http://homepage.mac.com/shy3/30.html webcam girl nude] | [http://homepage.mac.com/gongs1/31.html old faithful webcam] | [http://homepage.mac.com/subcranial/82.html teenage webcams] | [http://homepage.mac.com/corsica4/7.html webcam strip tease] | [http://homepage.mac.com/petrarchan/71.html stripping on webcam] | [http://homepage.mac.com/leitmotif1/35.html webcam links] | [http://homepage.mac.com/gruffer1/56.html live free webcam] | [http://homepage.mac.com/dybbuks/94.html sexy webcams] | [http://homepage.mac.com/woads/72.html teens webcam] | [http://homepage.mac.com/calibre2/40.html cam crush webcams] | [http://homepage.mac.com/dogtired1/53.html webcam private] | [http://homepage.mac.com/squarish/60.html webcam dancing] | [http://homepage.mac.com/squarish/14.html male webcams] | [http://homepage.mac.com/petrarchan/38.html webcam chicks] | [http://homepage.mac.com/squarish/42.html free webcam viewing] | [http://homepage.mac.com/petrarchan/21.html online webcam chat] | [http://homepage.mac.com/knob10/24.html wife with webcam] | [http://homepage.mac.com/entrenches/38.html video webcam] | [http://homepage.mac.com/bowlfuls/1.html my private webcam] | [http://homepage.mac.com/annealed/76.html alaska webcams] | [http://homepage.mac.com/gongs1/45.html webcam sex videos] | [http://homepage.mac.com/knob10/25.html wildlife live webcam] | [http://homepage.mac.com/petrarchan/72.html movies webcam swinger] | [http://homepage.mac.com/knob10/23.html streaming live webcam] | [http://homepage.mac.com/petrarchan/76.html bed webcam] | [http://homepage.mac.com/gongs1/95.html webcam flashers] | [http://homepage.mac.com/squarish/73.html old faithful webcam] | [http://homepage.mac.com/subcranial/72.html free webcam teen] | [http://homepage.mac.com/pericles4/60.html webcam fantasies] | [http://homepage.mac.com/bowlfuls/51.html webcam couples] | [http://homepage.mac.com/absurd2/44.html free adult webcam] | [http://homepage.mac.com/absurd2/79.html live webcams] | [http://homepage.mac.com/corsica4/25.html hot webcam strip] | [http://homepage.mac.com/entrenches/8.html girl webcam pics] | [http://homepage.mac.com/shy3/83.html webcam chicks] | [http://homepage.mac.com/bowlfuls/47.html webcam sexy] | [http://homepage.mac.com/entrenches/25.html webcams teen girls] | [http://homepage.mac.com/subcranial/30.html webcam free chat] | [http://homepage.mac.com/shy3/20.html personal webcams] | [http://homepage.mac.com/fagoting/75.html sexy webcams] | [http://homepage.mac.com/knob10/64.html cam crush webcams] | [http://homepage.mac.com/squarish/85.html webcam private] | [http://homepage.mac.com/bowlfuls/71.html webcam females] | [http://homepage.mac.com/dogtired1/86.html boy webcam] | [http://homepage.mac.com/allegation/54.html webcam girl strip] | [http://homepage.mac.com/petrarchan/51.html webcam dancing] | [http://homepage.mac.com/squarish/62.html free webcam hosting] | [http://homepage.mac.com/dogtired1/15.html unmonitored webcams] | [http://homepage.mac.com/gongs1/4.html free webcam chats] | [http://homepage.mac.com/leitmotif1/39.html college webcam] | [http://homepage.mac.com/absurd2/10.html free webcams] | [http://homepage.mac.com/absurd2/60.html free girls webcams] | [http://homepage.mac.com/entrenches/21.html shower webcam] | [http://homepage.mac.com/knob10/47.html free view webcams] | [http://homepage.mac.com/squarish/13.html webcam old faithful] | [http://homepage.mac.com/dybbuks/45.html homemade webcam video] | [http://homepage.mac.com/knob10/11.html amateur webcam] | [http://homepage.mac.com/knob10/6.html webcam orgasm] | [http://homepage.mac.com/gongs1/47.html hot teen webcam] | [http://homepage.mac.com/squarish/60.html webcam chat room] | [http://homepage.mac.com/subcranial/42.html webcam girl video] | [http://homepage.mac.com/annealed/30.html live webcam strip] | [http://homepage.mac.com/woads/86.html free naked webcams] | [http://homepage.mac.com/subcranial/6.html nude webcam chat] | [http://homepage.mac.com/squarish/56.html adult webcam sites] | [http://homepage.mac.com/fagoting/66.html webcam flash tits] | [http://homepage.mac.com/fagoting/93.html webcam reviews] | [http://homepage.mac.com/shy3/11.html manitoba webcam pictures]

가장 널리 알려진 상업용 RelationalDatabase Management System

관련정보

[Python] interface

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


CategoryProgram

Oracle (last edited 2012-12-03 16:09:15 by 182)

web biohackers.net