Just another Code Snippet site
#338
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:
#308
Create simple tablespace : Create user/schema : Change grants :
#288
If the file is not present anymore, use this command before DROP statement :
#286
List current files : Remove file : Add new file :
#276
To create a new DB on an existing instance :
#259
#256
To raise a custom exception : To retrieve current Error Code/Message : SQLERRM(SQLCODE)
#241
#238
Creating a MV : Refreshing manualy a MV : Stats can be calcultated on MV like on table (cf Related Links)
#236
Create Function based index : (b-tree) example :