A PCRE internal error occured. This might be caused by a faulty plugin

* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Integration: Relational Databases ====== ===== Oracle ===== [[integration:rdbms:oracle:home|Overview]] | [[integration:rdbms:oracle:environments|Environments]] | [[integration:rdbms:oracle:databases|Databases]] | [[integration:rdbms:oracle:tables|Tables]] | [[integration:rdbms:oracle:constraints|Constraints]] | [[integration:rdbms:oracle:datatypes|Datatypes]] | [[integration:rdbms:oracle:queries|Queries]] | [[integration:rdbms:oracle:updates|Updates]] | **[[integration:rdbms:oracle:example|Example]]** ---- ==== Example ==== The following example is a simple database using an Oracle database. The Omnidex Environment File is displayed below; however, the entire example can be downloaded as a ZIP file at the following link: **{{:integration:rdbms:oracle:oracle_example.zip|Download ZIP File}}**. This ZIP file also includes files that can be used to create the Oracle database. The following statements will create and build an Omnidex Environment against an Oracle database: <code> > use sql/create_all.sql -> use sql/simple.sql -> create environment >> in "simple.xml" >> with delete; Environment created in simple.xml -> ; -> create database "SIMPLE" >> type oracle >> version "11" >> user "simple" >> password "simple" >> index_directory "idx" >> in "simple.xml"; Database SIMPLE created in simple.xml -> ; -> create table "COUNTRIES" >> physical "SIMPLE.COUNTRIES" >> ( >> "COUNTRY" CHARACTER(2) omnidex, >> "DESCRIPTION" STRING(47) quicktext, >> "LATITUDE" FLOAT omnidex usage "LATITUDE", >> "LONGITUDE" FLOAT omnidex usage "LONGITUDE", >> "CAPITAL" STRING(31) quicktext, >> "CAPITAL_LAT" FLOAT omnidex usage "LATITUDE", >> "CAPITAL_LONG" FLOAT omnidex usage "LONGITUDE", >> constraint COUNTRIES_COUNTRY_PK primary ("COUNTRY"), >> native COUNTRIES_COUNTRY_IDX ("COUNTRY") >> ) >> in "simple.xml"; Table COUNTRIES created in simple.xml -> ; -> create table "STATES" >> physical "SIMPLE.STATES" >> ( >> "STATE" CHARACTER(2) omnidex, >> "DESCRIPTION" STRING(31) quicktext, >> "STATE_CODE" CHARACTER(2) omnidex, >> "REGION" CHARACTER(2) omnidex, >> "COUNTRY" CHARACTER(2) omnidex, >> "TAX_RATE" FLOAT omnidex, >> constraint STATES_STATE_PK primary ("STATE"), >> constraint STATES_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES", >> native STATES_STATE_IDX ("STATE"), >> ) >> in "simple.xml"; Table STATES created in simple.xml -> ; -> create table "GENDERS" >> physical "SIMPLE.GENDERS" >> ( >> "GENDER" CHARACTER(1) omnidex, >> "DESCRIPTION" STRING(31) quicktext, >> constraint GENDERS_GENDER_PK primary ("GENDER"), >> native GENDERS_GENDER_IDX ("GENDER") >> ) >> in "simple.xml"; Table GENDERS created in simple.xml -> ; -> create table "HOUSEHOLDS" >> physical "SIMPLE.HOUSEHOLDS" >> ( >> "HOUSEHOLD" CHARACTER(12) omnidex, >> "ADDRESS" CHARACTER(50) quicktext, >> "CITY" CHARACTER(28) quicktext, >> "STATE" CHARACTER(2) omnidex, >> "ZIP" CHARACTER(5) omnidex, >> "COUNTRY" CHARACTER(2) omnidex, >> constraint HOUSEHOLDS_HOUSEHOLD_PK primary ("HOUSEHOLD"), >> constraint HOUSEHOLDS_STATE_FK foreign ("STATE") references "STATES", >> constraint HOUSEHOLDS_COUNTRY_FK foreign ("COUNTRY") references "COUNTRIES", >> native HOUSEHOLDS_HOUSEHOLD_IDX ("HOUSEHOLD") >> ) >> in "simple.xml"; Table HOUSEHOLDS created in simple.xml -> ; -> create table "INDIVIDUALS" >> physical "SIMPLE.INDIVIDUALS" >> ( >> "INDIVIDUAL" CHARACTER(12) omnidex, >> "HOUSEHOLD" CHARACTER(12) omnidex, >> "NAME" CHARACTER(50) quicktext, >> "GENDER" CHARACTER(1) omnidex bitmap, >> "BIRTHDATE" ORACLE DATETIME omnidex, >> "PHONE" CHARACTER(14) omnidex, >> "EMAIL" CHARACTER(60) quicktext, >> constraint INDIVIDUALS_INDIVIDUAL_PK primary ("INDIVIDUAL"), >> constraint INDIVIDUALS_HOUSEHOLD_FK foreign ("HOUSEHOLD") references "HOUSEHOLDS", >> constraint INDIVIDUALS_GENDER_FK foreign ("GENDER") references "GENDERS", >> native INDIVIDUALS_INDIVIDUAL_IDX ("INDIVIDUAL") >> ) >> in "simple.xml"; Table INDIVIDUALS created in simple.xml -> ; -> connect simple.xml Connected to D:\class\lab2c\simple.xml -> -> ; Update the Omnidex indexes -> update indexes; Updated indexes for COUNTRIES (239 rows, 0.016 cpu, 0.500 elapsed) Updated indexes for STATES (76 rows, 0.016 cpu, 0.047 elapsed) Updated indexes for GENDERS (2 rows, 0.016 cpu, 0.031 elapsed) Updated indexes for HOUSEHOLDS (1,909 rows, 0.031 cpu, 0.110 elapsed) Updated indexes for INDIVIDUALS (5,000 rows, 0.031 cpu, 0.578 elapsed) Omnidex indexes updated for environment USER_ENVIRONMENT -> ; -> ; Update statistics to improve performance optimization; -> update statistics; Updated statistics for COUNTRIES (239 rows, 0.156 cpu, 0.203 elapsed) Updated statistics for STATES (76 rows, 0.016 cpu, 0.015 elapsed) Updated statistics for GENDERS (2 rows, 0.016 cpu, 0.015 elapsed) Updated statistics for HOUSEHOLDS (1,909 rows, 0.047 cpu, 0.047 elapsed) Updated statistics for INDIVIDUALS (5,000 rows, 0.078 cpu, 0.078 elapsed) Statistics updated for environment USER_ENVIRONMENT -> ; -> ; Update the text database to enable PowerSearch; -> update text; Updated text for COUNTRIES (0.000 cpu, 0.015 elapsed) Updated text for STATES (0.000 cpu, 0.000 elapsed) Updated text for GENDERS (0.000 cpu, 0.000 elapsed) Updated text for HOUSEHOLDS (0.063 cpu, 0.078 elapsed) Updated text for INDIVIDUALS (0.063 cpu, 0.062 elapsed) Text metadata updated for environment USER_ENVIRONMENT -> ; -> disconnect Disconnected </code> ===== ===== **[[integration:rdbms:oracle:updates|Prev]]** ====== Additional Resources ====== See also: {{page>:integration:rdbms:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

 
Back to top
integration/rdbms/oracle/example.txt ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0