f



verifiing 8.1.7.4.1 upgrade to 8.1.7.4.x

I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13.    I would
like to verify this fact.

In the readme it does state that all the products will not display the
version number 8.1.7.4.13, because it's a cummulative patch.

I would like to see at least one file with the version number greater
than 8.1.7.4.1

querying the database, v$instance  still yields 8.1.7.4.1

Any ideas?

thanks
0
4/15/2004 10:14:40 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

3 Replies
1288 Views

Similar Articles

[PageSpeed] 20

Try (might need as SYS)

column comp_name format a35
column status format a20
column version format a11
select comp_name, status, substr(version,1,10) as version
from dba_registry
order by comp_name;

HTH
tED
"Ivette Dumois" <ivettedumois@hotmail.com> wrote in message
news:654ecf81.0404151414.267764e3@posting.google.com...
> I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13.    I would
> like to verify this fact.
>
> In the readme it does state that all the products will not display the
> version number 8.1.7.4.13, because it's a cummulative patch.
>
> I would like to see at least one file with the version number greater
> than 8.1.7.4.1
>
> querying the database, v$instance  still yields 8.1.7.4.1
>
> Any ideas?
>
> thanks


0
theom (10)
4/15/2004 11:52:56 PM
Ivette Dumois wrote:
> I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13.    I would
> like to verify this fact.
> 
> In the readme it does state that all the products will not display the
> version number 8.1.7.4.13, because it's a cummulative patch.
> 
> I would like to see at least one file with the version number greater
> than 8.1.7.4.1
> 
> querying the database, v$instance  still yields 8.1.7.4.1
> 
> Any ideas?
> 
> thanks

You could also try V$VERSION... but I doubt you'll see that fifth level 
of revision shown.

If you had a specific bug that was supposed to be fixed by the upgrade, 
test for that. Otherwise, your effort would be better spent on an Oracle 
9i or Oracle 10g upgrade... since 8i is de-supported.

--Mark Bole

0
makbo (354)
4/18/2004 1:39:03 AM
Mark Bole <makbo@pacbell.net> wrote in message news:<X_kgc.37966$gD3.1885@newssvr29.news.prodigy.com>...
> Ivette Dumois wrote:
> > I have upgraded our test 8.1.7.4.1 database to 8.1.7.4.13.    I would
> > like to verify this fact.
> > 
> > In the readme it does state that all the products will not display the
> > version number 8.1.7.4.13, because it's a cummulative patch.
> > 
> > I would like to see at least one file with the version number greater
> > than 8.1.7.4.1
> > 
> > querying the database, v$instance  still yields 8.1.7.4.1
> > 
> > Any ideas?
> > 
> > thanks
> 
> You could also try V$VERSION... but I doubt you'll see that fifth level 
> of revision shown.
> 
> If you had a specific bug that was supposed to be fixed by the upgrade, 
> test for that. Otherwise, your effort would be better spent on an Oracle 
> 9i or Oracle 10g upgrade... since 8i is de-supported.

Not exactly, see metalink note 250629.1

jg
--
@home.com is bogus.
Great 404 messages: 
http://www.ibiblio.org/pub/academic/computer-science/history/pdp11/
0
joel-garry (4553)
4/19/2004 11:20:36 PM
Reply:

Similar Artilces:

Patching Oracle 8.1.7.0.0 to Oracle 8.1.7.4.1
Hello, my configuration is Windows 2K Server SP4 and Oracle 8.1.7.0.0. Where can i find a patch to upgrade to Oracle 8.1.7.4.1 Many thanks for your attention -- Sitta many thanks!!!! Have a nice work "Rauf Sarwar" <rs_arwar@hotmail.com> ha scritto nel messaggio news:1106137485.286119.307110@f14g2000cwb.googlegroups.com... > > Sitta Davide wrote: >> Hello, >> my configuration is >> >> Windows 2K Server SP4 and Oracle 8.1.7.0.0. >> >> Where can i find a patch to upgrade to Oracle 8.1.7.4.1 >> >> >> Many thanks for your attention >> >> -- >> >> Sitta > > http://metalink.oracle.com > > Regards > /Rauf > ...

Upgrading Oracle 8.1.7.2 to 8.1.7.4
Can somebody help me with the processof upgrading the Oracle Database server from 8.1.7.2 to 8.1.7.4 ? Thanks, Ram. ***************************************** * This message was posted via http://www.oraclemonster.com * * Report spam or abuse by clicking the following URL: * http://www.oraclemonster.com/Uwe/Abuse.aspx?aid=73db04a468ad4c33876f738804693df2 ***************************************** "Ramanujam Paravastu via OracleMonster.com" <forum@OracleMonster.com> a �crit dans le message de news:73db04a468ad4c33876f738804693df2@OracleMonster.com... > Can somebody help me with the processof upgrading the Oracle Database server from 8.1.7.2 to 8.1.7.4 ? > > Thanks, > > Ram. > > ***************************************** > * This message was posted via http://www.oraclemonster.com > * > * Report spam or abuse by clicking the following URL: > * http://www.oraclemonster.com/Uwe/Abuse.aspx?aid=73db04a468ad4c33876f738804693df2 > ***************************************** Just follow the instructions in the README.html file you get with your patchset. -- Regards Michel Cadot I found the patch for UNIX systems, I would like to know the patch for Windows NT/2000 systems Please. Thanks. ***************************************** * A copy of the whole thread can be found at: * http://www.oraclemonster.com/Uwe/Forum.aspx/oracle-misc/2776 * * Report spam or abuse by clicking the fo...

Oracle Update 8.1.7.0.0 -> 8.1.7.4.1
I had to Update ORACLE 8.1.7.0.0 on a W2K Server ENGLISH (French Keyboard) to 8.1.7.4.1 Everything looks fine, the services were started - but in the Event Log I have a lot of errors of oradim.exe (.. can't read memory ..) and also when startin tools like sqlwplus.exe i get the same error. Any suggestions??? Please help me! Regards, Stephan buckenmaier@tka-presta.thyssenkrupp.com (Stephan@TKA-Presta) wrote in message news:<ba9d45ff.0401282332.127ac2f0@posting.google.com>... > I had to Update ORACLE 8.1.7.0.0 on a W2K Server ENGLISH (French > Keyboard) to 8.1.7.4.1 > Everything looks fine, the services were started - but in the Event > Log I have a lot of errors of oradim.exe (.. can't read memory ..) and > also when startin tools like sqlwplus.exe i get the same error. > > Any suggestions??? > Please help me! > > Regards, > Stephan No suggestions by anyone I am afraid, as your post provides nothing to work on apart form vague clues like 'lot of errors of oradim.exe' We need *exact* errors, not *paraphrased* ones. We didn't look over your shoulder when it happened, did we? Sybrand Bakker Senior Oracle DBA sybrandb@yahoo.com wrote in message news:<a1d154f4.0401290213.913f792@posting.google.com>... > buckenmaier@tka-presta.thyssenkrupp.com (Stephan@TKA-Presta) wrote in message news:<ba9d45ff.0401282332.127ac2f0@posting.google.com>... > > I had to Update ORACLE 8.1.7.0.0 on a W2K Server ENGLI...

upgrading Oracle RDBMS 8.1.7.0 to 8.1.7.4 on Win XP
Hi, I try to upgrade Oracle 8.1.7.0 to 8.1.7.4 on Win XP Pro SP1 but Oracle Universal Installer (1.7.1.10.1) fails in the beginning on the installation: "Certain files which need to be reinstalled by Oracle Universal Installer are being used by one more running services. The following services need to be shutdown before continuing:" <here is list of almost all services!> How can I solve the problem? Piotr Piotr Wozniak wrote: > Hi, > I try to upgrade Oracle 8.1.7.0 to 8.1.7.4 on Win XP Pro SP1 > but Oracle Universal Installer (1.7.1.10.1) fails in the beginning > on the installation: > "Certain files which need to be reinstalled by Oracle Universal Installer > are being used by one more running services. The following services > need to be shutdown before continuing:" > > <here is list of almost all services!> > > How can I solve the problem? > Piotr Make sure no Oracle Services runs in the system. U need to shutdown all the services before u can do an install... :) HTH -- Cheers Ganesh Raja ganesh.raja@nospam.mantas.com <Remove nospam to Mail> piotr.wozniak@cs.put.poznan.pl (Piotr Wozniak) wrote in message news:<94e73320.0408310541.74cd2b1a@posting.google.com>... > Hi, > I try to upgrade Oracle 8.1.7.0 to 8.1.7.4 on Win XP Pro SP1 > but Oracle Universal Installer (1.7.1.10.1) fails in the beginning > on the installation: > "Certain files which need to be reinst...

upgrade from 8.1.7.0 32-bit to 8.1.7.4 64-bit
Hi All: I have a production database on HP, and want to upgrade to 8.1.7.4 64-bit from 8.1.7.0 32-bit. But which way is correct : 1. directly upgrade to 8.1.7.4 64-bit from 8.1.7.0 32-bit, is it possible? 2. upgrade to 8.1.7.4 32-bit from 8.1.7.0 32-bit, then upgrade 8.1.7.4 32-bit to 64-bit 3. upgrade to 8.1.7.0 64-bit from 8.1.7.0 32-bit, then upgrade 8.1.7.0 64-bit to 8.1.7.4 64-bit I really appreciate your help is you have documentation for that, or metalink DOC ID. Thanks Willie On Metalink, look at the following: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=164997.1 Pay particular attention to the part that starts "If upgrading in addition to changing the word size". HTH, Brian willie wrote: > > Hi All: > > I have a production database on HP, and want to upgrade to 8.1.7.4 > 64-bit from 8.1.7.0 32-bit. But which way is correct : > > 1. directly upgrade to 8.1.7.4 64-bit from 8.1.7.0 32-bit, is it > possible? > 2. upgrade to 8.1.7.4 32-bit from 8.1.7.0 32-bit, then upgrade 8.1.7.4 > 32-bit to 64-bit > 3. upgrade to 8.1.7.0 64-bit from 8.1.7.0 32-bit, then upgrade 8.1.7.0 > 64-bit to 8.1.7.4 64-bit > > I really appreciate your help is you have documentation for that, or > metalink DOC ID. > > Thanks > Willie -- =================================================================== Brian Peasland dba@remove_spam.peasland.com Remove the "r...

upgrade issues 8.1.7.0 -> 8.1.7.4 on smack-hat linux
Hello, after upgrading Oracle database 8.1.7.0 with patch 8.1.7.4 I cannot startup the Oracle anymore. This all happens on RedHat (7) platform. I login via sqlplus locally. This is what happens: SQL> connect / as sysdba Connected to an idle instance. SQL> startup nomount ORA-24323: value not allowed ORA-03113: end-of-file on communication channel And then nothing. Searching on metalink does not help me much. The issues there refer to faulty entries in tnsnames.ora and oralistener files. Checked these and they are OK, not that I think in this case these files have anything to do with this problem. Any hints? Regards, Frank "Frank" <no@spam.org> wrote in message news:4252f492$0$147$e4fe514c@news.xs4all.nl... > Hello, > > after upgrading Oracle database 8.1.7.0 with patch 8.1.7.4 I cannot > startup the Oracle anymore. This all happens on RedHat (7) platform. I > login via sqlplus locally. This is what happens: > > SQL> connect / as sysdba > Connected to an idle instance. > SQL> startup nomount > ORA-24323: value not allowed > ORA-03113: end-of-file on communication channel > > And then nothing. Searching on metalink does not help me much. The issues > there refer to faulty entries in tnsnames.ora and oralistener files. > Checked these and they are OK, not that I think in this case these files > have anything to do with this problem. > > Any hints? > > Regards, > Frank Is...

Move 8.1.6 db to 8.1.7.4 Server
Hello, what is the best way to move a 8.1.6 db to a new server that has 8.1.7.4 on it? I have an export of the DB as well as a cold backup. At what point do I upgrade the db? Not very clear on hoe to proceed. Eventually once the DB is funtioning I will take down the production db, export and import into the new server. Thanks. T. Todd Springett wrote: > Hello, what is the best way to move a 8.1.6 db to a new server that > has 8.1.7.4 on it? I have an export of the DB as well as a cold > backup. At what point do I upgrade the db? Not very clear on hoe to > proceed. > > Eventually once the DB is funtioning I will take down the production > db, export and import into the new server. > > Thanks. > > T. Exp/Imp; you should upgrade 8.1.6 to 8.1.7.0 first. As you have patches applied (you're on 8.1.7.4), you cannot upgrade. Don't understand the last remark; looks like you choose imp/exp already, so why the question? -- Regards, Frank van Bortel ...

Oracle 8.1.7 32-Bit to Oracle 8.1.7 64-Bit
Hi I would much appreciate help We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX 32-bit machine. We are upgrading the HP-UX machine to 64-Bit. Is the only way of extracting/inmporting the data via the exp/imp utitlity due to the change in bits? Is there any other way? Thanks Bob Bob wrote: > Hi I would much appreciate help > > We have a 150-200GB database on Oracle 8.1.7 which resides on a HP-UX > 32-bit machine. We are upgrading the HP-UX machine to 64-Bit. Hi, a) Do you want to upgrade Oracle-Software from 32bit to 64bit? On Solaris, I know 32bit Oracle-Software runs also on 64bit Solaris, but I don't know about HP-UX. b) If you want or have to switch to Oracle 64 bit, then use can use the new 64bit oracle software on the "old" database, but you have to recompile all PL/SQL-procedures, no more. No exp/imp is necessary. - install 64bit Oracle-Software in a new $ORACLE_HOME - switch all environments to 64bit oracle and use it now - sqlplus "/ as sysdba" sql> startup restrict sql> @?/rdbms/admin/utlirp; sql> shutdown immediate sql> startup sql> @?/rdbms/admin/utlrp; sql> exit; --> ready! Eberhard Eberhard Niendorf <eberhard.niendorf_schrott@t-online.de> wrote in message news:<cnt89j$uor$05$1@news.t-online.com>... > Bob wrote: > > > Hi I would much appreciate help > > > > We have a 150-200GB database on Oracle 8.1.7 which resid...

how to install oracle 8.1.7 on unixware 7.1.1
hi, i like to know how to install oracle 8.1.7 on unixware 7.1.1? it need any patches?.if so mail me to--snaren_dba@yahoo.com -- Posted via http://dbforums.com I use oracle 817 on a unixware 711 with maintenance pack 3. I only had problems with tmp free space during installation, if you don't have a big tmp volume try to link Oracle install directory outside. Greetings. snaren_dba <member32299@dbforums.com> wrote in message news:<3143890.1058980488@dbforums.com>... > hi, > i like to know how to install oracle 8.1.7 on unixware 7.1.1? it need > a...

Issues with Uniface upgrade v.7.2.06 to v.8.4.04 (Windows XP, Oracle 8.1.7, SQL* Net)
Hi, We are currently trying to upgrade from Uniface 7.2.06 to 8.4.04. Windows XP, Oracle 8.1.7, SQL* Net I did the following so far. Installed the Uniface Version 8.4.04 with SOLID on my local pc (Windows XP Prof) I was able to start the application and the IDF enviroment was able to view. Since we are using Oracle 8.1.7 as our database, I created the new schema with required permissions. I crated the repository in Oracle (SID DEV1) by running the sql scripts from the installation folder C:\Program Files\Compuware\Uniface\sql\ora4*.sql Modified the Asssingment fi...

Upgrade database from 8.1.6 to 8.1.7
Does the time taken by this upgrade (8.1.6 to 8.1.7) depend on the size of objects (tables, indexes) ? Does it have something to do with the number of objects as it works on the dictionnary ? "Patrick Maurice" <adress@nowhere> wrote in message news:3fb21adc$0$25710$afc38c87@news.easynet.fr... > Does the time taken by this upgrade (8.1.6 to 8.1.7) depend on the size of > objects (tables, indexes) ? > Does it have something to do with the number of objects as it works on the > dictionnary ? > Depends on how you do the upgrade. If you use the migration assistant (GUI) or the migration utility (command line), then no, upgrade time is not dependent on the size of your data. If you export followed by import, then yes, it will be. Regards HJR ...

"::tcl::tm::UnknownHandler ::tclPkgUnknown msgcat 1.4" caused by replacing Tcl 8.4.1 with 8.5.7
In the blog http://planet.larrythecow.org/archives/2009-07-26.html "The Twouble with Tcl" Iain Buchanan shows that redefining OPEN proc leads to the errors similar to what I am getting - when I replaced Tcl 8.4.1 with Tcl 8.5.7. In my case I don't know the exact root cause though ... Any ideas how I should proceed with debugging this issue ? Thanks, Alex tclsh c:/Tornado/host/resource/hutils/tcl/makeSymTbl.tcl ppc tmp.o symTbl.c invalid command name "::tcl::tm::UnknownHandler" while executing "::tcl::tm::UnknownHandler ::tclPkgUnknown msg...

Oracle Upgrade problem : from 8.1.6 to 8.1.7
According the documentation from Metalink, the following files are required for the Oracle Upgrade from 8.1.6 to 8.1.7 : u0801060.sql c0801060.sql a0801060.sql i0801060.sql utlip.sql However, after install 8.1.7, I could only find 4 of them, but no i0801060.sql. I still did the upgrade by executing the script : u0801060.sql but recursive errors appeared and I knew that the reason was the missing of i0801060.sql. Can anybody tell me where can I get the file : i0801060.sql for Oracle Upgrade ? ...

where to download 8.1.5, 8.1.6, 8.1.7?
Hello. Does anybody know where to download any of these Oracle installations: 8.1.5, 8.1.6, 8.1.7? Windows/Linux versions, doesn't matter. I can't find them at Oracle website. Thanks in advance. The keyword is here: desupported. But if you have a valid CSI you can still get them from support. You need to submit a service request though. -- Sybrand Bakker Senior Oracle DBA ...

Connecting to Oracle 8.0.4 Database using 8.1.7 client
I am installing an SAP application server, and would like it to be as clean as possible. Is it possible to use Oracle 8.1.7 client software to communicate with an 8.0.4 database on the SAP Central and Database instance. TIA Chris Kernaghan aka BoobBoo On 7 Jan 2003 04:41:39 -0800, chris_kernaghan@hotmail.com (Chris) wrote: >I am installing an SAP application server, and would like it to be as >clean as possible. > >Is it possible to use Oracle 8.1.7 client software to communicate with >an 8.0.4 database on the SAP Central and Database instance. > >TIA > >Chris Kernaghan > >aka > >BoobBoo It is not guaranteed to work, as you are connecting from a higher version client and 8.0.4 has been desupported in the previous century Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address From what others have said, I must be missing something... You can certainly do it, provided you connect with SQL*Net and have the LISTENER.ORA defined so that it actually starts the 804 server for your connection (it'll be the default if you're using an 804 listener). That sure works here on VMS, and that kind of things are usually platform independant. If you connect bequeath, then yes, you may have some problems, but it may work well up to a certain point. Corrections and additions welcome -- Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en fran�ais) To reply to myself directly, rem...

Connecting to Oracle 8.0.4 Database using 8.1.7 client software
I am installing an SAP application server, and would like it to be as clean as possible. Is it possible to use Oracle 8.1.7 client software to communicate with an 8.0.4 database on the SAP Central and Database instance. TIA Chris Kernaghan ...

soap4r 1.4.8.1 with REXML 2.7.1
I grabbed the latest soap4r and had a go with the wsdl driver, only to come to an abrupt stop with the following site_ruby/1.6/wsdl/rexmlparser.rb:40:in `doParse': uninitialized constant VERSION_MAJOR at REXML (NameError) from f:/devlab/ruby/lib/ruby/site_ruby/1.6/wsdl/parser.rb:85:in `parse' from f:/devlab/ruby/lib/ruby/site_ruby/1.6/soap/wsdlDriver.rb:81:in `parse' from f:/devlab/ruby/lib/ruby/site_ruby/1.6/soap/wsdlDriver.rb:39:in `initialize' from wsdltest.rb:5:in `new' from wsdltest.rb:5 I?m running 1.6.8 on W2K at the moment and I looked for a VERSION_MAJOR...

Should I upgrade Ruby from 1.8.5 to 1.8.7?
I just upgraded to Rails 2.3.2 but my Ruby is still 1.8.5. Rails 2.3.2 doc says it work fine with 1.8.5 but it recommends 1.8.7. I remembered from a previous attempt that upgrading Ruby to 1.8.6 was too complicated for me, so I'm wondering what I would get if I upgrade to 1.8.7 and if I should just stick with 1.8.5. -- Posted via http://www.ruby-forum.com/. There have been a few threads on this so far. Possibly the right thing to do is to install multiple versions and flip back and forth if you run into difficulties. Unfortunately, this is complicated and there are hidden proble...

Upgrading 8.0.4 to 8.1.7 on NT
I have got working Oracle database 8.0.4 on Windows NT and 8.1.7 release CD. How to upgrade? I have searched the documentation that comes with 8.1.7 - it is not clear to me what upgrading procedure looks like. Can anyone briefly describe how do you usually upgrade from release to release? Thanks ...

BIND 8.4.7 Beta 1 (8.4.6-T1B)
BIND 8.4.7 Beta 1 (8.4.6-T1B) BIND 8.4.7-T1B is a beta maintence release of BIND 8.4. the distribution files are: ftp://ftp.isc.org/isc/bind/src/testing/8.4.7-T1B/bind-src.tar.gz ftp://ftp.isc.org/isc/bind/src/testing/8.4.7-T1B/bind-doc.tar.gz ftp://ftp.isc.org/isc/bind/src/testing/8.4.7-T1B/bind-contrib.tar.gz the pgp signature files are: ftp://ftp.isc.org/isc/bind/src/testing/8.4.7-T1B/bind-src.tar.gz.asc ftp://ftp.isc.org/isc/bind/src/testing/8.4.7-T1B/bind-doc.tar.gz.asc ftp://ftp.isc.org/isc/bind/src/testing/8.4.7-T1B/bind-contrib.tar.gz.asc Windows NT / Windows 2000 binary distribution. There are no windows binaries for this release. If you need windows binaries please use BIND 9. top of CHANGES says: --- 8.4.7-T1B released --- (Sun Sep 11 18:05:50 PDT 2005) 1718. [bug] res_init()/res_ninit() could leak memory when re-called. Improve res_ninit() documentation to say the memory must be zeroed. Document res_ndestroy(). 1717. [bug] always use the hints when priming. 1716. [port] solaris: poll() support. 1715. [port] solaris: uses Sun's md5 implementation. 1714. [func] inet_nsap_ntoa(), sym_ntos(), sym_ntop(), p_option(), p_time(), precsize_ntoa(), loc_ntoa() and p_secstodate() are now thread safe. 1713. [bug] memcluster.c needed locks in the threaded build. 1712. [bug] turning off non-blocking i/o was broken. 1711. [cleanup] nslookup now uses connected UDP socket (except on MP...

Re: Puzzle: Converting 1-10 to 1,2,3,4,5,6,7,8,9,10 #8
You program does not work "the first time" becasue NUMSTR does not exist. 7235 Data _Null_; 7236 Length NewString $ 200 ; 7237 String = '1-10,21,22,30-35,40,41' ; 7238 7239 7240 call execute ( "proc format; value numstr " || 7241 String || 7242 " ='Nums'; run ;"); 7243 7244 Do _K = input(Scan( String , 1 , ',-' ),best12.) To 7245 input(Scan( String , -1 , ',-'),best12.); 7246 if put(_K,numstr.)='Nums' then ------- 484 NOTE 484-185: Format NUMSTR was not found or could not be loaded. 7247 7248 NewString = CatX( ',' , NewString , _K ) ; 7249 End; 7250 7251 Put NewString= ; 7252 run; NewString= NOTE: CALL EXECUTE generated line. 1 + proc format; 1 + value numstr 1-10,21,22,30-35,40,41 ='Nums'; NOTE: Format NUMSTR has been output. 1 + run ; On 10/3/08, Choate, Paul@DDS <pchoate@dds.ca.gov> wrote: > Hey Toby - What no regex? No hash? > > How about a proc format wrapped in a call execute? > > Data _Null_; > Length NewString $ 200 ; > String = '1-10,21,22,30-35,40,41' ; > > call execute ( "proc format; value numstr " || > String || > " ='Nums'; run ;"); > > Do _K = input(Scan( String , 1 , &...

Re: Puzzle: Converting 1-10 to 1,2,3,4,5,6,7,8,9,10 #7
Hey Toby - What no regex? No hash? How about a proc format wrapped in a call execute? Data _Null_; Length NewString $ 200 ; String = '1-10,21,22,30-35,40,41' ; call execute ( "proc format; value numstr " || String || " ='Nums'; run ;"); Do _K = input(Scan( String , 1 , ',-' ),best12.) To input(Scan( String , -1 , ',-'),best12.); if put(_K,numstr.)='Nums' then NewString = CatX( ',' , NewString , _K ) ; End; Put NewString= ; run; Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Toby Dunn Sent: Friday, October 03, 2008 1:55 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Puzzle: Converting 1-10 to 1,2,3,4,5,6,7,8,9,10 Data _Null_ ; Length NewString $ 200 ; String = '1-10,21,22,30-35,40,41' ; Do I = 1 To ( 1 + CountC( String , ',' ) ) ; TempA = Scan( String , I , ',' ) ; If Find( TempA , '-' ) Then Do ; Start = Input( Scan( TempA , 1 , '-' ) , Best12. ) ; Stop = Input( Scan( TempA , 2 , '-' ) , Best12. ) ; Do K = Start To Stop ; NewString = CatX( ',' , NewString , K ) ; End ; End ; Else Do ; NewString = CatX( ',' , NewString , TempA ) ; End ; End ; Put NewString= ; Run ; On Fri, 3 Oct 2008 16:27:44 -0400, Paul Walker <walker.627@OSU.EDU> wrot...

Re: Puzzle: Converting 1-10 to 1,2,3,4,5,6,7,8,9,10 #4
Nice! But you assume string is a macro var. What about string is a data step var and the dataset has many records? On Fri, 3 Oct 2008 16:22:31 -0500, ./ ADD NAME=Data _null_, <iebupdte@GMAIL.COM> wrote: >All positive ranges? > >Thinking about a way to get SAS to do most of the work this is what I >came up with.... > >7227 %let string = 1-10,21,22,30-35,40,41; >7228 data _null_; >7229 length newstring $256; >7230 do _n_ = %qsysfunc(tranwrd(%superq(string),-,%str( to ))); >7231 newstring = catx(',',newstring,_n_); >7232 end; >7233 put 'NOTE: ' newstring=; >7234 run; > >NOTE: newstring=1,2,3,4,5,6,7,8,9,10,21,22,30,31,32,33,34,35,40,41 > > > >On 10/3/08, Paul Walker <walker.627@osu.edu> wrote: >> What is the best way to convert a string like 1-10 to a string like >> 1,2,3,4,5,6,7,8,9,10? The string is stored as a variable in a datastep. >> I am looking for a function that could be called like this maybe. >> >> data _null_; >> string = '1-10'; >> newstring = function(string); >> run; >> >> Add a twist to the puzzle: what if I mixed and matched. For example, a >> string 1-10,21,22,30-35,40,41. >> >> data _null_; >> string = '1-10,21,22,30-35,40,41'; >> newstring = function(string); >> run; >> >> newstring = 1,2,3,4,5,6,7,8,9,10,21,22,30...

backup
Hi guys, please, do you know any good site where I can find information about Oracle on the OpenVMS platform? The Oracle documentation is good, but others sources are always welcome. The most interesting themes are backup procedures. I am not experienced user on the OpenVMS, but I have some experience with Oracle on other platforms (HPUX, Wintel). Backup should be taken as a hot backup and it should be done without any special backup software. As a next step, we would like to try Data Protector installed on HPUX as a Cell Manager. Thanks in advance, Mario. There is (used to be) a web site and mailing list for OpenVMS Oracle users, but it looks like it's not active anymore http://www.oug.com/vmssig/listserv.html If you find something else tell me! If you have any specific questions about using Oracle on OpenVMS, you can post them here. Metalink is usually the best place to look for info on using Oracle on OpenVMS For backup, just use a BACKUP/IGNORE=INTERLOCK if you do online backups. The rest is as it is on all other platforms. Regards, -- Syltrem OpenVMS 7.3-1 + Oracle 8.1.7.4 / 9.2.0.4 http://pages.infinit.net/syltrem (OpenVMS related web site, en fran�ais) ---zulu is not in my email address--- "Mario" <mario.jaksic@zg.htnet.hr> a �crit dans le message de news:cdb2nl$9f5$1@ls219.htnet.hr... > Hi guys, > > please, do you know any good site where I can find information about Oracle > on the OpenVMS platform? The Oracle documentati...

Web resources about - verifiing 8.1.7.4.1 upgrade to 8.1.7.4.x - comp.databases.oracle.server

Resources last updated: 3/20/2016 7:44:46 AM