database

#338

[Oracle] Configure ODBC Client

Download Instant Clients Version 11.2.0.1.0 from Oracle WebSite (http://www.oracle.com/technetwork/topics/winsoft-085727.html) instantclient-basic instantclient-odbc Extract both ZIP in the same directory. Run odbc_install.exe Define following Env. properties : ORACLE_PATH=c:\path\to\instantclient_11_2 TNS_ADMIN=%ORACLE_PATH% add “;%ORACLE_PATH%” to the PATH variable Create TNSNAMES.ORA file in the %ORACLE_PATH% referencing database(s) example:

database, oracle, windows

#308

[Oracle] Create new user/schema

Olivier | Config, Tips | 1

Create simple tablespace : Create user/schema : Change grants :

database, oracle

#216

[Oracle] Enable partitions

Olivier | Config

Check if partitionning is enabled or not : To enable partition feature : On Solaris, ‘make’ could be installed using following packages : make libgcc libintl libiconv libintl-3.4.0-sol10-x86-local make-3.82-sol10-x86-local libiconv-1.14-sol10-x86-local libgcc-3.3-sol10-intel-local

Databae, database, linux, oracle, solaris