Oracle 10g 10.2.0.2 for z/OSe 1.8 installation problem

I am trying to install Oracle 10g 10.2.0.2 on z/OSe 1.8 (running on an IBM zSeries z9).Now I encounter Abend S0C4 when I run SQLORA11 which is the job that creates the Database.In the log for ORAS10 the following errors are observed:DUMP TITLE=Oracle server ORAS10 server LE session (MIRREC) ORAC REA ...

Oracle regexp substr to select the max number out an string

I need a solution for a query.I,ve a query to select the lowest number in a string.select regexp_substr('9 - 10','\d+')from dual;9So this is the query I need to select the min number in he string.but now I need it to give me the highest nr in the string .the output that I need =10Can someone help me ...

Oracle 9i to DB2 9.1 for z/OS

Howzit Folks?I'm trying to migrate data from an Oracle 9i database to DB2 9.1 for z/OS and there seems to be a few issues running the process under USS/OMVS.1. dstJDBCHome parameter is defined twice in IBMExtract.properties and is then completely ignored. I have specified it as /Software/DB2/DB2910/ ...

Oracle Content DB 10.2 for Linux Z series

As Oracle Database 10G R2 10.2.0.2 and Oracle AS 10G R2 10.1.2.0.2 exist for Linux Z series, could you please tell me if Oracle Content DB 10.2 exist too for Linux Z series, and in affirmative case where to download it? in negative case where to access a roadmap?Thank a lot for your help.Best ...

Oracle ORA-13356 same XY but different Z value

I'm loading geometries with XYZ ordinates, and in some, special cases there are two points in a linestring with the same XYordinate but a different Z value.These geometries are in Oracle 10.2.0.3.0 invalid (validate_geometry says ora-13356: adjacent points in a geometry are redundant. Cause: There a ...

Oracle A problem with index(using substr)

I have a question related to indexes and join stuff.I have a field that is a number(21), and that field is used to join other tables,but not the entire field in one pass.In fact I use parts of this field. Like that below: SELECT * FROM HCDD, HCCP2Substr(hcdd.num_ident_cap,1,8) = hccp2.data_credi and ...

Oracle A problem with index(using substr)

I have a question related to indexes and join stuff.I have a field that is a number(21), and that field is used to join other tables,but not the entire field in one pass.In fact I use parts of this field. Like that below: SELECT * FROM HCDD, HCCP2and Substr(hcdd.num_ident_cap,1,8) = hccp2.data_credi ...

Oracle update a subst() with other substr() value from same row

Oracle 10.2.4.0Given table MYTEST:Name Null? Type ----------------------------------------- -------- ---------------------------- NAME_IND VARCHAR2(15) LOCAL_DATA VARCHAR2(30) need to update every row, effectivley doing something like this:update mytest set substr(local_data,1,4) = substr(local_data ...

Broken download link - http://download.oracle.com/otn/nt/omwb/101020/Omwb.z

the following Oracle Migration Workbench link is broken.http://download.oracle.com/otn/nt/omwb/101020/Omwb.zipGives:The page cannot be displayed The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser se ...

Oracle Parsing error on computation using SUBSTR

I'm receiving a parsing error on a computation (shown in View Application Reports ->Application->Database Object Dependencies->Compute Dependencies->Parsing Errors). My computation is of type PL/SQL Expression and this is the computation: SUBSTR (:P410_SELECT_BRD_AND_GRP, instr (:P410_SE ...

Oracle Finding list of employees who has Z in last_name

I have the employees table with last_name column.I want data where last_name should contain z. I used select last_name, first_name from employees where last_name like '%z%'or 'z%' ;This one is not working. But if I use either %z% or Z% or %z am getting the output. But that is not the desired one. Us ...

Oracle Validate IP Address using REGEXP

Sub:Validate IP Address.My requirement is as this query. ........where regexp_like(col1,'^([1-126]|[128-254]).[0-255].[0-255].[1-254]$')........ I searched for a solution using REGEXP, but no luck..Thanks in advance.Jeneesh(Between, this is not a buisiness requirement.But a challenge from our colleg ...

Oracle record matching with instr and substr

i have two simple table--A--idname--B--idnameex of records :--A--1the test--B--1test the testi want to match the first word of table A (before the first space) and look if this word is contain in the name of table B.The result should be the id that matching of table B.I try stg like this :SELECT id ...

Oracle help me pleasse with regexp

I have a questionI,ve a regexp select statement that search for the age of peopleexampleselect regexp_substr(age,'\d+$')from frs_uzk_vacations vcewhere id=20you can try is also to select from dualfor exampleselect regexp_substr('23','\d+$')from dual;the output is:23But the problem is that when you h ...

Oracle SQL*Plus Performance Question "where substr(address,10,4) between "1234" ..

Appreciate Performance Advice for the following:select * from dc_tax where substr(address,10,4) between "1234" and "1288" This query performs a substring and uses a numeric result in comparison with between "string" and "String".It is my understanding that this query would perform better if the subs ...

Oracle comparing data in columns using SUBSTR

I have a column with a case number(VARCHAR2) and a column with a year(NUMBER) consisting of data similiar to:CASENUMBER-----------------------------YEAR199713029----------------------------------97 199713678----------------------------------97 199713691----------------------------------97 199713709- ...

Oracle Grouping on field created with substr

I dont know how to get around this.Here are some of the contents of the field, item, that I need to group by. The Item name is actually the string AFTER "Test" and BEFORE "Hour"TestNodAHour-03TestNodCHour-00TestNodBHour-01TestNodDHour-02So, from the above example, the item names would be "NodA", "No ...

Oracle SQL Loader: When clause with SUBSTR ... is this possible?

Hallo Everyone,I am loading with SQL-Loader and have a WHEN clause ...WHEN BILLMONTH != 'JAN'which works fine.However, I would like to add the following extra component ...... AND SUBSTR(LINENO, 4, 2)='21' (i.e. load on those with 21 at this position)... but find that I get a syntax error:SQL*Loader ...

Oracle DECODE Instead of combination of SUBSTR 'n' INSTR?

I need your help for below 2 issues...1. In my procedure, i am passing ID as parameter. For some of the code there will be 2 ids. Both IDs will be same except the 2nd ID will contain ~01 as last 3 characters.ex: 2009061712345620090617123456~01Now i need to get the CODE from one table. This table mai ...

Oracle What is wrong with this SUBSTR\DECODE combination?

I am having this errorm, trying to insert the result of this query in to a table ORA-12899: value too large for column "SATURN"."SARADAP"."SARADAP_MAJR_CODE_2" (actual: 5, maximum: 4)The SARADAP_MAJR_CODE_2 is define as varchar2(4). SELECT spriden_pidm, '201090', 'M', '1', SYSDATE, 'B', SYSDATE, 'S' ...

Oracle Help me understand this Regexp

SQL> select regexp_substr('1234 dill 123 dall','[[:alpha:]]') from dual; R - d   SQL> select regexp_substr('1234 dill 123 dall','[[:alpha:]]*') from dual; R -   SQL> select regexp_substr('1234 dill 123 dall','[[:digit:]]') from dual; R - 1   SQL> select regexp_substr('1234 ...

Oracle Some trouble with a regexp in REGEXP_INSTR

I have a column whose values represent a "microformat", where it is a list of tokens separated by commas, perhaps with spaces around the commas. Each token will have no spaces or commas in it. I need my query to determine whether a specific token value is in the list, and not as a substring. The exa ...

Oracle How to use floor(to_number(substr x))) in where clause???

I have a column doc_id which value like abcd.01.023. If I select floor(to_number(substr(doc_id, instr(doc_id, '.', 1)+1, instr(doc_id, '.', 1)+1 ))) it works, but get ORA-01722: invalid number if I use in where clause like:Where floor(to_number(substr(doc_id, instr(doc_id, '.', 1)+1, instr(doc_id, ' ...

Cross platform Migration-Oracle 8.1.7 on z/os to Oracle 10G on AIX

We are in process of migrating the Oracle Database from 8.1.7 on z/os platform to Oracle 10G on AIX platform?Please suggest the best methodology for this cross platform migration? ...

RegExp not working.

I am having some troule with searching a string taken from a text field (a name textfield, it's basically a form and the script is validating it).I've been on the W3C schools website and I cannot get it to work, even with the "try it" feature.Please help.function nameValidator(entry, msg){ ...

Oracle Linux S390

I tried to access your links to download a copy of the Oracle Developer's Releases for Linux/390 & z/Linux 9i but I get a message the page can't be found. Where do I find the pages? ...

ORACLE 8 for SCO

i tried to download ORACLE 8.0.5.1 for SCO from download.oracle.com/otn/downloads/netware/805UW.tar.Z.The message i got is : Sorry, this page doen`t exist.Is this version of ORACLE not available, or is only the link broken?If there is an other link to any Version of ORACLE for SCO 5.0.2 pleaselet me ...

Keyword SEARCH Function with REPLACE(RegExp)

is it possible to combine the the following functions with each other in an array for example and if so, would someone be kind enough to show me how.the reasons are 1. to see if it is at all possible and 2. to learn so that I can combine further possibilities in the future.the first script compares ...

MySQL Help with REGEXP please

I need to display people's names from a table in dropdown lists on a web page. As there are many names, one dropdown would be impractical. So I have a dropdown listing names beginning with A through to F, another with G through to L etc. The queries I use to select the appropriate ranges look like t ...

Oracle a problem i encountered during ins orcl92 on w2k server

during the last 48 hours (-:, i tried four times to install oracle 9.2 on my w2k server. i tend to treat my computer very bad, so it's loaded with lots of programs, such as .NET, java2, and a lot of apps. i tried to add oracle, so i downloaded the installation from the company. but when i began the ...

conversion sql from oracle to SQL Server

Guys, I have this statement that I am converting from Oracle to SQL. Help pls:-) PP_PRICEPOINT_ID is a decimal. What is the appropriate usage..Oracle-------------update pricepoint set pp_type = decode(substr(pp_pricepoint_id,1,1),7,0,2),pp_qtybreakindex =substr(pp_pricepoint_id,3,1) where pp_type is ...

Oracle download link to CSSCAN broken

I need to download CCSCAN for 9iR2/Linux ( [http://download.oracle.com/otn/utilities_drivers/scanner/csscan_12_linux_920.tar.Z] ) but I permanently get error 'page not found'.has it been moved anywhere else?isn't there availbale any other link (FTP)? emha. ...

Oracle 7 Transparent Gateway for UDB8

Can Oracle 7 Transparent Gateway be installed in z/os? The gateway will be connected to DB2 UDB version 8, can the gateway work with this kind of setup? ...

MySQL REGEXP is not optimized?

I'm using REGEXP to search records by the prefix of an indexed text field, but it has much worse performance than LIKE, even though I'm searching for the same thing. Example: Compare: EXPLAIN SELECT * FROM table WHERE name LIKE "a%"; +----+-------------+-------+-------+---------------+---- ...

Oracle webtogo server fails to start

i have installed the mobile server on oracle 9i lite. the operating system is windows 2000 professional. java vm version is 1.3.1_01the server does not run with:cd\<orahome>\mobile\sdk\binwebtogo -d0 mobileadmin/oracle@webtogo.worldi have installed the mobile server on a previous pc, which hap ...

a work around for the db. conf. assis. problem oracle 92 on w2k

during the last 48 hours (-:, i tried four times to install oracle 9.2 on my w2k server. i tend to treat my computer very bad, so it's loaded with lots of programs, such as .NET, java2, and a lot of apps. i tried to add oracle, so i downloaded the installation from the company. but when i began the ...

Oracle Will 9i release 2 run on IBM z800?

there.. Is it possible to run Oracle 9i release 2 on an IBM z-series 800 machine?any advice or links you can provide would be great! ...

ORACLE 9.0 on OS/390 and Expanded storage

a client is using Oracle 9.0 on Z/OS 1.4 and wondered if the database is using the MVS expanded storage or not. There are no SMF records concerning this found. How can we make sure that the expanded storage will be used ?Is it true that Oracle has a 2 GB limit on Z/OS 1.4 because of the 31-bit addre ...

Oracle occi on vc6, compile error ??help me

--------------------Configuration: occicoll - Win32 Debug--------------------Linking...occicoll.obj : error LNK2001: unresolved external symbol "public: virtual __thiscall oracle::occi::SQLException::~SQLException(void)" (??1SQLException@occi@oracle@@UAE@XZ)occicoll.obj : error LNK2001: unresolved e ...

Oracle HTMLDB 2.1 question

On the page "http://st-curriculum.oracle.com/tutorial/DBXETutorial/index.htm" there is a topic: "Create an Application using HTML DB 2.1" (XE).Is this a new version of HTMLDB? Are there some new cool stuff?I want to develop/test on XE/HTMLDB on my notebook (now I can sit on the beach & work), an ...

Oracle Runtime error trying to call PL/SQL refcursor from VB using ADO

I have a form in MS Access/vb and I am trying to connect to Oracle Database and call a ref cursor in Oracle PL/SQL procedure using ADO.I am able to connect successfully, but when I execute the command (when I call the ref cursor) I get a RUNTIME UNSPECIFIED ERROR.In my procedure p_user_id is an inpu ...

Oracle VS8: Build Solution Error LNK2019

Build started: Project: HelloWorld, Configuration: Debug Win32 Linking...HelloWorld.obj : error LNK2019: unresolved external symbol "public: static class oracle::occi::Environment * __cdecl oracle::occi::Environment::createEnvironment(enum oracle::occi::Environment::Mode,void *,void * (__cdecl*)(voi ...

error LNK2028: unresolved token (0A00001F) "public: static class oracle....

I am using MSVC C++ Express and Oracle XE. When I am building my C++ script I get the following errors:DbCheck.obj : error LNK2028: unresolved token (0A00001F) "public: static class oracle::occi::Environment * __clrcall oracle::occi::Environment::createEnvironment(enum oracle::occi::Environment::Mod ...

Oracle Problem getting OCCI working with VS2005 Express

a, I have read all the related threads about similar problems and have tried all the suggestions but I still can't get my program working. Here is what I am doing:- I downloaded the relevant downloads and put them into C:\oraclexe\app\oracle\product\10.2.0\server\OCI\lib\MSVC\vc8- Created project in ...

Oracle "error LNK2019: unresolved external symbol" help......!

Hi, i'm still newbie with Oracle 10g and VC8. The problem is i found this LNK2019 error when build my project. Here the steps i take when run VC8 for the first time:(1). In PROJECT->PROPERTIES->CONFIGURATION PROPERTIES->C/C++->ADDITIONAL INCLUDE, i add the "C:\oracle\product\10.1.0\db_1\ ...

Oracle SQLLOADER issues with Network Drive

I am running Oracle 10g in my PC ( Windows XP Professional ) in D Drive. I have created Oracle Directory and mapped to Network Drive Z: I have created external table successfully with this Directory. When i run select statement, i am getting the below error. All the permissions have given on Network ...

Bug in /etc/init.d/oracle-xe script - proposed solution

I found out that, under CentOS (RHEL clone), Oracle XE starts up normally at system boot, but does not shut down cleanly at system shutdown. The system just reboots, ignoring Oracle XE, with a real possibility of datafile corruption. Not good.I investigated the issue and found the root cause: the /e ...

Oracle How to use Left & Right Functionality for Strings..

Please help i am unable to find Left & Right Functions in Oracle 11g.. Instead i just found Substr who can be a replacement for Left but not for Right.. ...

different behavior Oracle 10 and Oracle 11

- i have a Trigger for reporting updates on my Table. It works perfect on Oracle 10.2 but if i to the same on Oracle 11 some data is missing!Select on Oracle 10 :C01 C02 OLD_CHAR -------------------------------- X Y Z Select on Oracle 11 :C01 C02 OLD_CHAR -------------------------------- Z connect s ...

Oracle why function index can't avoid sort ORDER BY STOPKEY

  SQL> alter session set nls_language=american;   Session altered.   SQL> create table test_sort(name,object_name) as select 'select',object_name from 2 dba_objects;   Table created.   SQL> create index i_test_sort_1 on test_sort(substr(name,0,3),object_name); ...