Temporary Tablespace Logging Problem
Title: Temporary Tablespace Logging Problem Hi all, Is there a way to alter a TEMPORARY table space to Logging from NoLogging. I issue the command, ALTER TABLESPACE TEMPORARY LOGGING; The same command holds good for every other tablespace except for Temporary. I need to this because I wanted to setup the Standby database and was trying to copy the datafiles from the primary site to the Standby site, Online. For that I had put every tablespace in BEGIN BACKUP mode but Temporary couldn't be taken to the Backup Mode becuase of its Nologging attribute. The work around is to create another temporary tablespace and change every users default temporary tablespace to the new one and then drop this one and create a new Temporary file withthe same name. (or shutdown the database and then copy this file tothe other system) THis I will do becuase of the entry in the control file with the name for the Temporary tablespace. But if there is a way the tablespace can be altered to logging, it will save quite some time. The tablespace is Locally Managed, and with Uniform Storage allocation. (Oracle 8.1.7 on WINNT4) Regards Hussain DBA SKMCH RC
Temporary Tablespace Problem
Title: Temporary Tablespace Problem Hi all, Is there a way to alter a TEMPORARY table space to Logging from NoLogging. I issue the command, ALTER TABLESPACE TEMPORARY LOGGING; The same command holds good for every other tablespace except for Temporary. I need to this because I wanted to setup the Standby database and was trying to copy the datafiles from the primary site to the Standby site, Online. For that I had put every tablespace in BEGIN BACKUP mode but Temporary couldn't be taken to the Backup Mode becuase of its Nologging attribute. The work around is to create another temporary tablespace and change every users default temporary tablespace to the new one and then drop this one and create a new Temporary file withthe same name. (or shutdown the database and then copy this file tothe other system) THis I will do becuase of the entry in the control file with the name for the Temporary tablespace. But if there is a way the tablespace can be altered to logging, it will save quite some time. The tablespace is Locally Managed, and with Uniform Storage allocation. (Oracle 8.1.7 on WINNT4) Regards Hussain DBA SKMCH RC
Re: Oracle related docs/OCP materials
I also found the site not useful. it did not have any documentation/tutorials at all. regards,Santosh Varma
Inserts with different conditions in pl/sql
Hallo, How can I write in a pl/sql block if I want to do an insert from one table to another table and at the same time translate the value '?' to 98 and the value 'X' to 'Missing info' Both those values can exist in the first table. The datatyupe in table one is varchar2 and in table two it is numberdatatype. Please help me. Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Login Scripts
Hi, Create your own script and give it an easy name (let's say C.sql) and put in in the directory specified in registry key SQL_PATH. This script could look something like * connect 1; @d:\oracle\ora80\plus80\glogin.sql; Modify to reflect the proper path!!! now you can change connection by typing: @c user/password@database Jack Kevin Lange [EMAIL PROTECTED]@fatcity.com on 12-11-2001 20:45:23 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hey gang; Is there any way to get your login script to run whenever the connection is change instead of just when sqlplus starts up ?? I have a script that displays the instance name when I log in but when I do a connect after sqlplus is already started it does not change. I can manually change it by running the login script myself, but I would like a way for that to be automatically . Oracle 8.0.5 Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Antwort: ORA - 12560: TNS: protocol adapter error
Hire an Oracle DBA, I believe they are a few knocking about twiddling their thumbs at the moment. :-) -Original Message- Sent: 13 November 2001 06:00 To: Multiple recipients of list ORACLE-L Environment variable ORACLE_SID not defined is the message i get. What should i do? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 10:40 AM What OS r u using? If its Windows use the comman set and look for ORACLE_SID If its Unix use the command env | grep -i oracle_sid Regards, Sujatha -Original Message- Sent: Tuesday, 13 November 2001 2:50 PM To: Multiple recipients of list ORACLE-L I am not sure if i have set ORACLE_SID, how could i check if it is set? If it is not set, how do i set it and i set it to what? Thanx in advance Jyotinarayan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 6:20 PM Hi did you set ORACLE_SID in your environment or registry? Ivo S.Jyotinaray an An: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ncjyoti@yahoKopie: o.com Thema: ORA - 12560: TNS: protocol adapter error Gesendet von: root@fatcity. com 11/12/2001 10:30 AM Bitte antworten an ORACLE-L Hi, I have installed your Oracle 8i EE trial software. When i am trying to connect through SQLPLUS with username: SCOTT and password: TIGER i am getting the following error :- ORA - 12560: TNS: protocol adapter error. Could you tell why i am getting this error? What other information should i provide you? Thanx in advance Jyotinarayan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S.Jyotinarayan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S.Jyotinarayan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is
Re: Insert into ... as select ...
Hi Both 'DATE_AQUISITION' and 'JOUR' are date fields. Why would you want to add hour and minute to a field that already contains this information? Jack [EMAIL PROTECTED] (Jean Berthold)@fatcity.com on 12-11-2001 16:05:22 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Hello everybody, I have a problem to find the correct syntax for the following operation: The first table: SQL describe grandeur_mesure; Name Null?Type - ID_GRANDEUR NOT NULL NUMBER(15) JOUR NOT NULL DATE HEURE NOT NULL NUMBER(15) MINUTENOT NULL NUMBER(15) VALEUR FLOAT(126) VALIDITE NUMBER(1) ACQUISITIONNUMBER(15) UTILISATIONNUMBER(15) SQL The second table: -- SQLWKS describe grandeur_mesure2 Nom de la colonne Null?Type -- ID_GRANDEURNOT NULL NUMBER(15) DATE_AQUISITIONNOT NULL DATE VALEUR FLOAT VALIDITENUMBER(1) ID_TYPE_ACQUISITION NUMBER(15) UTILISATION NUMBER(15) ID_COMPTEUR NUMBER(15) ID_TYPE_GRANDEURNUMBER(15) ID_UNITENUMBER(1 I try to insert all the rows from the first table into the second table and concat the following fields: describe grandeur_mesure.JOUR describe grandeur_mesure.HEURE describe grandeur_mesure.MINUTE Into: describe grandeur_mesure2.DATE_AQUISITION Please, do you know which is the correct command line ? Thank you for your help ! -- Jean Berthold EOS - energie ouest suisse Chemin de Mornex 10 , CP 570 CH-1001 Lausanne , Switzerland Tel. : +41 (0)21 341 24 58 Fax : +41 (0)21 341 20 49 E-Mail : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jean Berthold INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its
RE: Insert into ... as select ...
I think that it is possible to use the next syntax: insert into grandeur_mesure2 (ID_GRANDEUR,DATE_AQUISITION,VALEUR,VALIDITE,ID_TYPE_ACQUISITION,UTILISATION ) select ( ID_GRANDEUR, to_char(JOUR,'DD')||' '||to_char(HEURE,'HH24')||':'||to_char(MINUTE, 'MI'), VALEUR, VALIDITE, ACQUISITION, UTILISATION ) from grandeur_mesure L.Haouhach Ingénieur système Sonatrach Algérie -Message d'origine- De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Date: lundi 12 novembre 2001 15:05 À:Multiple recipients of list ORACLE-L Objet:Insert into ... as select ... Hello everybody, I have a problem to find the correct syntax for the following operation: The first table: SQL describe grandeur_mesure; Name Null?Type - ID_GRANDEUR NOT NULL NUMBER(15) JOUR NOT NULL DATE HEURE NOT NULL NUMBER(15) MINUTENOT NULL NUMBER(15) VALEUR FLOAT(126) VALIDITE NUMBER(1) ACQUISITIONNUMBER(15) UTILISATIONNUMBER(15) SQL The second table: -- SQLWKS describe grandeur_mesure2 Nom de la colonne Null?Type -- ID_GRANDEURNOT NULL NUMBER(15) DATE_AQUISITIONNOT NULL DATE VALEUR FLOAT VALIDITENUMBER(1) ID_TYPE_ACQUISITION NUMBER(15) UTILISATION NUMBER(15) ID_COMPTEUR NUMBER(15) ID_TYPE_GRANDEURNUMBER(15) ID_UNITENUMBER(1 I try to insert all the rows from the first table into the second table and concat the following fields: describe grandeur_mesure.JOUR describe grandeur_mesure.HEURE describe grandeur_mesure.MINUTE Into: describe grandeur_mesure2.DATE_AQUISITION Please, do you know which is the correct command line ? Thank you for your help ! -- Jean Berthold EOS - energie ouest suisse Chemin de Mornex 10 , CP 570 CH-1001 Lausanne , Switzerland Tel. : +41 (0)21 341 24 58 Fax : +41 (0)21 341 20 49 E-Mail : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jean Berthold INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SIM/HAOUHACH INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Inserts with different conditions in pl/sql
INSERT INTO target_table (target_column) SELECT decode(source_column, '?', 98, 'X', NULL, source_column) FROM source_table; 1. This isn't pl/sql, just pure insert statement 2. If datatype of target_column is Number You cannot insert 'Missing info' in this column, use NULLs instead 3. If You don't know what decode does look into docs Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Inserts with different conditions in pl/sql om 2001.11.13 10:20 Please respond to ORACLE-L Hallo, How can I write in a pl/sql block if I want to do an insert from one table to another table and at the same time translate the value '?' to 98 and the value 'X' to 'Missing info' Both those values can exist in the first table. The datatyupe in table one is varchar2 and in table two it is numberdatatype. Please help me. Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i install on Win2K
Thanks Scott, I tried the suggestions below that I hadn't already done, and still got no joy :( Cheers for your help anyway! Mark -Original Message- Sent: 13 November 2001 04:40 To: Multiple recipients of list ORACLE-L Mark, It looks like you have already read up on this problem, but here is some more info if you need it. The problem is with the symcjit.dll. The DLL does a CPUID detection for Intel. Intel has it documented at http://developer.intel.com/design/processor/future/manuals/knownissue.htm . Here are some possible solutions I found in a bulliten (some you tried). This info appears to be from 8i Not only will OUI be affected by this bug, most of the post-install configuration tools will also be affected. Running these tools with -nojit specified will avoid the hang, but it is not simple to specify -nojit for some of the products. WORKAROUND: To avoid the hang in the installation itself, do the following: a. Copy the install directory from the CD to the hard disk say, e:\temp. b. Open oraparam.ini and make the following modifications (Assuming CD drive is f:) * Change the SOURCE= line to use the full path to the CD instead of a relative path. (i.e. SOURCE=f:/stage/products.jar) * Change the JRE_LOCATION line to use the full path to the CD instead of a relative path. (i.e. JRE_LOCATION=f:/stage/Components/oracle/swd/jre/1.1.7/1/DataFiles/Expanded) * Change the OUI_LOCATION line to use the full path to the CD instead of a relative path. (i.e. OUI_LOCATION=f:/stage/Components/oracle/swd/oui/1.6.0.9.0/1/DataFiles/Expand ed * Change the JRE_MEMORY_OPTIONS line to add -nojit as the first argument. (i.e. JRE_MEMORY_OPTIONS=-nojit -ms16m -mx32m) ^^ * Other entries should remain the same . c. Launch setup.exe from the temporary location on your hard drive (i.e. e:\temp\install\win32\setup.exe). This will use the modified oraparam.ini and pick up the information from the CD since the absolute locations are specified. . Choose a Custom install and choose not to create a database during the install. This way, the Database Configuration Assistant will not be launched during installation. The Net8 Configuration Assistant will still be launched, and there is no way to suppress it. You will need to kill the Net8 Configuration Assistant if it hangs due to the bug. The installation still will have been successful, and you can run the DBCA and NetCA after installation. To kill NetCA if it hangs during installation: In the Configuration Tools window, highlight the Net8 Configuration Assistant and click Stop. If that does not work, look for the most recent JRE process using the Task Manager, and kill it manually. NOTE: the OUI itself will also have a jre process. Be sure to kill the one with the most recent date, which should be the jre process being used for Net8CA, not the one for OUI itself. After killing the configuration tools and continuing through the installation to the End of Installation screen, you should modify the configuration tools to use -nojit, then call the appropriate tools from the Start Menu. For each of the following files in the ORACLE_HOME: assistants\dbca\dbassist.cl assistants\dbma\dbmig.cl assistants\ifa\ifa.cl @ bin\elogin.cl bin\owm.cl ldap\oidamdin\oidadmin.cl network\tools\netasst.cl network\tools\netca.cl @ owm\install\instelogin.cl owm\install\instowm.cl . Edit the contents of the file to add -nojit as shown below: Command=(C:\Program Files\Oracle\jre\1.1.7\BIN\JREW -nojit -classpath this is the only thing you need to add -- ^^ . Then, launch the necessary tools, like Net8CA and DBCA from the Start Menu. Replace the existing symcjit.dll with the new one from the jre-1_2_2_007. This version 3.10.0.107 has the fix for the Pentium 4's. You also need to take the jvm.dll file from that same jre installation and copy it into the same location as the symcjit.dll. I am not sure why you need that, but when you run the installer and that file is not present Windows barks that it cannot find jvm.dll - Although it still runs the installer without it. Another Workaround Exists for the Oracle Universal Installer: 1. Create a temporary directory on your server. 2. Copy the contents of the Oracle Server CD to the temporary directory created in step 1. 3. Search the directory structure created in step 1 for the existence of the filename symcjit.dll. 4. Rename each copy of the symcjit.dll to symcjit.old. 5. Run the setup.exe from the \install\win32 directory and install I don't have a P4 so I have no idea if any of these will work. Good Luck, Scott -Original Message- Sent: Monday, November 12, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi ladies gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to install 9i on to. PC is as follows: P4 1.3 gig 256Mb
Re: 9i install on Win2K
Mark, RH 7.1 IS now a supported platform, i was looking on metalstink for something else yesterda and found it there, they even have a document on how to get around the install problems. let me know if you want the info, i'll email it to ya when i get to work. joe -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i install on Win2K
Mark, Have you tried removing the classpath env variable before starting the OUI? Is there anything in the installActions.log? What about in tempdir\ORAINSTALL\LOG ? HTH, -- Anita --- Mark Leith [EMAIL PROTECTED] wrote: Oh, don't worry I know where your coming from ;) I have considered doing this - though I have RedHat 7.1. and I'm a bit dubious of putting 9i on an Unsupported platform.. The other reason is that I have the install CDs for NT/2000 and not LINUX :0( Win2K is our standard desktop, where we run our business applications, so I have use it all day really - I would prefer to have a local database to test, run through (while walking products through), and break while trying to answer question to this list : It's doesn't seem like its going to happen though :( Now - I have to ask the question - Have you *tried* to install 9i on your Win2K partition? Cheers Mark -Original Message- Gerardo Sent: 13 November 2001 01:30 To: Multiple recipients of list ORACLE-L Not trying to be funny Mark but... any reason why you don't want to set up a Suse linux partition on your 40Gb hard drive and run 9i (Linux version)? I have W2k in one partition on my P4 system and Suse 7.1 (kernel 2.4.7) running 9i in another partition. The problem is I can't run W2K and access the Oracle database at the same time. But if you don't have this requirement, then this would be a good workaround. HTH Gerardo -Original Message- Sent: Monday, November 12, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi ladies gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to install 9i on to. PC is as follows: P4 1.3 gig 256Mb RAM (Only a test box) 40 gig HD Win2K SP2 Now, I have the 9i install CDs (Thanks Joe!), but am unable to actually get the *JAVA BLOODY INSTALLER* (why don't they keep it simple eh?!?!) working! The autorun program starts, but when I try to kick it in to the Java installer (Install/Deinstall Products) I get the following error: The Java RunTime Environment was not found at C:\DOCUME~1\MARKLE~1\LOCALS~1\Temp\OraInstall\jre\binjrew.exe. Hence, the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.1.7 or higher and try again. Now, my java environment (actually JRE 1.3.1) is installed in it's normal place - C:\Program Files\Javasoft\JRE\1.3.1\.. In the Oracle Installation Guide it also says - Oracle Universal Installer automatically installs Oracle's version of the Java Runtime Environment (JRE). This version is required to run Oracle Universal Installer and several Oracle assistants. Do not modify the JRE, unless doing so with a patch provided by OracleMetaLink. Visit: It is plainly not doing this at all! Now, I remembered that I had the exact same problem when installing the 8.1.7 client on to this machine (before it had a new Hard Drive), and the solution (provided by Larry Strickland) was that they had a faulty dll (symcjit.dll) that had to be replaced in the install directories from the CD. Larry also provided me with a copy of the new dll.. I copied the entire contents of the install CDs to my HD, and searched for this particular dll, and guess what? I found it, twice, and both versions had different modification dates - and here's the best bit - and they were BOTH still older than the version supplied by Larry! (Strickland that is :)) Nothing like keeping up to date is there? :) I copied over the old versions with the new version - but have still had no joy :( I keep getting the exact same error. I've even copied the contents of Disk1\RR_MOVED\JRE\WIN32\BIN (where one of the symcjit.dll files actually was) in to the temp orainstall directory, and modified the path accordingly, I then get no error at all, but the installer just disappears, and nothing happens!! Any ideas?? Mark __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle related docs/OCP materials
Yea, I also have to agree - Not impressed.. I have considered putting together a web site of my own which attempts to pull resources/scripts together also, and have to say that even on my pilot run (which didn't go live :0) ) had more info than this site! Take a look at a few pages that are already out there (and successful) like http://www.freetechnicaltraining.com(Ethan Posts web site) to get a good idea of how to go about setting your web site up. HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Santosh VarmaSent: 13 November 2001 07:55To: Multiple recipients of list ORACLE-LSubject: Re: Oracle related docs/OCP materials I also found the site not useful. it did not have any documentation/tutorials at all. regards,Santosh Varma
Where are the Import/Export utilities in 9i
Hi All, I have just installed Oracle 9i server on a test machine and I cannot find the import/export utilities. There is no EM like version 8 or DBA studio as in 8i. I started EM console and saw wizards but I always get wizard can only be used while connected to oracle management server. I have never needed this before. How can I just do a simple import/export? Oracle 9i/Win 2k environment Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to drive down just to meet the guy) in San Antonio can give us a more regional perspective. At the height of the frenzy, I know a bunch of people who left positions in SA to come to Austin. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Troiano, Paul (CAP, GEFA) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Paul.Troiano@geca cc: pital.com Subject: RE: Help!: Job Description for Data Architect Sent by: [EMAIL PROTECTED] 11/12/2001 05:40 PM Please respond to ORACLE-L How is the job market in Austin? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Hey, the job market isn't any better
RE: Sqlloader
Hi Roland, Try using the DECODE statement rather than TRANSLATE: BUT_OMS DECODE(:BUT_OMS, '!','99','?','No Info',:BUT_OMS), The above says: Ifthe value of BUT_OMS='!', change it to '99', elsif the value of BUT_OMS='?', change it to 'No Info', else insert the value provided. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 3:00 AM To: Multiple recipients of list ORACLE-L Hallo all you DBA's How do I write in sqlloader if i want to replace, translate the caracter ? with 'No info' and the character ! with the value '99'. I have this statement already. BUT_OMS TRANSLATE(:BUT_OMS, '!','99'), Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: 9i install on Win2K
Anita, No I haven't tried this (classpath) - how do I go about doing this? Under the ORAINSTALL directory in my temp path the only folder that gets created is the Images directory with the image files listed in the ORAPARAM.ini file in it, nothing else gets created? In the ORAPARAM file I have: ---snip--- [Oracle] DISTRIBUTION=TRUE SOURCE=../stage/products.jar LICENSE_LOCATION= JRE_LOCATION=../stage/Components/oracle.swd.jre/1.1.8.10.0/1/DataFiles/Expan ded/jre OUI_LOCATION=../stage/Components/oracle.swd.oui/2.0.1.6.0/1/DataFiles/Expand ed JRE_MEMORY_OPTIONS= -mx48m DEFAULT_HOME_LOCATION=\oracle\ora90 DEFAULT_HOME_NAME=OraHome90 NO_BROWSE= HLP_LOCATION= EWT_LOCATION= NLS_ENABLED=TRUE BOOTSTRAP=TRUE [IMAGES] FILE1=images/o9i_1.gif FILE2=images/o9i_2.gif FILE3=images/o9i_3.gif FILE4=images/o9i_4.gif FILE5=images/o9i_5.gif FILE6=images/o9i_6.gif FILE7=images/o9i_7.gif FILE8=images/o9i_8.gif ---snip--- Now, on further investigation I have found that there is infact no such directory as /stage/Components/ in any of the install sets (disk1,23), it is diskX/STAGE/COMPONEN/blah... and likewise underneath all of these directories there is no such directory like /oracle.swd.jre/ or /oracle.swd.oui/ so I think this is in fact the root of the problem: C:\SAVE\Disk1\STAGE\COMPONENdir Volume in drive C has no label. Volume Serial Number is 40B2-B437 Directory of C:\SAVE\Disk1\STAGE\COMPONEN 12/11/2001 12:41 DIR . 12/11/2001 12:41 DIR .. 12/11/2001 12:41 DIR LBAC 12/11/2001 12:41 DIR ORACL000.APP 12/11/2001 12:41 DIR ORACL000.CLI 12/11/2001 12:41 DIR ORACL000.COM 12/11/2001 12:41 DIR ORACL000.CPL 12/11/2001 12:41 DIR ORACL000.DBA 12/11/2001 12:41 DIR ORACL000.DIA 12/11/2001 12:41 DIR ORACL000.EXP 12/11/2001 12:41 DIR ORACL000.HS_ 12/11/2001 12:41 DIR ORACL000.IMC 12/11/2001 12:41 DIR ORACL000.JAV 12/11/2001 12:41 DIR ORACL000.JDB 12/11/2001 12:41 DIR ORACL000.MSS 12/11/2001 12:41 DIR ORACL000.NET 12/11/2001 12:41 DIR ORACL000.NLS 12/11/2001 12:41 DIR ORACL000.OCI 12/11/2001 12:41 DIR ORACL000.OPS 12/11/2001 12:41 DIR ORACL000.ORD 12/11/2001 12:41 DIR ORACL000.OTR 12/11/2001 12:41 DIR ORACL000.PAG 12/11/2001 12:41 DIR ORACL000.PLS 12/11/2001 12:41 DIR ORACL000.PRO 12/11/2001 12:41 DIR ORACL000.SQL 12/11/2001 12:41 DIR ORACL000.TG4 12/11/2001 12:41 DIR ORACL000.THI 12/11/2001 12:41 DIR ORACL000.UTI 12/11/2001 12:41 DIR ORACL000.WEB 12/11/2001 12:40 DIR ORACL001.CLI 12/11/2001 12:40 DIR ORACL001.COM 12/11/2001 12:40 DIR ORACL001.HS_ 12/11/2001 12:40 DIR ORACL001.JAV 12/11/2001 12:40 DIR ORACL001.JDB 12/11/2001 12:40 DIR ORACL001.NET 12/11/2001 12:40 DIR ORACL001.NLS 12/11/2001 12:40 DIR ORACL001.OCI 12/11/2001 12:40 DIR ORACL001.ORD 12/11/2001 12:40 DIR ORACL001.PLS 12/11/2001 12:40 DIR ORACL001.PRO 12/11/2001 12:40 DIR ORACL001.SQL 12/11/2001 12:40 DIR ORACL001.TG4 12/11/2001 12:40 DIR ORACL002.CLI 12/11/2001 12:40 DIR ORACL002.HS_ 12/11/2001 12:40 DIR ORACL002.NET 12/11/2001 12:40 DIR ORACL002.ORD 12/11/2001 12:40 DIR ORACL002.SQL 12/11/2001 12:40 DIR ORACL003.HS_ 12/11/2001 12:40 DIR ORACL003.NET 12/11/2001 12:40 DIR ORACL003.ORD 12/11/2001 12:40 DIR ORACL003.SQL 12/11/2001 12:40 DIR ORACL004.ORD 12/11/2001 12:40 DIR ORACLE.APA 12/11/2001 12:40 DIR ORACLE.BC4 12/11/2001 12:40 DIR ORACLE.CLI 12/11/2001 12:40 DIR ORACLE.EMC 12/11/2001 12:40 DIR ORACLE.EMP 12/11/2001 12:40 DIR ORACLE.INF 12/11/2001 12:40 DIR ORACLE.NET 12/11/2001 12:40 DIR ORACLE.OID 12/11/2001 12:40 DIR ORACLE.OIS 12/11/2001 12:40 DIR ORACLE.OMW 12/11/2001 12:40 DIR ORACLE.OPT 12/11/2001 12:40 DIR ORACLE.P2K 12/11/2001 12:40 DIR ORACLE.RDB 12/11/2001 12:40 DIR ORACLE.RSF 12/11/2001 12:40 DIR ORACLE.SER 12/11/2001 12:40 DIR ORACLE.TG 12/11/2001 12:40 DIR ORACLE.UTI 12/11/2001 12:40 DIR ORACLE.WIN 12/11/2001 12:40 DIR ORACLE.WOR 12/11/2001 12:40 DIR ORACLE_A.ACF 12/11/2001 12:40 DIR ORACLE_A.APA
RE: ORADIM
Ken
OraDim exists in the $ORACLE_HOME/bin directory. It gets installed when you
install the RDBMS software.
Check your system path on the machine. It should include this directory.
You could, of course, run the command as:
set oracle_home={your oracle home}
{your oracle home}\bin\oradim
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, November 12, 2001 5:20 PM
To: Multiple recipients of list ORACLE-L
I tried to use ORADIM to administer my Oracle instance and I cannot get it
at the C:\ prompt. How do I get this tool installed?
Thanks,
Ken
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
IMP-00037 Character marker set unknown
Hi DBAs, I trying to import uncorrupted 8.0.5 export into a Oracle 9i database. I get a IMP-00037 Character marker set unknown. MetaLink says it may be corrupted. It is not so anyone have any other suggestions? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i New Features
Hi, Is there a good document somewhere explaining the new features in Oracle 9i? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: 9i install on Win2K (an update)
I've now gotten 1 step further. I've found the location off the OUI: 12/11/2001 12:37 DIR ORACLE_S.OUI Which is in C:\SAVE\Disk1\STAGE\COMPONEN\. I modified the ORAPARAM.ini file to reflect this, and it seems it got one step further, as it created an OUI directory along with the Images one under OraInstall under temp. But still errored out with the Original error of not having the JREW program. The path that was supposed to be pointing to the JRE_LOCATION actually should have been (it *seems*): C:\SAVE\Disk1\STAGE\COMPONEN\ORACLE_S.JRE\1.1.8.10.0\1\DataFiles\Expanded\jr e But this points to a completely empty file (0 bits), and hence, did not work :) Finally I took a complete copy of the contents of: C:\SAVE\Disk1\RR_MOVED\JRE\WIN32\BIN which holds the JRE, JREW etc. programs, and put them directly in to the OraInstall directory under temp. This does in fact suppress the error.. But again, the OUI does not appear.. It just goes west.. I'm close to giving up now :P Mark -Original Message- Sent: 13 November 2001 12:04 To: A. Bardeen Anita, No I haven't tried this (classpath) - how do I go about doing this? Under the ORAINSTALL directory in my temp path the only folder that gets created is the Images directory with the image files listed in the ORAPARAM.ini file in it, nothing else gets created? In the ORAPARAM file I have: ---snip--- [Oracle] DISTRIBUTION=TRUE SOURCE=../stage/products.jar LICENSE_LOCATION= JRE_LOCATION=../stage/Components/oracle.swd.jre/1.1.8.10.0/1/DataFiles/Expan ded/jre OUI_LOCATION=../stage/Components/oracle.swd.oui/2.0.1.6.0/1/DataFiles/Expand ed JRE_MEMORY_OPTIONS= -mx48m DEFAULT_HOME_LOCATION=\oracle\ora90 DEFAULT_HOME_NAME=OraHome90 NO_BROWSE= HLP_LOCATION= EWT_LOCATION= NLS_ENABLED=TRUE BOOTSTRAP=TRUE [IMAGES] FILE1=images/o9i_1.gif FILE2=images/o9i_2.gif FILE3=images/o9i_3.gif FILE4=images/o9i_4.gif FILE5=images/o9i_5.gif FILE6=images/o9i_6.gif FILE7=images/o9i_7.gif FILE8=images/o9i_8.gif ---snip--- Now, on further investigation I have found that there is infact no such directory as /stage/Components/ in any of the install sets (disk1,23), it is diskX/STAGE/COMPONEN/blah... and likewise underneath all of these directories there is no such directory like /oracle.swd.jre/ or /oracle.swd.oui/ so I think this is in fact the root of the problem: C:\SAVE\Disk1\STAGE\COMPONENdir Volume in drive C has no label. Volume Serial Number is 40B2-B437 Directory of C:\SAVE\Disk1\STAGE\COMPONEN 12/11/2001 12:41 DIR . 12/11/2001 12:41 DIR .. 12/11/2001 12:41 DIR LBAC 12/11/2001 12:41 DIR ORACL000.APP 12/11/2001 12:41 DIR ORACL000.CLI 12/11/2001 12:41 DIR ORACL000.COM 12/11/2001 12:41 DIR ORACL000.CPL 12/11/2001 12:41 DIR ORACL000.DBA 12/11/2001 12:41 DIR ORACL000.DIA 12/11/2001 12:41 DIR ORACL000.EXP 12/11/2001 12:41 DIR ORACL000.HS_ 12/11/2001 12:41 DIR ORACL000.IMC 12/11/2001 12:41 DIR ORACL000.JAV 12/11/2001 12:41 DIR ORACL000.JDB 12/11/2001 12:41 DIR ORACL000.MSS 12/11/2001 12:41 DIR ORACL000.NET 12/11/2001 12:41 DIR ORACL000.NLS 12/11/2001 12:41 DIR ORACL000.OCI 12/11/2001 12:41 DIR ORACL000.OPS 12/11/2001 12:41 DIR ORACL000.ORD 12/11/2001 12:41 DIR ORACL000.OTR 12/11/2001 12:41 DIR ORACL000.PAG 12/11/2001 12:41 DIR ORACL000.PLS 12/11/2001 12:41 DIR ORACL000.PRO 12/11/2001 12:41 DIR ORACL000.SQL 12/11/2001 12:41 DIR ORACL000.TG4 12/11/2001 12:41 DIR ORACL000.THI 12/11/2001 12:41 DIR ORACL000.UTI 12/11/2001 12:41 DIR ORACL000.WEB 12/11/2001 12:40 DIR ORACL001.CLI 12/11/2001 12:40 DIR ORACL001.COM 12/11/2001 12:40 DIR ORACL001.HS_ 12/11/2001 12:40 DIR ORACL001.JAV 12/11/2001 12:40 DIR ORACL001.JDB 12/11/2001 12:40 DIR ORACL001.NET 12/11/2001 12:40 DIR ORACL001.NLS 12/11/2001 12:40 DIR ORACL001.OCI 12/11/2001 12:40 DIR ORACL001.ORD 12/11/2001 12:40 DIR ORACL001.PLS 12/11/2001 12:40 DIR ORACL001.PRO 12/11/2001 12:40 DIR ORACL001.SQL 12/11/2001 12:40 DIR ORACL001.TG4 12/11/2001 12:40 DIR ORACL002.CLI 12/11/2001 12:40 DIR ORACL002.HS_ 12/11/2001 12:40 DIR ORACL002.NET 12/11/2001 12:40 DIR ORACL002.ORD 12/11/2001 12:40 DIR ORACL002.SQL 12/11/2001 12:40 DIR ORACL003.HS_ 12/11/2001 12:40 DIR ORACL003.NET 12/11/2001 12:40 DIR ORACL003.ORD 12/11/2001 12:40 DIR
PLsql question
Hallo, How can I write in apl/sql code if I want to make an insert from table one into table two and in one of the fields delete the space in front of the first blank. For instance It says 1 John 2 Frederic 99 Jimmy in table one and I want the pl/sql code to delete the values in front of the names wheninserted into table two so in table two it would be: just : John Frederic Jimmy Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i install on Win2K
Hi Mark, Haven't followed your thread but I installed O9i on W2K with 512MB RAM and it was a breeze. I did use the preconfigured database though (could not be bothered going through the dbassistant for a play database) What is the problem, do you need a copy of the LINUX CD's? How's your golf handicap by now? take care Jack Mark Leith [EMAIL PROTECTED]@fatcity.com on 13-11-2001 11:15:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oh, don't worry I know where your coming from ;) I have considered doing this - though I have RedHat 7.1. and I'm a bit dubious of putting 9i on an Unsupported platform.. The other reason is that I have the install CDs for NT/2000 and not LINUX :0( Win2K is our standard desktop, where we run our business applications, so I have use it all day really - I would prefer to have a local database to test, run through (while walking products through), and break while trying to answer question to this list : It's doesn't seem like its going to happen though :( Now - I have to ask the question - Have you *tried* to install 9i on your Win2K partition? Cheers Mark -Original Message- Gerardo Sent: 13 November 2001 01:30 To: Multiple recipients of list ORACLE-L Not trying to be funny Mark but... any reason why you don't want to set up a Suse linux partition on your 40Gb hard drive and run 9i (Linux version)? I have W2k in one partition on my P4 system and Suse 7.1 (kernel 2.4.7) running 9i in another partition. The problem is I can't run W2K and access the Oracle database at the same time. But if you don't have this requirement, then this would be a good workaround. HTH Gerardo -Original Message- Sent: Monday, November 12, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi ladies gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to install 9i on to. PC is as follows: P4 1.3 gig 256Mb RAM (Only a test box) 40 gig HD Win2K SP2 Now, I have the 9i install CDs (Thanks Joe!), but am unable to actually get the *JAVA BLOODY INSTALLER* (why don't they keep it simple eh?!?!) working! The autorun program starts, but when I try to kick it in to the Java installer (Install/Deinstall Products) I get the following error: The Java RunTime Environment was not found at C:\DOCUME~1\MARKLE~1\LOCALS~1\Temp\OraInstall\jre\binjrew.exe. Hence, the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.1.7 or higher and try again. Now, my java environment (actually JRE 1.3.1) is installed in it's normal place - C:\Program Files\Javasoft\JRE\1.3.1\.. In the Oracle Installation Guide it also says - Oracle Universal Installer automatically installs Oracle's version of the Java Runtime Environment (JRE). This version is required to run Oracle Universal Installer and several Oracle assistants. Do not modify the JRE, unless doing so with a patch provided by OracleMetaLink. Visit: It is plainly not doing this at all! Now, I remembered that I had the exact same problem when installing the 8.1.7 client on to this machine (before it had a new Hard Drive), and the solution (provided by Larry Strickland) was that they had a faulty dll (symcjit.dll) that had to be replaced in the install directories from the CD. Larry also provided me with a copy of the new dll.. I copied the entire contents of the install CDs to my HD, and searched for this particular dll, and guess what? I found it, twice, and both versions had different modification dates - and here's the best bit - and they were BOTH still older than the version supplied by Larry! (Strickland that is :)) Nothing like keeping up to date is there? :) I copied over the old versions with the new version - but have still had no joy :( I keep getting the exact same error. I've even copied the contents of Disk1\RR_MOVED\JRE\WIN32\BIN (where one of the symcjit.dll files actually was) in to the temp orainstall directory, and modified the path accordingly, I then get no error at all, but the installer just disappears, and nothing happens!! Any ideas?? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to drive down just to meet the guy) in San Antonio can give us a more regional perspective. At the height of the frenzy, I know a bunch of people who left positions in SA to come to Austin. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Troiano, Paul (CAP, GEFA) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Paul.Troiano@geca
Re: 9i install on Win2K
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 13:20 Mark, RH 7.1 IS now a supported platform, i was looking on metalstink for something else yesterda and found it there, they even have a document on how to get around the install problems. let me know if you want the info, i'll email it to ya when i get to could u point to specific reference to MetaLink or TechNet that says RH is certified with 9i? The docs on TechNet still say only SuSE 7.x is supported, and searches on MetaLink returned only references to problems with RH7.1 which will only make me never mess with it thanx, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Where are the Import/Export utilities in 9i
Do you have access to the operating system command line? imp help=y orexp help=y will give you the syntaxt to use at the command line. Cherie Machler Oracle DBA Gelco Information Network Cale, Rick T (Richard)To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] RICHARD.T.CALE cc: @saic.comSubject: Where are the Import/Export utilities in 9i Sent by: [EMAIL PROTECTED] m 11/13/01 06:55 AM Please respond to ORACLE-L Hi All, I have just installed Oracle 9i server on a test machine and I cannot find the import/export utilities. There is no EM like version 8 or DBA studio as in 8i. I started EM console and saw wizards but I always get wizard can only be used while connected to oracle management server. I have never needed this before. How can I just do a simple import/export? Oracle 9i/Win 2k environment Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i certification for RH 7.1 location
login into metalink menu of left, product lifecycle certifications(on top) by platform intel based linux oracle server enterprise edition 9.0.1 click on submit or the tab at each of the previous screens. joe --- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) IM: JoeN8XCT or N8XCTHOME - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 13:20 Mark, RH 7.1 IS now a supported platform, i was looking on metalstink for something else yesterda and found it there, they even have a document on how to get around the install problems. let me know if you want the info, i'll email it to ya when i get to could u point to specific reference to MetaLink or TechNet that says RH is certified with 9i? The docs on TechNet still say only SuSE 7.x is supported, and searches on MetaLink returned only references to problems with RH7.1 which will only make me never mess with it thanx, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partly OT: Developer seeks job
Hi, I am from India. Due to downsizing by an MNC, I am in search of job as a Developer/ Analyst Programmer/Systems Analyst. I am proficient in Oracle, PL/SQL, Developer 2000 Products. I am an Oracle Certified Application Developer and Part DBA. If any of you come across any such openings, please send me an mail off the list. I am eligible to work in U.S.A and Australia and India. I am posting this here as it get noticed by a lot of Oracle professionals. Sorry for posting this here. Please bear with me. Thanks, Muths _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muthaiah INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i New Features
Bill, I've found the following to be useful: http://technet.oracle.com/products/oracle9i/daily/content.html Also try: http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90120/to c.htm And of course, Joe's weekly test drive is helpful. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carle, William T (Bill), NLCIO Sent: Tuesday, November 13, 2001 8:05 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i New Features Hi, Is there a good document somewhere explaining the new features in Oracle 9i? Bill Carle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ang: RE: Sqlloader
Why does this sqlloader ctl file giveme this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S Mercadante, Thomas F [EMAIL PROTECTED]@fatcity.com den 2001-11-13 05:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi Roland, Try using the DECODE statement rather than TRANSLATE: BUT_OMS DECODE(:BUT_OMS, '!','99','?','No Info',:BUT_OMS), The above says: Ifthe value of BUT_OMS='!', change it to '99', elsif the value of BUT_OMS='?', change it to 'No Info', else insert the value provided. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 3:00 AM To: Multiple recipients of list ORACLE-L Hallo all you DBA's How do I write in sqlloader if i want to replace, translate the caracter ? with 'No info' and the character ! with the value '99'. I have this statement already. BUT_OMS TRANSLATE(:BUT_OMS, '!','99'), Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i New Features
Bill, How about an entire manual? ;) Oracle9i Database New Features Release 1 (9.0.1) Part Number A90120-02 http://download-east.oracle.com/otndoc/oracle9i/901_doc/server.901/a90120/toc.htm You'll probably need to reformat the URL to one line, or navigate from: http://technet.oracle.com/docs HTH, -- Anita --- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] wrote: Hi, Is there a good document somewhere explaining the new features in Oracle 9i? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i New Features
Apart from Joes excellent mini series that he is currently posting to the list. Try this out for size. http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90117/wh atsnew.htm#968699 Regards Lee -Original Message- Sent: 13 November 2001 14:05 To: Multiple recipients of list ORACLE-L Hi, Is there a good document somewhere explaining the new features in Oracle 9i? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle related docs/OCP materials
these sites contain some resources www.oraclenotes.com http://certcities.com/ http://www.oraclepower.com/ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Santosh VarmaSent: Tuesday, November 13, 2001 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle related docs/OCP materials I also found the site not useful. it did not have any documentation/tutorials at all. regards,Santosh Varma
Re: Database Copy Problem
Thanks to those that responded. This is working now. Someone else here made a mistake and reverted the DB to an old init.ora that was causing this problem. I put in the correct init.ora and everything is working just fine. Best, Ed Used the backup controlfile to trace method to create a copy of a database on the same server. Copied prod to test. Test already existed, but was overwritten by new copy. We are now getting an ORA-01102, cannot mount in EXCLUSIVE mode when trying to open the test database. This is on NT 4.0, Oracle 8.16. Ideas? Thanks. Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PLsql question
Use the INSTR function: select ltrim(substr(field1,instr(field1,' '))) from temp; If field1 is 1 John 2 Frederic 99 Jimmy you will get John Frederic Jimmy -Original Message- Sent: Tuesday, November 13, 2001 8:40 AM To: Multiple recipients of list ORACLE-L Hallo, How can I write in apl/sql code if I want to make an insert from table one into table two and in one of the fields delete the space in front of the first blank. For instance It says 1 John 2 Frederic 99 Jimmy in table one and I want the pl/sql code to delete the values in front of the names wheninserted into table two so in table two it would be: just : John Frederic Jimmy Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? Good Point JeffThat happened to me. My previous company is now starting to feel the same( Within 3 Months..! ). They even told me so...! Hope fully more companies will see the light and this draught of jobs will end. Cheers, RS --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
She is right about the summers but then there is the winters.our highs are in the 70s and low 80s.no snow, sleet maybe once every other year at most. If you go even further south it is like living in Mexiconever getting very cold. I like that. Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 11/13/2001 08:45:24 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to
Re: W2000 Unix Command Equivalent
Install Cygwin, and you have access to a full set of UNIX commands - even a BASH environment. If you add the Cygwin/bin directory to your path, you can sit at the DOS prompt, and run most UNIX commands. You can also execute Windows commands from the BASH shell. I have Oracle 8i and 9i running on W2K, and I've modified some backup scripts to utilize the UNIX commands. You even get the 'man' pages. Jeff [EMAIL PROTECTED] 11/12/01 03:10PM Does anyone know where I can find a list of the W2000 equivalent commands for Unix. Such as show, set, etc. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i install on Win2K
LMFAO!! YEAH RIGHT!!! You know, I am now at the point where I've said Fu*$ it, I'm not going to bother now. I'm now moving to partitioning, and get that LINUX installation up and running.. Yet MORE to learn :( Oh well, I suppose it's not a bad thing though :/ -Original Message- Lee - lerobe Sent: 13 November 2001 15:55 To: Multiple recipients of list ORACLE-L and here was me thinking that 9i made the DBA redundant :-) -Original Message- Sent: 13 November 2001 15:05 To: Multiple recipients of list ORACLE-L - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 13:20 Mark, RH 7.1 IS now a supported platform, i was looking on metalstink for something else yesterda and found it there, they even have a document on how to get around the install problems. let me know if you want the info, i'll email it to ya when i get to could u point to specific reference to MetaLink or TechNet that says RH is certified with 9i? The docs on TechNet still say only SuSE 7.x is supported, and searches on MetaLink returned only references to problems with RH7.1 which will only make me never mess with it thanx, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader - important
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), ^^^ No comma seperating the '98' and the !' Should probably read: (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID), -Original Message- Sent: Tuesday, November 13, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Temporary Tablespace Problem
Title: Temporary Tablespace Problem is the datafile a tempfile for temp tablespace? -Original Message-From: Arslan Dar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 13, 2001 1:30 AMTo: Multiple recipients of list ORACLE-LSubject: Temporary Tablespace Problem Hi all, Is there a way to alter a TEMPORARY table space to Logging from NoLogging. I issue the command,ALTER TABLESPACE TEMPORARY LOGGING; The same command holds good for every other tablespace except for Temporary. I need to this because I wanted to setup the Standby database and was trying to copy the datafiles from the primary site to the Standby site, Online. For that I had put every tablespace in BEGIN BACKUP mode but Temporary couldn't be taken to the Backup Mode becuase of its Nologging attribute. The work around is to create another temporary tablespace and change every users default temporary tablespace to the new one and then drop this one and create a new Temporary file withthe same name. (or shutdown the database and then copy this file tothe other system) THis I will do becuase of the entry in the control file with the name for the Temporary tablespace. But if there is a way the tablespace can be altered to logging, it will save quite some time. The tablespace is Locally Managed, and with Uniform Storage allocation. (Oracle 8.1.7 on WINNT4) RegardsHussainDBASKMCH RC
RE: Sqlloader - important
Title: RE: Sqlloader - important I think the problem lies in the fact your missing a comma and a single quote: DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID) shouldn't that be: DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID) ? Later, Ivan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Sqlloader - important Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PLsql question
Roland, You *really* need to review basic sql functions. Look at the LTRIM and RTRIM functions, and the new one (in 9i?) called TRIM. They do exactly what you are asking. Like insert into table1(col1 ,col2) select ltrim(col1,' '),ltrim(col2,' ') from table2; Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Hallo, How can I write in apl/sql code if I want to make an insert from table one into table two and in one of the fields delete the space in front of the first blank. For instance It says 1 John 2 Frederic 99 Jimmy in table one and I want the pl/sql code to delete the values in front of the names wheninserted into table two so in table two it would be: just : John Frederic Jimmy Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i install on Win2K
Hi there Jack! I think it has something to do with my P4, though I'm not entirely sure.. I'm now going to install the RedHat 7.1 so if you have a copy of the 9i for LINUX CDs spare - they would be great! Just wish I could come over and pick them up myself : The golf is coming along well now! Played to a 13 handicap on Saturday! I get lots of practice in now though :P How about you and your neck of the woods? All good as always? :) Cheers Mark -Original Message- [EMAIL PROTECTED] Sent: 13 November 2001 13:40 To: Multiple recipients of list ORACLE-L Hi Mark, Haven't followed your thread but I installed O9i on W2K with 512MB RAM and it was a breeze. I did use the preconfigured database though (could not be bothered going through the dbassistant for a play database) What is the problem, do you need a copy of the LINUX CD's? How's your golf handicap by now? take care Jack Mark Leith [EMAIL PROTECTED]@fatcity.com on 13-11-2001 11:15:20 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Oh, don't worry I know where your coming from ;) I have considered doing this - though I have RedHat 7.1. and I'm a bit dubious of putting 9i on an Unsupported platform.. The other reason is that I have the install CDs for NT/2000 and not LINUX :0( Win2K is our standard desktop, where we run our business applications, so I have use it all day really - I would prefer to have a local database to test, run through (while walking products through), and break while trying to answer question to this list : It's doesn't seem like its going to happen though :( Now - I have to ask the question - Have you *tried* to install 9i on your Win2K partition? Cheers Mark -Original Message- Gerardo Sent: 13 November 2001 01:30 To: Multiple recipients of list ORACLE-L Not trying to be funny Mark but... any reason why you don't want to set up a Suse linux partition on your 40Gb hard drive and run 9i (Linux version)? I have W2k in one partition on my P4 system and Suse 7.1 (kernel 2.4.7) running 9i in another partition. The problem is I can't run W2K and access the Oracle database at the same time. But if you don't have this requirement, then this would be a good workaround. HTH Gerardo -Original Message- Sent: Monday, November 12, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi ladies gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to install 9i on to. PC is as follows: P4 1.3 gig 256Mb RAM (Only a test box) 40 gig HD Win2K SP2 Now, I have the 9i install CDs (Thanks Joe!), but am unable to actually get the *JAVA BLOODY INSTALLER* (why don't they keep it simple eh?!?!) working! The autorun program starts, but when I try to kick it in to the Java installer (Install/Deinstall Products) I get the following error: The Java RunTime Environment was not found at C:\DOCUME~1\MARKLE~1\LOCALS~1\Temp\OraInstall\jre\binjrew.exe. Hence, the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.1.7 or higher and try again. Now, my java environment (actually JRE 1.3.1) is installed in it's normal place - C:\Program Files\Javasoft\JRE\1.3.1\.. In the Oracle Installation Guide it also says - Oracle Universal Installer automatically installs Oracle's version of the Java Runtime Environment (JRE). This version is required to run Oracle Universal Installer and several Oracle assistants. Do not modify the JRE, unless doing so with a patch provided by OracleMetaLink. Visit: It is plainly not doing this at all! Now, I remembered that I had the exact same problem when installing the 8.1.7 client on to this machine (before it had a new Hard Drive), and the solution (provided by Larry Strickland) was that they had a faulty dll (symcjit.dll) that had to be replaced in the install directories from the CD. Larry also provided me with a copy of the new dll.. I copied the entire contents of the install CDs to my HD, and searched for this particular dll, and guess what? I found it, twice, and both versions had different modification dates - and here's the best bit - and they were BOTH still older than the version supplied by Larry! (Strickland that is :)) Nothing like keeping up to date is there? :) I copied over the old versions with the new version - but have still had no joy :( I keep getting the exact same error. I've even copied the contents of Disk1\RR_MOVED\JRE\WIN32\BIN (where one of the symcjit.dll files actually was) in to the temp orainstall directory, and modified the path accordingly, I then get no error at all, but the installer just disappears, and nothing happens!! Any ideas?? Mark === Mark Leith | T: +44
Re: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Only Memorial Day? By May the heat hasn't even hit its full stride yet. You should come back down for a visit in late July or early August when it gets really hot. Of course, I am travelling right now and seeing the opposite end of the spectrum here in the North. I am in a jacket and there are still people wearing short-sleeved shirts and, in some rare cases, shorts and sandals (of course, this guy was wearing a Penn State Rugby Team T-shirt). Rachel Carmichael wrote: 'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have
RE: Sqlloader - important
Come on Roland, look at your code closely, especially in the area of the exclamation mark. This really is too easy (and I've given you a large hint !!). -Original Message- Sent: 13 November 2001 15:45 To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader - important
You are missing a comma and another single quote: orig== (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), new== (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID), Hope this helps! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader - important
Roland, You are missing a comma and a quote. It should be (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID), not (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), See the difference? Paul -Original Message- Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sqlloader - important
'98'!' contains too many quotes Just a question: Do you try a little bit to find error reasons yourself or just write an email on the spot? ;) Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Sqlloader - important om 2001.11.13 17:45 Please respond to ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Sqlloader
There is an extra quote (').
'98'!'
Why is the '!' there ??
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID),
KAMPANJTYP_NAMN)
-Original Message-
Sent: Tuesday, November 13, 2001 9:20 AM
To: Multiple recipients of list ORACLE-L
Why does this sqlloader ctl file giveme this errormessage?
the control file looks like:
load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table kampanjtyp_kopia
FIELDS TERMINATED BY ';'
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID),
KAMPANJTYP_NAMN)
SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated
Thanks in advance
Roland S
Mercadante, Thomas F [EMAIL PROTECTED]@fatcity.com den 2001-11-13
05:10 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
Hi Roland,
Try using the DECODE statement rather than TRANSLATE:
BUT_OMS DECODE(:BUT_OMS, '!','99','?','No Info',:BUT_OMS),
The above says:
Ifthe value of BUT_OMS='!', change it to '99',
elsif the value of BUT_OMS='?', change it to 'No Info',
else
insert the value provided.
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, November 13, 2001 3:00 AM
To: Multiple recipients of list ORACLE-L
Hallo all you DBA's
How do I write in sqlloader if i want to replace, translate the caracter ?
with 'No info' and the character ! with the value '99'.
I have this statement already.
BUT_OMS TRANSLATE(:BUT_OMS, '!','99'),
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: 9i install on Win2K
I have not tried to install 9i on my Win2K partition. Don't need to, right now. Happy with 9i on Suse linux so far. Gerardo -Original Message- Sent: Tuesday, November 13, 2001 2:15 AM To: Multiple recipients of list ORACLE-L Oh, don't worry I know where your coming from ;) I have considered doing this - though I have RedHat 7.1. and I'm a bit dubious of putting 9i on an Unsupported platform.. The other reason is that I have the install CDs for NT/2000 and not LINUX :0( Win2K is our standard desktop, where we run our business applications, so I have use it all day really - I would prefer to have a local database to test, run through (while walking products through), and break while trying to answer question to this list : It's doesn't seem like its going to happen though :( Now - I have to ask the question - Have you *tried* to install 9i on your Win2K partition? Cheers Mark -Original Message- Gerardo Sent: 13 November 2001 01:30 To: Multiple recipients of list ORACLE-L Not trying to be funny Mark but... any reason why you don't want to set up a Suse linux partition on your 40Gb hard drive and run 9i (Linux version)? I have W2k in one partition on my P4 system and Suse 7.1 (kernel 2.4.7) running 9i in another partition. The problem is I can't run W2K and access the Oracle database at the same time. But if you don't have this requirement, then this would be a good workaround. HTH Gerardo -Original Message- Sent: Monday, November 12, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hi ladies gents, I think I am having a blonde Monday (no I have nothing against blondes, or Mondays for the matter.. but anyway :) ). I've got essentially a new PC (new HD), that I would *like* to install 9i on to. PC is as follows: P4 1.3 gig 256Mb RAM (Only a test box) 40 gig HD Win2K SP2 Now, I have the 9i install CDs (Thanks Joe!), but am unable to actually get the *JAVA BLOODY INSTALLER* (why don't they keep it simple eh?!?!) working! The autorun program starts, but when I try to kick it in to the Java installer (Install/Deinstall Products) I get the following error: The Java RunTime Environment was not found at C:\DOCUME~1\MARKLE~1\LOCALS~1\Temp\OraInstall\jre\binjrew.exe. Hence, the Oracle Universal Installer cannot be run. Please visit http://www.javasoft.com and install JRE version 1.1.7 or higher and try again. Now, my java environment (actually JRE 1.3.1) is installed in it's normal place - C:\Program Files\Javasoft\JRE\1.3.1\.. In the Oracle Installation Guide it also says - Oracle Universal Installer automatically installs Oracle's version of the Java Runtime Environment (JRE). This version is required to run Oracle Universal Installer and several Oracle assistants. Do not modify the JRE, unless doing so with a patch provided by OracleMetaLink. Visit: It is plainly not doing this at all! Now, I remembered that I had the exact same problem when installing the 8.1.7 client on to this machine (before it had a new Hard Drive), and the solution (provided by Larry Strickland) was that they had a faulty dll (symcjit.dll) that had to be replaced in the install directories from the CD. Larry also provided me with a copy of the new dll.. I copied the entire contents of the install CDs to my HD, and searched for this particular dll, and guess what? I found it, twice, and both versions had different modification dates - and here's the best bit - and they were BOTH still older than the version supplied by Larry! (Strickland that is :)) Nothing like keeping up to date is there? :) I copied over the old versions with the new version - but have still had no joy :( I keep getting the exact same error. I've even copied the contents of Disk1\RR_MOVED\JRE\WIN32\BIN (where one of the symcjit.dll files actually was) in to the temp orainstall directory, and modified the path accordingly, I then get no error at all, but the installer just disappears, and nothing happens!! Any ideas?? Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the
Re: Inserts with different conditions in pl/sql
Use to_char, or to_number or a combination with replace, length, substr, translate, decode etc. to achieve your desired results. Do you have access to Metalink? Did you ever get a subscription to OTN? If you don't have any one of the numerous fine books (many authored by people on this list) which would really give you a much better foundation, OTN has lots of documentation on utilities, PL/SQL and database administration. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Inserts with different conditions in pl/sql om 11/13/2001 02:20 AM Please respond to ORACLE-L Hallo, How can I write in a pl/sql block if I want to do an insert from one table to another table and at the same time translate the value '?' to 98 and the value 'X' to 'Missing info' Both those values can exist in the first table. The datatyupe in table one is varchar2 and in table two it is numberdatatype. Please help me. Thanks in advance. Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PLsql question
1. create a function CREATE FUNCTION getshortstring( inputstr VARCHAR2 ) RETURN VARCHAR2 AS outstr VARCHAR2(256); -- set the length as your column indx NUMBER; BEGIN -- find the first space in string inputstr. -- If no space character is found - indx is 0 SELECT INSTR( inputstr, ' ',1,1 ) INTO indx FROM DUAL; outstr := SUBSTR( inputstr, indx+1 ); RETURN outstr; END; 2. run insert (example) INSERT INTO new_table (SELECT getshortstring(my_txt_column) FROM old_table); JP On Tue 13. November 2001 15:40, you wrote: Hallo, How can I write in apl/sql code if I want to make an insert from table one into table two and in one of the fields delete the space in front of the first blank. For instance It says 1 John 2 Frederic 99 Jimmy in table one and I want the pl/sql code to delete the values in front of the names wheninserted into table two so in table two it would be: just : John Frederic Jimmy Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do you change default oracle home?
Title: RE: How do you change default oracle home? The easiest way I know to do this is to right-click on my computer and then go to the advanced tab - click on environment variables - then make sure that your ORACLE_HOME environment variable is set to the same one you chose in the oracle home selector and also that ORACLE_SID is set to the correct sid. HTH. Later, Ivan -Original Message- From: Cale, Rick T (Richard) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 11:00 AM To: Multiple recipients of list ORACLE-L Subject: How do you change default oracle home? Hi I have Oracle, 8,8i,9i installed on Win 2k. I want to have 9i as default oracle home. Where can I do that? I have tried using Oracle Home selector which was set to 9i but still defaults to reading service name from 8.0. Oracle help says change path environment, variable to have 9i first. That does not work. I could not find anwwhere is registry to set this. My ultimate goal is to run some Pro*C programs and use Ora9i as the default home. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i certification for RH 7.1 location
nice to see they're playing nice together again. :) Jared jtesta@the-tes tas.net To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: 9i certification for RH 7.1 location om 11/13/01 07:25 AM Please respond to ORACLE-L login into metalink menu of left, product lifecycle certifications(on top) by platform intel based linux oracle server enterprise edition 9.0.1 click on submit or the tab at each of the previous screens. joe --- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) IM: JoeN8XCT or N8XCTHOME - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 13:20 Mark, RH 7.1 IS now a supported platform, i was looking on metalstink for something else yesterda and found it there, they even have a document on how to get around the install problems. let me know if you want the info, i'll email it to ya when i get to could u point to specific reference to MetaLink or TechNet that says RH is certified with 9i? The docs on TechNet still say only SuSE 7.x is supported, and searches on MetaLink returned only references to problems with RH7.1 which will only make me never mess with it thanx, Marin ...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: We need the help from Oracle DBAs.
You will need to perform a restore and point-in-time recovery from backup. The best option, if you have other changes that need to be preserved, is to do a tablespace point in time recovery (TSPITR). This requires restoring the appropriate backup files to create another database, rolling the appropriate tablespace(s) forward to just before the bad deletes, exporting the appropriate tables, truncating those tables in production, and importing the tables exported from the TSPITR. The exact mechanism best used to do the TSPITR is dependent on your version of Oracle and how you do backups (rman in 8i has innate TSPITR capability). If you have to preserver other changes in the tables affected, then there is no such simple solution - do the steps outlines above except for the export/import. Then create table(s) in the database used for TSPITR ... as select ... from ... - getting only those records needed to be restored. Then export new table, import into the production database, and insert into the real table. There are perhaps a few other options, but this is , believe it or not, the most straightforward. You DO have a DBA don't you? If not, you will need a consultant! This isn't particularly easy for the uninitiated. It will probably not be particularly fast either - depending on quite a number of factors (space, size, prior planning for this contingency, ...). -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 5:20 AM Hi, well, if the deletion was comitted, the only way to get your data back is by doing recovery from your latest backup. I just see that you're addressing the sql*plus group. Try [EMAIL PROTECTED], that's a DBA group. By the way, don't you have an on-site DBA ??? greetings, Stefan Jane Chen schrieb: Hi Folks: Sorry to write the mail to this group, because I haven't had the address from OracleDBA groups, and it is ergent. If someboday there can give us a tip or tell me the right group address, it would be grateful. We have problems with our datas which were stored in oracle8i. Some of our users have deleted some data which was stored by application (programmed by jsp) maybe carelessly or sth unintended. Now they want them back. The problem is, we can not see all the records in the server now, is there any methods to rollback or from the backup files the lost datas to recover? It is ergent, I need your helps ASAP. regards. jane _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Become an ODTUGer and be a voice to Oracle! Join now at www.odtug.com/join.htm ODTUG 2002 at Caesars Palace in Las Vegas, NV, June 17-21, 2002 -- Author: Jane Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
Re: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Doh! Sorry for the oversite - lots on my mind lately. You're definitely invited, Jeff. We'll work sumthin' out. --S Jeffery Stevenson wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to drive down just to meet the guy) in San Antonio can give us a more regional perspective. At the height of the frenzy, I know a bunch of people who left positions in SA to come to Austin. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Troiano, Paul (CAP, GEFA) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Paul.Troiano@geca cc: pital.com Subject: RE: Help!: Job Description for Data Architect Sent by: [EMAIL PROTECTED] 11/12/2001 05:40 PM Please
Re: Sqlloader - important
You have mismatched quotes. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Sqlloader - important om 11/13/2001 09:45 AM Please respond to ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sqlloader - important
Count your number of single quotes ('). It should be an even number.
Roland.Skoldb
lom To: Multiple recipients of list ORACLE-L
@ica.se [EMAIL PROTECTED]
Sent by: rootcc:
Subject: Sqlloader - important
11/13/2001
10:45 AM
Please
respond to
ORACLE-L
Hallo,
Why does this sqlloader ctl file give me this errormessage?
the control file looks like:
load data
infile 'c:\kam\kampanj.txt'
TRUNCATE
into table kampanjtyp_kopia
FIELDS TERMINATED BY ';'
(KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID),
KAMPANJTYP_NAMN)
SQL*Loader-944: error preparing insert statement for table
KAMPANJTYP_KOPIA.
ORA-01756: quoted string not properly terminated
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: RE: Sqlloader
It looks like you have a ' missing check ,'98'!', there is one too few. Cheers, Kev. -Original Message- Sent: 13 November 2001 15:20 To: Multiple recipients of list ORACLE-L Why does this sqlloader ctl file giveme this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S Mercadante, Thomas F [EMAIL PROTECTED]@fatcity.com den 2001-11-13 05:10 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Kopia: Hi Roland, Try using the DECODE statement rather than TRANSLATE: BUT_OMS DECODE(:BUT_OMS, '!','99','?','No Info',:BUT_OMS), The above says: Ifthe value of BUT_OMS='!', change it to '99', elsif the value of BUT_OMS='?', change it to 'No Info', else insert the value provided. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 3:00 AM To: Multiple recipients of list ORACLE-L Hallo all you DBA's How do I write in sqlloader if i want to replace, translate the caracter ? with 'No info' and the character ! with the value '99'. I have this statement already. BUT_OMS TRANSLATE(:BUT_OMS, '!','99'), Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader - important
:-) -Original Message- Sent: Tuesday, November 13, 2001 12:15 PM To: Multiple recipients of list ORACLE-L '98'!' contains too many quotes Just a question: Do you try a little bit to find error reasons yourself or just write an email on the spot? ;) Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Sqlloader - important om 2001.11.13 17:45 Please respond to ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
You adapt quickly. And the Gods invented air conditioning, margaritas, and habanero salsa for just such environments. --S Rachel Carmichael wrote: 'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to drive down just to meet the guy) in San Antonio can give us a more regional perspective. At the height of the frenzy, I know a bunch of people who left positions in SA
RE: create database scripts v8.0.6 8.1.7
lol .. john by no i meant no u dont need to modify db creation scripts .. my bad .. maybe i should have articulated a bit clearly .. i guess it was 2 late when i replied.. lol thx for your reply all the same. Deepak (counting .. just 3 more days for friday;) --- John Kanagaraj [EMAIL PROTECTED] wrote: Deepak/Sujatha, I see no reason why the same script should not work as long as it is limited to CREATE DATABASE/CREATE or ALTER TABLESPACE commands. (I believe that was the original question). However, dependencies such as parameters in init.ora (compatible, _system_trig_enabled, etc. come to mind) need to be compatible to the current version... Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Deepak Thapliyal [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 10:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: create database scripts v8.0.6 8.1.7 no --- Sujatha Madan [EMAIL PROTECTED] wrote: Hi, If I have a create database script which I've used with v8.0.6, would I be able to use these same scripts in v8.1.7??? ... or are there any modifications to be made. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Sqlloader - important
Because you did make an error in the decode function. Try changing DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID) to DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID) Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 11/13/2001 7:45 AM Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: create database scripts v8.0.6 8.1.7
Deepak Thapliyal wrote: lol .. john by no i meant no u dont need to modify db creation scripts .. my bad .. maybe i should have articulated a bit clearly .. i guess it was 2 late when i replied.. lol thx for your reply all the same. Deepak (counting .. just 3 more days for friday;) friday just means there's only two more day to work this week. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. In shallow waters, shrimps make fools of dragons. - Chinese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
SNIP The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies SNIP I'm incredulous. Hand Technologies failed!? Why don't they ever tell the owner these things. Note to self, schedule meeting with senior staff . . . ;) Actually, it seems Boston and vicinity are also experiencing the same major slow down. We are now under Chapter 11 reorganization. I haven't decided if this is a good or a bad thing, but at least I'm still employed, and more importantly valued. Mike Hand Polaroid Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Habanero salsa as a cure for heat Well, I suppose you're using kill or cure method down there in TX. -Original Message- Sent: Tuesday, November 13, 2001 1:25 PM To: Multiple recipients of list ORACLE-L Descrip You adapt quickly. And the Gods invented air conditioning, margaritas, and habanero salsa for just such environments. --S Rachel Carmichael wrote: 'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell PC off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of Computer Jobs to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty
Concatinate with a '''
I am trying to write dynamic sql to create some insert statements. I am
doing:
select 'insert into table (val1, val2) values (' || val1 || ',' || val2 ||
');'
from table;
The problem I am having is that one of the values is a char, and must be
enclosed in single quotes in the output. I cant do this:
select sysdate || ''' || sysdate from dual
How do I concatinate a ' with the colum values?
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: We need the help from Oracle DBAs.
hey don .. did i see a hidden plug in there are what .. just kidding.. Jane, I had posted detailed tspitr steps to this list which i tried last week .. and it is a pain in the butt to configure.. that said rman tspitr is probably the way to go as don pointed out as compared to OS tspitr which is a totally manual process so best of luck jane .. Deepak --- Don Granaman [EMAIL PROTECTED] wrote: You will need to perform a restore and point-in-time recovery from backup. The best option, if you have other changes that need to be preserved, is to do a tablespace point in time recovery (TSPITR). This requires restoring the appropriate backup files to create another database, rolling the appropriate tablespace(s) forward to just before the bad deletes, exporting the appropriate tables, truncating those tables in production, and importing the tables exported from the TSPITR. The exact mechanism best used to do the TSPITR is dependent on your version of Oracle and how you do backups (rman in 8i has innate TSPITR capability). If you have to preserver other changes in the tables affected, then there is no such simple solution - do the steps outlines above except for the export/import. Then create table(s) in the database used for TSPITR ... as select ... from ... - getting only those records needed to be restored. Then export new table, import into the production database, and insert into the real table. There are perhaps a few other options, but this is , believe it or not, the most straightforward. You DO have a DBA don't you? If not, you will need a consultant! This isn't particularly easy for the uninitiated. It will probably not be particularly fast either - depending on quite a number of factors (space, size, prior planning for this contingency, ...). -Don Granaman [OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 5:20 AM Hi, well, if the deletion was comitted, the only way to get your data back is by doing recovery from your latest backup. I just see that you're addressing the sql*plus group. Try [EMAIL PROTECTED], that's a DBA group. By the way, don't you have an on-site DBA ??? greetings, Stefan Jane Chen schrieb: Hi Folks: Sorry to write the mail to this group, because I haven't had the address from OracleDBA groups, and it is ergent. If someboday there can give us a tip or tell me the right group address, it would be grateful. We have problems with our datas which were stored in oracle8i. Some of our users have deleted some data which was stored by application (programmed by jsp) maybe carelessly or sth unintended. Now they want them back. The problem is, we can not see all the records in the server now, is there any methods to rollback or from the backup files the lost datas to recover? It is ergent, I need your helps ASAP. regards. jane _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp Become an ODTUGer and be a voice to Oracle! Join now at www.odtug.com/join.htm ODTUG 2002 at Caesars Palace in Las Vegas, NV, June 17-21, 2002 -- Author: Jane Chen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
Oracle Text (ConText/InterMedia) and realtime updates
Hey all, So, there we are, testing out InterMedia in 8i, in the hopes of using Oracle Text in 9i. Is there a way to automagically update the context index real-time? I tried a call to CTX_DDL.SYNC_INDEX in a trigger body, but of course the wrapped procedure does a COMMIT. The idea right now is to sync the index every minute via DBMS_JOB, but that just seems too hokey to me. Apparently, under ConText in Oracle7, the INT_RX procedure could be used in a trigger, but it's been desupported. (I'm guessing that locking was an issue?) Anyone have any ideas? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Hand, Michael T wrote: Actually, it seems Boston and vicinity are also experiencing the same major slow down. We are now under Chapter 11 reorganization. I haven't decided if this is a good or a bad thing, but at least I'm still employed, and more importantly valued. well, i hope yours goes better than mine.;-) i'm still employed but the valued part i have doubts on.;-) they still haven't made payroll from last friday.;-) Mike Hand Polaroid Corp. -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. In shallow waters, shrimps make fools of dragons. - Chinese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sqlloader
Hallo, I am running this sqlloader ctl-file load data infile 'C:\temp\arg\argdwfkt3.txt' TRUNCATE into table argdwfkt_kopia FIELDS TERMINATED BY ';' (BUTIKS_ID, BUT_NAMN, REGION_ID DECODE(:REGION_ID,'!','98','?','97',:REGION_ID), DISTRIKT_ID DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID), ROLL_ID, PROFIL_ID DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID), AR, KVARTAL, MANAD, VECKA, DOKUMENTTEST_ARKFORMAT DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97','99'), KAMPANJ_TYP, MX_URVAL, POSTBEFODRAN DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99'), PRINT_FORETAG_ID DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99'), STYCKKOSTNAD, FASTKOSTNAD_BREVMALL, FASTKOSTNAD_ARENDE, TOTAL_KOSTNAD, ANTAL_ÄRENDEN, ANTAL_BREVMALLAR_I_ARENDE, ANTAL_KUNDSEGMENT_I__ARENDE, ANTAL_KUNDER_I_URVAL, DATUM_HOS_KUND, AKTIVITETS_LOPNR, PRODUKTIONSENHET, AKTIVITETSDATUM, BEHANDLINGSGRP) but gets this error message, check the file:What does it mean and how should I fix this: (See attached file: arg.log) Thanks in advance Roland S =?iso-8859-1?Q?arg.log?= Description: Binary data
User disconnects (ora-0311) and tracing
Sun Solaris 2.6; Oracle 8.0.5 We've been fighting a problem for several days. It's getting worse. And it's causing MAJOR heartburn. (How bad is it? It's SO bad that the vice president has been assigned the task of following IS staff members around to see what we're doing and reporting back on our progress to the president. It's real embarrassing for him when I go to the bathroom.) Of the 70 to 80 users we have connected to Oracle, several (usually around 12 to 15) users are disconnected from the database all at once with an end of file on communication channel. Other users remain on. Not always the same users disconnected. No commonality that we can find. There's nothing in the alert log, and there are no trace files created. Oracle knows nothing about the disconnected users -- they remain connected to the database from the server side 'till pmon comes along to clean them up. FINALLY, my question. Oracle has suggested that we turn on trace event 10046. I confess I've never done this before. In svrmgrl, I issue the command oradebug setorapid n, then oradebug event 10046 trace name context forever, level 12. This worked 1 time for 1 user. It created a trace file in the udump directory. However, I'd like to set this event on for several users. The command executes without error, but no add'l trace files are created. What am I missing? Can I only do this for 1 user? Does it have something to do with running MTS? I tried using the setorapid (pid) instead of the setospid (spid), but it made no difference. Any ideas? Thanks for any help. Barb The chipmunk dba P.S. Yes, we do have both our SA's and network folks looking at the problem, as well as several consultants. Everyone is clueless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Concatinate with a '''
Single quote is chr(39). Chr(10) is linefeed and chr(13) is carriage return,
which are used very often
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 13, 2001 1:35 PM
To: Multiple recipients of list ORACLE-L
chr(13) or is it chr(10) (or some other ascii value) but instead of dealing
with
with multiple quotes is much easier to just concatenate on the ASCII value
of it.
-Original Message-
Sent: Tuesday, November 13, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
I am trying to write dynamic sql to create some insert statements. I am
doing:
select 'insert into table (val1, val2) values (' || val1 || ',' || val2 ||
');'
from table;
The problem I am having is that one of the values is a char, and must be
enclosed in single quotes in the output. I cant do this:
select sysdate || ''' || sysdate from dual
How do I concatinate a ' with the colum values?
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Concatinate with a '''
CHR(39) is single quote.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 13, 2001 2:35 PM
chr(13) or is it chr(10) (or some other ascii value) but instead of
dealing
with
with multiple quotes is much easier to just concatenate on the ASCII value
of it.
-Original Message-
Sent: Tuesday, November 13, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
I am trying to write dynamic sql to create some insert statements. I am
doing:
select 'insert into table (val1, val2) values (' || val1 || ',' || val2 ||
');'
from table;
The problem I am having is that one of the values is a char, and must be
enclosed in single quotes in the output. I cant do this:
select sysdate || ''' || sysdate from dual
How do I concatinate a ' with the colum values?
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Igor Neyman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Sqlloader
Roland, Your log file tells you exactly, what to do: use 'TRAILING NULLCOLS' in your ctl-file (when the last column value is NULL). BTW, why don't you ever RTFM??? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 2:17 PM Hallo, I am running this sqlloader ctl-file load data infile 'C:\temp\arg\argdwfkt3.txt' TRUNCATE into table argdwfkt_kopia FIELDS TERMINATED BY ';' (BUTIKS_ID, BUT_NAMN, REGION_ID DECODE(:REGION_ID,'!','98','?','97',:REGION_ID), DISTRIKT_ID DECODE(:DISTRIKT_ID,'!','98','?','97',:DISTRICT_ID), ROLL_ID, PROFIL_ID DECODE(:PROFIL_ID,'!','98','?','97',:PROFIL_ID), AR, KVARTAL, MANAD, VECKA, DOKUMENTTEST_ARKFORMAT DECODE(:DOKUMENTTEST_ARKFORMAT,'A4','1','A3','2','E1','3','!','98','?','97' ,'99'), KAMPANJ_TYP, MX_URVAL, POSTBEFODRAN DECODE(:POSTBEFODRAN,'A','1','B','2','!','98','?','97','99'), PRINT_FORETAG_ID DECODE(:PRINT_FORETAG_ID,'1','1','2','2','!','98','?','97','99'), STYCKKOSTNAD, FASTKOSTNAD_BREVMALL, FASTKOSTNAD_ARENDE, TOTAL_KOSTNAD, ANTAL_ÄRENDEN, ANTAL_BREVMALLAR_I_ARENDE, ANTAL_KUNDSEGMENT_I__ARENDE, ANTAL_KUNDER_I_URVAL, DATUM_HOS_KUND, AKTIVITETS_LOPNR, PRODUKTIONSENHET, AKTIVITETSDATUM, BEHANDLINGSGRP) but gets this error message, check the file:What does it mean and how should I fix this: (See attached file: arg.log) Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: User disconnects (ora-0311) and tracing
To set 10046 for all sessions, you specify the event clause (from below) in your init.ora. This brings it into effect for all connections. Note this will have a significant impact on performance - and you'll need plenty of space in your trace file directory. I know in this situation its hard to change things, but have you applied all the relevant patches to both OS and Oracle software? Generally random drop-outs of connections are typically more prevalent in earlier versions of each release. One radical thing you could try is that in my experience, most disconnect errors occur with the cost optimizer - you could try using rule (but this is obviously not without considerable risk) hth connor --- Baker, Barbara [EMAIL PROTECTED] wrote: Sun Solaris 2.6; Oracle 8.0.5 We've been fighting a problem for several days. It's getting worse. And it's causing MAJOR heartburn. (How bad is it? It's SO bad that the vice president has been assigned the task of following IS staff members around to see what we're doing and reporting back on our progress to the president. It's real embarrassing for him when I go to the bathroom.) Of the 70 to 80 users we have connected to Oracle, several (usually around 12 to 15) users are disconnected from the database all at once with an end of file on communication channel. Other users remain on. Not always the same users disconnected. No commonality that we can find. There's nothing in the alert log, and there are no trace files created. Oracle knows nothing about the disconnected users -- they remain connected to the database from the server side 'till pmon comes along to clean them up. FINALLY, my question. Oracle has suggested that we turn on trace event 10046. I confess I've never done this before. In svrmgrl, I issue the command oradebug setorapid n, then oradebug event 10046 trace name context forever, level 12. This worked 1 time for 1 user. It created a trace file in the udump directory. However, I'd like to set this event on for several users. The command executes without error, but no add'l trace files are created. What am I missing? Can I only do this for 1 user? Does it have something to do with running MTS? I tried using the setorapid (pid) instead of the setospid (spid), but it made no difference. Any ideas? Thanks for any help. Barb The chipmunk dba P.S. Yes, we do have both our SA's and network folks looking at the problem, as well as several consultants. Everyone is clueless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
OK- Tekllme is okay then... Just the habaneros is a bad thing, huh? greg -Original Message- Sent: Tuesday, November 13, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Descrip That's why if you ever see a sick Texan - he/she/it is on its deathbed. Tequila + habaneros = health. --S Gogala, Mladen wrote: Habanero salsa as a cure for heat Well, I suppose you're using kill or cure method down there in TX. -Original Message- Sent: Tuesday, November 13, 2001 1:25 PM To: Multiple recipients of list ORACLE-L Descrip You adapt quickly. And the Gods invented air conditioning, margaritas, and habanero salsa for just such environments. --S Rachel Carmichael wrote: 'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a brain-drain as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and
Re: Oracle Text (ConText/InterMedia) and realtime updates
There is a server process that can run in the background to do this. Check out ctxsrv hth connor --- Jesse, Rich [EMAIL PROTECTED] wrote: Hey all, So, there we are, testing out InterMedia in 8i, in the hopes of using Oracle Text in 9i. Is there a way to automagically update the context index real-time? I tried a call to CTX_DDL.SYNC_INDEX in a trigger body, but of course the wrapped procedure does a COMMIT. The idea right now is to sync the index every minute via DBMS_JOB, but that just seems too hokey to me. Apparently, under ConText in Oracle7, the INT_RX procedure could be used in a trigger, but it's been desupported. (I'm guessing that locking was an issue?) Anyone have any ideas? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
It is the synergistic colonization of your inner lifeworld provided by the combination of the two primary forces, i.e., tequila and habaneros, which results in a glorious, uber health, state of enlightenment... --S Loughmiller, Greg wrote: OK- Tekllme is okay then... Just the habaneros is a bad thing, huh? greg -Original Message- Sent: Tuesday, November 13, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Descrip That's why if you ever see a sick Texan - he/she/it is on its deathbed. Tequila + habaneros = health. --S Gogala, Mladen wrote: Habanero salsa as a cure for heat Well, I suppose you're using kill or cure method down there in TX. -Original Message- Sent: Tuesday, November 13, 2001 1:25 PM To: Multiple recipients of list ORACLE-L Descrip You adapt quickly. And the Gods invented air conditioning, margaritas, and habanero salsa for just such environments. --S Rachel Carmichael wrote: 'cause there ain't enough money in the world to bail you out? The only problem I have with Texas is the heat. I have good friends down there (you guys all know who you are and if you don't, WAKE UP)... but I went down over Memorial Day weekend to SA and nearly melted from the humidity. This does nothing to induce me to move South. --- Jeffery Stevenson [EMAIL PROTECTED] wrote: Bail money??? Why wasn't I invited? :) Yeah, like was mentioned, there's some positions available in Austin, but not as prevalent as it used to be. VC money has been tightened up so a lot of these companies looking to grow have been hit hard (and the bigger companies are just cutting back to save money). The problem I see though is that companies seem to be trimming back too much. I'm starting to hear little rumours here and there of companies going, Maybe we shouldn't have gotten rid of most of our support/operations people? It's not bad here though...it'll pick back up again...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Monday, November 12, 2001 9:30 PM To: Multiple recipients of list ORACLE-L Description for David, Yes you should drive down/me drive up to meet. Just let me get past some current difficulties. We could leave bail money with the wives! Hehehe... San Antonio (SA) has been hit, but definitely not as hard as Austin/Dallas/Houston. I'll probably regret this (if I end up competing for a job), but anyone looking for a job could do a lot worse than looking in SA. Most of the tech jobs here are government, gov/private consulting, or big company IT (USAA, MCI, SBC, etc). The largest industry however is tourism, which has been hammered. This doesn't affect techies much though. If one has no qualms about managing databases of bigger and better ways to break things and kill people, then DOD contracting is the way to go in Central Texas. Cost of living is very low, and SA is the 8th largest city in the US. Upsides: steady work, excellent food, mild winters, lots of recreational activities. Downsides: Inept city government, yearly drought, HOT for 9 months of the year. --Scott Shafer San Antonio, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 12, 2001 7:05 PM Description for Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us high-tech types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to
RE: Concatinate with a '''
Hum, they are the two I used the most. Guess that's why they stuck in my
mind.
-Original Message-
Sent: Tuesday, November 13, 2001 11:59 AM
To: Multiple recipients of list ORACLE-L
Single quote is chr(39). Chr(10) is linefeed and chr(13) is carriage return,
which are used very often
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 13, 2001 1:35 PM
To: Multiple recipients of list ORACLE-L
chr(13) or is it chr(10) (or some other ascii value) but instead of dealing
with
with multiple quotes is much easier to just concatenate on the ASCII value
of it.
-Original Message-
Sent: Tuesday, November 13, 2001 11:17 AM
To: Multiple recipients of list ORACLE-L
I am trying to write dynamic sql to create some insert statements. I am
doing:
select 'insert into table (val1, val2) values (' || val1 || ',' || val2 ||
');'
from table;
The problem I am having is that one of the values is a char, and must be
enclosed in single quotes in the output. I cant do this:
select sysdate || ''' || sysdate from dual
How do I concatinate a ' with the colum values?
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kimberly Smith
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Concatinate with a '''
This works:
SQLselect ||sysdate|| quote_me from dual;
quote_me
--
'11/13/01'
Steve Orr
-Original Message-
Sent: Tuesday, November 13, 2001 12:17 PM
To: Multiple recipients of list ORACLE-L
I am trying to write dynamic sql to create some insert statements. I am
doing:
select 'insert into table (val1, val2) values (' || val1 || ',' || val2 ||
');'
from table;
The problem I am having is that one of the values is a char, and must be
enclosed in single quotes in the output. I cant do this:
select sysdate || ''' || sysdate from dual
How do I concatinate a ' with the colum values?
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Oracle Text (ConText/InterMedia) and realtime updates
Yeah, I thought about that, but according to Oracle, ctxsrv is desupported and will be removed in a future version. I guess I'm hoping for something in the DB, too, instead of relying on an external program that needs the CTXSYS password hardcoded. Thx! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Original Message- Sent: Tuesday, November 13, 2001 14:23 To: Multiple recipients of list ORACLE-L There is a server process that can run in the background to do this. Check out ctxsrv hth connor --- Jesse, Rich [EMAIL PROTECTED] wrote: Hey all, So, there we are, testing out InterMedia in 8i, in the hopes of using Oracle Text in 9i. Is there a way to automagically update the context index real-time? I tried a call to CTX_DDL.SYNC_INDEX in a trigger body, but of course the wrapped procedure does a COMMIT. The idea right now is to sync the index every minute via DBMS_JOB, but that just seems too hokey to me. Apparently, under ConText in Oracle7, the INT_RX procedure could be used in a trigger, but it's been desupported. (I'm guessing that locking was an issue?) Anyone have any ideas? TIA! Rich Jesse System/Database -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Power outage
We had a power outage and the network admins found out that the UPS sucks. I have an Oracle 8.0.5 on NT 4.0 that got rudely bounced a couple of times due to loss of power. Now I have a problem in bringing it back up. Here is what I get in my SIDLGWR file. *** SESSION ID:(3.1) 2001.01.05.21.32.37.250 ORA-01110: data file 12: 'L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF' ORA-01114: IO error writing block to file 12 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. error 1242 detected in background process Dump file J:\ORA805\ADMIN\LV54\BDUMP\lv54LGWR.TRC Tue Nov 13 13:55:57 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: lv54 Redo thread mounted by this instance: 0 none Oracle process number: 4 pid: db I cannot get the database to mount. Any ideas!! Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle related docs/OCP materials
Yes, it is a big part of why I was able to pass my Performance Tuning OCP test. Stephen [EMAIL PROTECTED] 11/13/01 09:55AM Have you guys checkout out www.freeocp.com created by one of our own list members Mr. Ethan Post? -Original Message-From: Arslan Bahar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 13, 2001 10:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle related docs/OCP materials these sites contain some resources www.oraclenotes.com http://certcities.com/ http://www.oraclepower.com/ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Santosh VarmaSent: Tuesday, November 13, 2001 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle related docs/OCP materials I also found the site not useful. it did not have any documentation/tutorials at all. regards,Santosh Varma
STATSPACK Info
Hope the list is up ... this message just returned to me about half hour ago ... Are there any docs available on interpreting statspack output other than the report itself? I checked Metalink but couldn't find much. Thanks in advance Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1
RE: User disconnects (ora-0311) and tracing
Barb, Some things to check: (a) Swap area becoming full - if this is pointing to /tmp, this could result in erratic problems. (b) What does 'vmstat' state in terms of memory usage/mem free/swap IO? (c) File table/process table overflows - this is usually seen in retrospect from 'sar' output Strange things have been known to happen - typically resulting in ORA-0311 - when some OS limit is reached. I would look at the OS and network rather than at Oracle at this point of time. You should then search Metalink for a combination of 8.0.5 and ORA-0311. 10046 is nothing but SQL_TRACE - level 12 will really eat up 'udump' space. You will need to set this in the init.ora and bounce the db. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Baker, Barbara [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: User disconnects (ora-0311) and tracing Sun Solaris 2.6; Oracle 8.0.5 We've been fighting a problem for several days. It's getting worse. And it's causing MAJOR heartburn. (How bad is it? It's SO bad that the vice president has been assigned the task of following IS staff members around to see what we're doing and reporting back on our progress to the president. It's real embarrassing for him when I go to the bathroom.) Of the 70 to 80 users we have connected to Oracle, several (usually around 12 to 15) users are disconnected from the database all at once with an end of file on communication channel. Other users remain on. Not always the same users disconnected. No commonality that we can find. There's nothing in the alert log, and there are no trace files created. Oracle knows nothing about the disconnected users -- they remain connected to the database from the server side 'till pmon comes along to clean them up. FINALLY, my question. Oracle has suggested that we turn on trace event 10046. I confess I've never done this before. In svrmgrl, I issue the command oradebug setorapid n, then oradebug event 10046 trace name context forever, level 12. This worked 1 time for 1 user. It created a trace file in the udump directory. However, I'd like to set this event on for several users. The command executes without error, but no add'l trace files are created. What am I missing? Can I only do this for 1 user? Does it have something to do with running MTS? I tried using the setorapid (pid) instead of the setospid (spid), but it made no difference. Any ideas? Thanks for any help. Barb The chipmunk dba P.S. Yes, we do have both our SA's and network folks looking at the problem, as well as several consultants. Everyone is clueless. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Correction : EMC symetrix - 1M stripe width - Raid 0+1 - Performa
Hi, We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
lack of memory
Hi List, We use a server with 4Gb memory on Linux kernel 2.2.19, Oracle 8.1.7.0 dedicated mode. It's an OLTP system with about 450 users. About 2 months ago I initiated gradual migration of our sql code to use bind variables instead of literals because we had problems with shared pool's fragmentation and strong contention on shared pool and library cache latches. The 90% of sql is accumulated on the client side (BDE+Delphi). I cut 150M from shared pool and planned cut it down further as we get results from the migration. Despite that now we have lack of memory. It seems now user processes consume more memory. We can't increase memory because of limitations on kernel 2.2. In general Is there any significant difference in terms of memory consumtion between a user process that uses bind variables and another one that uses literals? Does anyone use 8.1.7, MTS mode on Linux for a system with similar loading (400-500 users). Is that stable enough?. I have doubts. Please help. Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Correction : EMC symetrix - 1M stripe width - Raid 0+1 - Perform
Hi, Application : OLTP Environment : Solaris 2.6 on a E10K Database: 8.0.5.2.1 We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sqlloader - important
I think it's really amazing how many people spotted the error. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: Sqlloader - important Sent by: [EMAIL PROTECTED] 11/13/2001 10:40 AM Please respond to ORACLE-L You are missing a comma and another single quote: orig== (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), new== (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID), Hope this helps! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID), KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Power outage
I think you are in NOARCHIVELOG mode? Can you *see* L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF in Explorer? -Original Message- Sent: Tuesday, November 13, 2001 4:45 PM To: Multiple recipients of list ORACLE-L We had a power outage and the network admins found out that the UPS sucks. I have an Oracle 8.0.5 on NT 4.0 that got rudely bounced a couple of times due to loss of power. Now I have a problem in bringing it back up. Here is what I get in my SIDLGWR file. *** SESSION ID:(3.1) 2001.01.05.21.32.37.250 ORA-01110: data file 12: 'L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF' ORA-01114: IO error writing block to file 12 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. error 1242 detected in background process Dump file J:\ORA805\ADMIN\LV54\BDUMP\lv54LGWR.TRC Tue Nov 13 13:55:57 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: lv54 Redo thread mounted by this instance: 0 none Oracle process number: 4 pid: db I cannot get the database to mount. Any ideas!! Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Text (ConText/InterMedia) and realtime updates
Title: RE: Oracle Text (ConText/InterMedia) and realtime updates I would suggest researching an Autonomous Transaction fired from the trigger to get around the commit executed by CTX_DDL.SYNC_INDEX. Another approach I would pursue is to evaluate the use of Catalog Indexes (8.1.7). If your requirements fit within the catalog index limitations (more like an Intermedia Text-lite) then you are in luck since they are transactional, hence no need for periodic synchronization. HTH Tony Aponte -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 2:30 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Text (ConText/InterMedia) and realtime updates Hey all, So, there we are, testing out InterMedia in 8i, in the hopes of using Oracle Text in 9i. Is there a way to automagically update the context index real-time? I tried a call to CTX_DDL.SYNC_INDEX in a trigger body, but of course the wrapped procedure does a COMMIT. The idea right now is to sync the index every minute via DBMS_JOB, but that just seems too hokey to me. Apparently, under ConText in Oracle7, the INT_RX procedure could be used in a trigger, but it's been desupported. (I'm guessing that locking was an issue?) Anyone have any ideas? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip
Thanks John! thought every body missed it...:( ( Talk about shameless self plug..;) ) Cheers, RS --- John Kanagaraj [EMAIL PROTECTED] wrote: Hi Raj, I hear that too and feel it in the BayArea. However, we did have our 20% share of 'cuts' in the DBA team - 1 out of 5 went in the last round... Btw, Nice seeing you/reading about you on the Peer-to-Peer column in OraMag! John Kanagaraj __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: who execute scripts in Win NT like Unix!!
Alex, Create a sql script with your query ( eg. sql_script.sql) Then create a batch script like the one below (script.bat) sqlplus -s user/password @sql_script.sql logfile You will need to run the script.bat which will login and execute your Oracle Script and log results to a logfile. Regards Suhen Hi gurus!!! I need execute any scripts in win nt like oracle in unix!!! example: sqlplus user/password fin SELECT s.sid, s.serial#, p.pid, p.spid, s.osuser, s.machine, s.program FROM v\$session s, v\$process p WHERE p.addr = s.paddr AND s.schemaname 'SYS' ORDER BY p.spid,s.sid, p.pid, p.spid; fin @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: who execute scripts in Win NT like Unix!!
Title: RE: who execute scripts in Win NT like Unix!! -Original Message- From: Alexander Ordonez [mailto:[EMAIL PROTECTED]] I need execute any scripts in win nt like oracle in unix!!! example: sqlplus user/password fin SELECT s.sid, s.serial#, p.pid, p.spid, s.osuser, s.machine, s.program FROM v\$session s, v\$process p WHERE p.addr = s.paddr AND s.schemaname 'SYS' ORDER BY p.spid,s.sid, p.pid, p.spid; fin a) Download cygwin to enable you to enter UNIX shell commands on a machine running MS Windows. http://sources.redhat.com/cygwin/ OR b)Enter the following at the DOS prompt: REM running batch script echo connect user/password tmp.sql echo SELECT s.sid, tmp.sql echo s.serial#, tmp.sql echo p.pid, tmp.sql echo p.spid, tmp.sql echo s.osuser, tmp.sql echo s.machine, tmp.sql echo s.program tmp.sql echo FROM v$session s, v$process p tmp.sql echo WHERE p.addr = s.paddr tmp.sql echo AND s.schemaname 'SYS' tmp.sql echo ORDER BY p.spid,s.sid, p.pid, p.spid ; tmp.sql echo exit tmp.sql sqlplus /nolog tmp.sql del tmp.sql
FW: utl_file example
Thanks Gints,
this was the problem!
Tamas
Just in case
Do You have added correctly entries in utl_file_dir?
If I remeber correctly there was a difference between Unix and NT. On one
You need to put slash on the end, on another not.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Szecsy Tamas
tszecsy@GEOME To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
TRIA.hu cc:
Sent by: Subject: RE: utl_file example
[EMAIL PROTECTED]
om
2001.11.12
16:15
Please respond
to ORACLE-L
Nirmal,
do I have to set some OS acces rights? I get the following exception:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at SYS.UTL_FILE, line 98
ORA-06512: at SYS.UTL_FILE, line 157
ORA-06512: at line 4
If I handle the exception it turns out that it is invalide path. The only
thing I can think about is, that the sys user does not have access right to
the c:\ drive. Do you know, under what account is the utl_file accessing
the OS filesystem?
Tamas
-Original Message-
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: utl_file example
Hi,
Verify UTL_FILE_DIR init.ora parameter is defined properly.
In FOPEN function specify, filepath and filename as separate.
[EMAIL PROTECTED] ;
1 DECLARE
2 fid UTL_FILE.FILE_TYPE;
3 BEGIN
4 fid := UTL_FILE.FOPEN('c:\','test.log','w');
5 UTL_FILE.PUT_LINE(fid, 'Test file for usage of UTL_FILE
package');
6 UTL_FILE.FCLOSE(fid);
7* END;
[EMAIL PROTECTED] /
PL/SQL procedure successfully completed.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
HTH.
Rgds,
Nirmal,
-Original Message-
From: Szecsy Tamas [SMTP:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject:utl_file example
Hi,
Sorry for the previous post with a wrong subject in it.
Could somebody help me out with a very short utl_file example for
Windows
NT? I would like write error data into a simple text file, but I
get
exceptions.
TIA,
Tamas Szecsy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858)
538-5051
San Diego, California-- Public Internet access / Mailing
Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You
may
also send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Correction : EMC symetrix - 1M stripe width - Raid 0+1 - Performa
Hi Mohammed, Look at Gaja's article about RAIDOracle. It's one of the best articles I've ever seen.. You can find it at www.quest.com Regards, Ed Hi, We recently migrated from sun a5200 storage to EMC symetrix, and we have been seeing occasional performance problems. When contacted, Oracle support among other things pointed out the stripe width we have used 1M, is very large and also said users will not see an advantage above 64K. When we had Sun storage before we had 64K as the stripe width. Has anyone faced this kind of issue or has any comments..or can someone explain the low level impact of the stripe width on the ORACLE I/O operations? Much appreciated.. Regards Mohammed Ahsanuddin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Power outage
That is correct -Original Message- Sent: Tuesday, November 13, 2001 5:20 PM To: Multiple recipients of list ORACLE-L I think you are in NOARCHIVELOG mode? Can you *see* L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF in Explorer? -Original Message- Sent: Tuesday, November 13, 2001 4:45 PM To: Multiple recipients of list ORACLE-L We had a power outage and the network admins found out that the UPS sucks. I have an Oracle 8.0.5 on NT 4.0 that got rudely bounced a couple of times due to loss of power. Now I have a problem in bringing it back up. Here is what I get in my SIDLGWR file. *** SESSION ID:(3.1) 2001.01.05.21.32.37.250 ORA-01110: data file 12: 'L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF' ORA-01114: IO error writing block to file 12 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. error 1242 detected in background process Dump file J:\ORA805\ADMIN\LV54\BDUMP\lv54LGWR.TRC Tue Nov 13 13:55:57 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: lv54 Redo thread mounted by this instance: 0 none Oracle process number: 4 pid: db I cannot get the database to mount. Any ideas!! Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Power outage
Hmm...well...yikesif you can place that file back, you might have a chance if what you need is in the online redo.. if you can't, and you need to go to a backup...it'll be a cold one scratching head -Original Message- Sent: Tuesday, November 13, 2001 6:55 PM To: Multiple recipients of list ORACLE-L That is correct -Original Message- Sent: Tuesday, November 13, 2001 5:20 PM To: Multiple recipients of list ORACLE-L I think you are in NOARCHIVELOG mode? Can you *see* L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF in Explorer? -Original Message- Sent: Tuesday, November 13, 2001 4:45 PM To: Multiple recipients of list ORACLE-L We had a power outage and the network admins found out that the UPS sucks. I have an Oracle 8.0.5 on NT 4.0 that got rudely bounced a couple of times due to loss of power. Now I have a problem in bringing it back up. Here is what I get in my SIDLGWR file. *** SESSION ID:(3.1) 2001.01.05.21.32.37.250 ORA-01110: data file 12: 'L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF' ORA-01114: IO error writing block to file 12 (block # 1) ORA-27072: skgfdisp: I/O error OSD-04008: WriteFile() failure, unable to write to file O/S-Error: (OS 5) Access is denied. error 1242 detected in background process Dump file J:\ORA805\ADMIN\LV54\BDUMP\lv54LGWR.TRC Tue Nov 13 13:55:57 2001 ORACLE V8.0.5.0.0 - Production vsnsta=0 vsnsql=c vsnxtr=3 Windows NT V4.0, OS V5.101, CPU type 586 Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production PL/SQL Release 8.0.5.0.0 - Production Windows NT V4.0, OS V5.101, CPU type 586 Instance name: lv54 Redo thread mounted by this instance: 0 none Oracle process number: 4 pid: db I cannot get the database to mount. Any ideas!! Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
