Menu ▾ ▴

Tree [r69] /
 History

HTTPS svn://
HTTPS access

File Date Author Commit
 ORASVN.ALL_OBJECTS_V.VIEW 2010-12-21 ckindler [r30] init
 ORASVN.CC.PACKAGE 2010-12-31 ckindler [r58]
 ORASVN.CC.PACKAGE_BODY 2010-12-31 ckindler [r59]
 ORASVN.CLOB_CURSOR.PACKAGE 2010-12-21 ckindler [r22] init
 ORASVN.CLOB_CURSOR.PACKAGE_BODY 2010-12-21 ckindler [r1] init
 ORASVN.CMD.PACKAGE 2010-12-21 ckindler [r4] init
 ORASVN.CMD.PACKAGE_BODY 2011-01-03 ckindler [r65] solved the chicken-and-egg problem with c source
 ORASVN.COMMANDS.TABLE 2010-12-21 ckindler [r6] init
 ORASVN.COMMANDS.TABLE_DATA 2010-12-21 ckindler [r24] init
 ORASVN.COMMANDS_UI.INDEX 2010-12-21 ckindler [r7] init
 ORASVN.CSOURCE.TABLE 2010-12-31 ckindler [r60]
 ORASVN.EXTPROCSHELL_LIB.LIBRARY 2010-12-30 ckindler [r54]
 ORASVN.GETARGUMENTS.FUNCTION 2010-12-21 ckindler [r9] init
 ORASVN.GETBITS.FUNCTION 2010-12-21 ckindler [r28] init
 ORASVN.GETCDDL.FUNCTION 2011-01-03 ckindler [r65] solved the chicken-and-egg problem with c source
 ORASVN.GETCOMMAND.FUNCTION 2010-12-21 ckindler [r8] init
 ORASVN.GETPATH.FUNCTION 2010-12-21 ckindler [r10] init
 ORASVN.GETPATHSEPERATOR.FUNCTION 2010-12-21 ckindler [r11] init
 ORASVN.GETTABLEDATASQL.FUNCTION 2010-12-21 ckindler [r23] init
 ORASVN.ISWIN.FUNCTION 2010-12-21 ckindler [r27] init
 ORASVN.ORASVN.USER 2010-12-30 ckindler [r52]
 ORASVN.ORASVN.USER_GRANTS 2011-01-19 ckindler [r69] solved some trigger schema export issues
 ORASVN.PROJECTS.TABLE 2010-12-21 ckindler [r12] init
 ORASVN.PROJECTS.TABLE_DATA 2010-12-31 ckindler [r61]
 ORASVN.SHELL.FUNCTION 2010-12-21 ckindler [r21] init
 ORASVN.SOURCES.TABLE 2010-12-21 ckindler [r16] init
 ORASVN.SOURCES.TABLE_DATA 2011-01-03 ckindler [r65] solved the chicken-and-egg problem with c source
 ORASVN.SOURCES_UI.INDEX 2010-12-21 ckindler [r17] init
 ORASVN.SRC_SEQ_V.VIEW 2010-12-30 ckindler [r55]
 ORASVN.SVN.PACKAGE 2010-12-31 ckindler [r56]
 ORASVN.SVN.PACKAGE_BODY 2011-01-19 ckindler [r69] solved some trigger schema export issues
 ORASVN.SVN_FILE.PACKAGE 2010-12-21 ckindler [r2] init
 ORASVN.SVN_FILE.PACKAGE_BODY 2010-12-21 ckindler [r3] init
 ORASVN.SVN_SOURCES_V.VIEW 2010-12-21 ckindler [r36] init
 ORASVN.SYS_C004154.CONSTRAINT 2010-12-21 ckindler [r32] init
 ORASVN.SYS_C004154.INDEX 2010-12-21 ckindler [r13] init
 ORASVN.SYS_C004156.REF_CONSTRAINT 2010-12-21 ckindler [r31] init
 ORASVN.SYS_C004205.CONSTRAINT 2010-12-21 ckindler [r33] init
 ORASVN.extprocshell.C 2011-01-03 ckindler [r65] solved the chicken-and-egg problem with c source
 PUBLIC.ALL_OBJECTS_V.SYNONYM 2010-12-21 ckindler [r40] init
 PUBLIC.SVN.SYNONYM 2010-12-21 ckindler [r41] init
 PUBLIC.SVN_SOURCES_V.SYNONYM 2010-12-21 ckindler [r39] init
 Readme.txt 2011-01-03 ckindler [r66] solved the chicken-and-egg problem with c source
 install.sql 2011-01-03 ckindler [r65] solved the chicken-and-egg problem with c source
 licence.txt 2010-12-21 ckindler [r43] init

Read Me

Requirements:

Windows users have to do change the commands table data file and change the shell commands to dos equivalents. They also have to use the whole path to gcc and svn enclosed in ...

You need to have gcc installed (windows users use mingw)

 
You need to create the following directories on your Oracle-DB-Host OS (mkdir) and in the Database itself (create directory as ;). You may need root rights and you need the Oracle SYS password for sure. Linux/Unix Useres do not forget to chown the directories to oracle:dba.

SVN_SPOOL /var/spool/orasvn/cmd

SVN_PROJECTS /var/spool/orasvn/projects

Locate the File libqsmashr.so or .dll on Windows and add the directory path to your database:
ORACLE_LIB /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/

Locate the File oci.h and add the directory path to your database:
OCI_H /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/public/


Installation:
1 linux/unix users log in as oracle user!
2 Untar the archive
3 Change into the directory containing install.sql (orasvn_sf)
4 Log into sqlplus with sys as sysdba and issue the install.sql

 
Uninstall:
1 Drop the schema ORASVN
2 Remove the directories created previously


Quick Start:
1 Create a repository in your SVN

2 Add the repository to your Oracle project by issuing SVN.NEW_PROJECT NOTE! You cannot use subdirectories so pass as Url parameter your location of choice like http://xy/z/trunk/yourProject/src/rdbms/

3 Add the Oracle Source to your Project SVN.ADD_SRC. Optional you can use the all_objects_v view to migrate existing sources by calling SVN.ADD_SRC in a for-loop. You can also use the svn_sources_v view to see registered sources (Note: one source can be registered in several projects).

4 Commit changes in your Oracle objects by SVN.SPOOL_AND_COMMIT_SRC or do this for all your Sources registered with your project -> SVN.SPOOL_AND_COMMIT_SRC_ALL

5 Sync your databases by using SVN.UPDATE (tables will be altered if changed)

6 To deploy your project you can generate an install.sql file with SVN.GEN_INSATLL_SQL