By Rupert
Oracle: Creating a MultiLingual Database
Notes on to create a multilingual database in UTF8 in Oracle10g.
1. Run the Oracle Database Configuration Assistant (DBCA)
2. Choose Create Database
3. Choose “General Purpose”.
4. Then specify the GLOBAL DATABASE NAME or ORACLE SID (orcl4)
5. Click Next on Management Options.
6. On “Database Credentials”, use the same passwords so we would not forget them for now…
7. On “Storage Options”. Default options is FILE STORAGE. Next.
8. On “Database File Locations”, hit Next as well.
9. On “Recover Options”, same goes here.. Next.
10. On “Database Content”, install the sample schemas for practice.
11. On “Initialization Parameters”, click on the “Character Sets” tab. Note that we chose the 2nd option which is “Use Unicode” (ALT32UTF8) in order to support chinese. On the National Character Set, please choose “UTF8″ (the 2nd option in the drop-down list”) also.
12. Hit Next until we create the database.
13. To check you should have the Oracle Services installed in your Services.
| Print article | This entry was posted by rupert on August 19, 2008 at 2:47 pm, and is filed under oracle. Follow any responses to this post through RSS 2.0. You can skip to the end and leave a response. Pinging is currently not allowed. |
No comments yet.
iPhone Note #8: Exporting Oracle to SQLite3
about 11 months ago - No comments
Since I’ve been working most of my time with iPhone Dev for the last couple of months, I thought it will be worthwile to post how to import files to SQLite3. In a nutshell, use MesaSQLite’s IMPORT function. It will save you a lot of time. Now it is up to you how to export
Two Oracle Homes in one Machine
about 1 year ago - No comments
I’ve been toggling back and forth two different oracle homes by editing the environment variables from the Control Panel in Windows which is a pain in the ***. What I did was, to create two different command prompt shells with different oracle home environments. I got this idea after a glimpse from FWTools. 1. Create
Rails Note #13: RubyonRails + Oracle on Linux (i386 / x64)
about 1 year ago - No comments
In summary, install Oracle Instant Client and try to run sqlplus. If sqlplus connects to the oracle sid then go ahead and install the rails adapters for oracle. What is important to note here, is to install the oracle-instantclient for the architecture of your machine.. I have tested this on Debian Lenny (i386) and CentOS5
Rails Note #12: Oracle on Intel Mac
about 1 year ago - 1 comment
1. Read http://www.foliosus.com/2008/05/05/connecting-ruby-on-rails-to-oracle-on-an-intel-mac-in-leopard-take-2/ 2. Install Oracle Instant Client on Mac. a. Instant Client Package – Basic: All files required to run OCI, OCCI, and JDBC-OCI applications – instantclient-basic-macosx-10.2.0.4.0.zip (34,020,719 bytes) b. *Instant Client Package – SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client instantclient-sdk-macosx-10.2.0.4.0.zip (603,493 bytes) OR download
Oracle Spatial Tutorial Screencasts
about 1 year ago - No comments
This is the first time I ever did a screencast and it was a lot of fun! Please do forgive me as my voice was horrible. I used iShowU and keyCaster. Google it! I hope you guys enjoyed it..as much as I did.. oracle_spatial_1.mov oracle_spatial_2.mov
How to make Oracle start on boot
about 1 year ago - No comments
1. Login as root and edit /etc/oratab to reflect “Y” orcl:/opt/oracle/product/11.1.0/db_1:Y 2. oracle startup script: #!/bin/bash # # oracle Init file for starting and stopping # Oracle Database. Script is valid for 10g and 11g versions. # # chkconfig: 35 80 30 # description: Oracle Database startup script # Source function library. .
Oracle Tuning Tools
about 1 year ago - No comments
EXPLAIN PLAN 1. Create the PLAN_TABLE SQL> $ORACLE_HOME/rdbms/admin/utlxplan.sql 2. Run EXPLAIN PLAN for an SQL SQL> EXPLAIN PLAN 2 SET STATEMENT_ID = ‘example’ FOR 3 SELECT ename,dname 4 FROM emp inner join dept 5 ON ( emp.deptno = dept.deptno ) 6 / Explained. 3. DISPLAY Results SQL> $ORACLE_HOME/rdbms/admin/utlxpls.sql AUTOTRACE is a SQL*Plus facility that may
Tutorials Updated for Oracle
about 1 year ago - No comments
It was a gruesome day.. I have an oracle10g on my MacBookPro running on VMWare (WindowsXPSP3, let’s call this orawin). I have another setup box (CentOS5 + oracle11g = oralin) just this morning. I imported the tables from my orawin10g to my oralin11g, created the indexes for the tables in oralin11g. I ran my spatial
Oracle SQL CheatSheet
about 1 year ago - 1 comment
References: Comparison of different SQL implementations Oracle DataTypes Part 1: Oracle Misc Information *Oracle Services Running on Windows? * How to create a user? CREATE USER "APPDEV" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK GRANT UNLIMITED TABLESPACE TO "APPDEV"; GRANT "CONNECT" TO "APPDEV"; GRANT "RESOURCE" TO "APPDEV"; * How
Using SDO_WITHIN_GEOM
about 1 year ago - No comments
Experiment 1: Two POIs SELECT p1.poi_id, p1.en_name, p1.py_fullpoiadd, p1.py_rdname, p2.poi_id, p2.en_name, p2.py_fullpoiadd, p2.py_rdname, SDO_GEOM.SDO_DISTANCE(p1.geom, p2.geom, 0.5) AS dist FROM poi_test p1, poi_test p2 WHERE Upper(p1.en_name) LIKE ‘%PARKSON%’ AND Upper(p2.en_name) LIKE ‘%KFC%’ AND SDO_WITHIN_DISTANCE(p1.geom, p2.geom, ‘DISTANCE=500 UNIT=METER’ )=’TRUE’ ORDER BY dist Experiment 2: Road + Two POIs SELECT p1.poi_id, p1.en_name, p1.py_fullpoiadd, p1.py_rdname, p2.poi_id, p2.en_name, p2.py_fullpoiadd, p2.py_rdname,