omb101.blogspot.com
OMB+ 101: November 2011
http://omb101.blogspot.com/2011_11_01_archive.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Friday, November 11, 2011. OMB Get Repository Documentation. COMPILE OWB Repository #. Get the Repository documentation #. Output is written to file in RootDir #. C) Ciber Nederland John Minkjan OMB101.blogspot.com #. V001 Init Version #. V002 Validated against OWB11gR2 #. OMBCONNECT rep owner/rep owner@localhost:1521:orcl USE WORKSPACE 'My Workspace'. Set RootDir "C: temp ". Set ProjectList [OMBLIST PROJECTS];.
omb101.blogspot.com
OMB+ 101: February 2012
http://omb101.blogspot.com/2012_02_01_archive.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Friday, February 17, 2012. OMB single quote in tcl. The other day I was fighting to get a single quote, a double quote and a single qoute within a string. After trying a number of escape sequences David Allen handed me the solution on OTN:. Https:/ forums.oracle.com/forums/thread.jspa? Just use two single quotes for one . Wednesday, February 15, 2012. OMB OWB TCL Repair NULL. Set Expression OWB Repair NULL #.
omb101.blogspot.com
OMB+ 101: OMB OWB TCL Mapping set maximum number of errors
http://omb101.blogspot.com/2012/03/omb-owb-tcl-mapping-set-maximum-number.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Thursday, March 1, 2012. OMB OWB TCL Mapping set maximum number of errors. By default the maximum number of errors in a mapping is 50. Here is a script to change it to 0:. Change Maximum Number Of Errors #. C) Ciber Nederland John Minkjan #. Http: OMB101.blogspot.com #. V001 Init Version #. V002 Validated against OWB11gR2 #. Orignal idea: Borkur Steingrimsson #. OMBCONNECT OWB OWN/* * * @* * * * * *:1521:DWH A2.
omb101.blogspot.com
OMB+ 101: OMB+/OWB Revoke a privilege
http://omb101.blogspot.com/2012/05/ombowb-revoke-privilege.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Wednesday, May 2, 2012. OMB /OWB Revoke a privilege. OWB has the habbit of only revoking or granting priviliges ont creation of a role or object. If you change a role you have to manually change them. Here is a script to revoke privileges:. C) Ciber Nederland John Minkjan OMB101.blogspot.com #. V001 Init Version #. V002 Validated against OWB11gR2 #. Set OMBPROMPT ON;. Set RoleList [list EVERYONE].
omb101.blogspot.com
OMB+ 101: May 2012
http://omb101.blogspot.com/2012_05_01_archive.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Wednesday, May 2, 2012. OMB /OWB Revoke a privilege. OWB has the habbit of only revoking or granting priviliges ont creation of a role or object. If you change a role you have to manually change them. Here is a script to revoke privileges:. C) Ciber Nederland John Minkjan OMB101.blogspot.com #. V001 Init Version #. V002 Validated against OWB11gR2 #. Set OMBPROMPT ON;. Set RoleList [list EVERYONE]. Foreach OracleMo...
omb101.blogspot.com
OMB+ 101: OMB single quote in tcl
http://omb101.blogspot.com/2012/02/omb-single-quote-in-tcl.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Friday, February 17, 2012. OMB single quote in tcl. The other day I was fighting to get a single quote, a double quote and a single qoute within a string. After trying a number of escape sequences David Allen handed me the solution on OTN:. Https:/ forums.oracle.com/forums/thread.jspa? Just use two single quotes for one . Subscribe to: Post Comments (Atom). There was an error in this gadget. OBIEE This is the end?
omb101.blogspot.com
OMB+ 101: OMB OWB TCL Sorting table partitions
http://omb101.blogspot.com/2012/03/omb-owb-tcl-sorting-table-partitions.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Friday, March 16, 2012. OMB OWB TCL Sorting table partitions. When migrating from OWB10.1 to 11gR2 the partition order (sometimes) gets scrambeld and the table will not validate. This scripts sets the partitions back in (alphabetical) order . Sort Table Partitions #. Note: When migrating from OWB10.1 to 11gR2 the #. Partition order gets scrambeld and the table #. Will not validate #. V001 Init Version #. View my c...
omb101.blogspot.com
OMB+ 101: April 2012
http://omb101.blogspot.com/2012_04_01_archive.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Wednesday, April 25, 2012. OMB /OWB create, register, delete en unregister an OWB Location:. How to create, register, delete en unregister an OWB Location:. OMBCREATE LOCATION 'SH LOC'. BUSINESS NAME, DESCRIPTION, TYPE, VERSION, CONNECTION TYPE, USER NAME,HOST,PORT,SERVICE NAME). SH LOC','Sales History on localhost','ORACLE DATABASE', '11.2' , 'HOST PORT SERVICE','SH','localhost','1521','orcl.world');. 160; &...
omb101.blogspot.com
OMB+ 101: OWB/OMB+ connect to oracle database
http://omb101.blogspot.com/2012/04/owbomb-connect-to-oracle-database.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Tuesday, April 24, 2012. OWB/OMB connect to oracle database. Some handy function if you want to query an oracle database directly from OMB. Oracle DataBase Connection #. Functions to execute select statements on a #. Oracle DB using OMB / tcl #. C) Ciber Nederland John Minkjan OMB101.blogspot.com #. V001 Init Version #. V002 Validated against OWB11gR2 #. Based on orginal code from Michael Broughton aka ZEPPO.
omb101.blogspot.com
OMB+ 101: March 2012
http://omb101.blogspot.com/2012_03_01_archive.html
A Collection of all my OMB / tcl scripts to manage my OWB (Oracle Warehouse Builder) stuff. Friday, March 16, 2012. OMB OWB TCL Sorting table partitions. When migrating from OWB10.1 to 11gR2 the partition order (sometimes) gets scrambeld and the table will not validate. This scripts sets the partitions back in (alphabetical) order . Sort Table Partitions #. Note: When migrating from OWB10.1 to 11gR2 the #. Partition order gets scrambeld and the table #. Will not validate #. V001 Init Version #. Orignal i...