SQLLoader
Hi, I have to load an ASCII dump into Oracle with loader that contains date information in a different national character set than my databse. Can I specify a different nls_lang ( Do an alter session set = nls_lang...) before the load? If so, can you please give me the syntax? Regards, Antje Sackwitz -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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).
Backup recovery tools for 7.3.4 from 9i
Hello, we have an application running the Oracle 7.3.4 version. We have recently bought the 9i 9.0.1 version. Is it possible to use the 9i backup and recovery tools to backup the 7.3.4. database? If the answer is no, between which database versions, for example from 9i to 8i? 9i to 8? Thanks a lot -- Beatriz Martínez Jiménez Ingeniera Informática Tfno: 983 546646 [EMAIL PROTECTED] Fundación CIDAUT Centro de Investigación y desarrollo en Automoción Parque Tecnológico de Boecillo, p.209. 47151 Boecillo, Valladolid. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= 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).
deploying forms reports on web problem
Dear All, i want to deploy my application (forms reports) on web, for this i have instlled forms and reporst server 6.0. i can see the forms in browser but its window size is not appearing proper and the icons also not appearing .what could be the problem. Thanks in advance Regards Arvind Kumar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar 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
BDY.RTF Description: RTF file
resizing/moving datafiles for performance ??
Guys, the DB is on 8.1.6 / Win2K. there entire DB ( 33 tables and 110 indexes) is in USERS tablespace. the USERS tablespace has only one datafile USERS.DAT of size 12GB. it's on 8 * 10 GB HDD with RAID 5. we are facing performance bottleneck now. V$SESSION_WAIT shows many rows for DB FILE SCATTERED READ and DB FILE SEQUENTIAL READ. all these events wait for USERS.DAT to be read. it's a highly read OLTP site. So,will moving the table and index data to different tablespaces with relatively smaller datafiles ( say 1 GB ) improve performance ? OR since it is on RAID5 , will moving make any difference ? 10-20 MB of data gets added to the DB daily. if resizing/moving improves performance,what should be the size of my datafile ? kindly give me a solution guys. TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora 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 + nls_date_language
Hi, I want to precice my question on SQLLoader and date format: I want to give my date field a special nls_date_language. Can Anyone help with the syntax? Regards, Antje Sackwitz Antje Sackwitz ppi Media GmbH Deliusstraße 10 D-24114 Kiel phone +49 (0) 43 1-53 53-2 16 fax +49 (0) 43 1-53 53-2 22 email mailto:[EMAIL PROTECTED] web www.ppi.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sackwitz, Antje 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: DB copying : Attack of the Clones!
Hi Kirti Do you absolutely need full size copies? If small referentially correct subsets were suitable you could use our DataBee software to re-create and re-load the test databases as necessary. In other words, you would not need to back up and restore full size databases. You simply press the button and regenerate the subsets when required. Depending on the size of the subset, the refresh would not take more than an hour or two. The load process is quite straight forward - many of our customers just create the initial subset databases and then off load the truncate and reload work to the developers and testers themselves. The DBA's are removed from the loop and because the databases are small the create process is very quick - the developers and testers can refresh their databases whenever they want. Actually, DataBee would clone the full size databases just fine - its just not really designed for that purpose in mind. DataBee: http://www.DataBee.com In any event, you should have a look at our freeware DBATool. It contains (among other things) a rule based schema adjuster that should take care of your requirements to modify the DDL in the test schemas http://www.DataBee.com Thanks Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] I was 'volunteered' to participate in a task force charged with finding quick solutions (in less than 2 weeks) to support following Dgmt decision: Clone 14 production databases in their entirety for ongoing code testing, recreating production problems etc. BTW, if we decided on any 3rd party tools, then Dgmt wants it installed within the next 4-5 weeks. Any Vendor types lurking on the list? This is your chance :) -- 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 + nls_date_language
BDY.RTF Description: RTF file
fyi: oracle tech support link to free .zip utility
follow up to the zip thread: http://ap103aru.oracle.com/unzips/unzips.html http://metalink.oracle.com/metalink/plsql/showDoc?db=NOTid=202255.1 ... Unzipping the Release 11.5.7 Maintenance Pack requires an unzip utility capable of handling a zip archive with more than 65,536 files. For example, Info-ZIP's UnZip (http://www.info-zip.org/pub/infozip/UnZip.html) version 5.41 or higher is capable of handling large zip archives. The UnZip source code is available for free, along with compiled executables of version 5.41 or higher for every Oracle Applications-certified operating system except IBM RS6000 AIX (please see below for alternatives). http://www.info-zip.org/pub/infozip/UnZip.html excerpt: | UnZip 5.50 | | The Third Most Portable Program in the World! * | | UnZip is an extraction utility for archives compressed in .zip format | (also called zipfiles). Although highly compatible both with | PKWARE's PKZIP and PKUNZIP utilities for MS-DOS and with Info-ZIP's | own Zip program, our primary objectives have been portability and | non-MSDOS functionality. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
AW: SQLLOader + nls_date_language
Yes I know.
But how is the syntax with loader?
Can I provide the information in the controlfile?
i found a possibility to set NLS_DATE_LANGUAGE BEFORE calling the
sqlloader, but how is the syntax in the
controlfile in following line
Date_field date 'Mon dd hh:mi:ss' RTRIM(:Date_date,':000AM'),
...
?
Or is setting the environment only way to solve this?
Regards,
Antje
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Gesendet am: Freitag, 19. Juli 2002 11:36
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Betreff: RE: SQLLOader + nls_date_language
e.g
SELECT TO_DATE('January 15, 1989, 11:00 A.M.',
'Month dd, , HH:MI A.M.','NLS_DATE_LANGUAGE = American')
FROM DUAL;
-Original Message-
From: Antje.Sackwitz [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 19, 2002 2:53 PM
To: ORACLE-L
Cc: Antje.Sackwitz
Subject: SQLLOader + nls_date_language
Hi,
I want to precice my question on SQLLoader and date format:
I want to give my date field a special nls_date_language.
Can Anyone help with the syntax?
Regards,
Antje Sackwitz
Antje Sackwitz
ppi Media GmbH
Deliusstraße 10
D-24114 Kiel
phone +49 (0) 43 1-53 53-2 16
fax +49 (0) 43 1-53 53-2 22
email mailto:[EMAIL PROTECTED]
web www.ppi.de
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sackwitz, Antje
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).
Datei: BDY.RTF
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sackwitz, Antje
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: A DBA looks at OAS | IAS vs. Locally-built Apache
Here they are touting the benefits of Windows2000 Terminal Server... I discovered that any script / reference to SQL Net causes a TCP protocol error, and you can't copy / paste from a local file to one in the terminal server window. So, we still need a display for every windows2000 server. I don't know if some of the problems have to do with Java via terminal server. I hear Microsoft pulled its Java download page for XP already. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 5:35 PM To: Multiple recipients of list ORACLE-L Subject:RE: A DBA looks at OAS | IAS vs. Locally-built Apache Good luck. The smooth install is at a grinding halt at the moment, with half the components throwing java exceptions all over the place. Did I mention java sucks? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: A DBA looks at OAS | IAS vs. Locally-built Apache I will see what I can do. Thanks Scott! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Robert, After having just fought a battle with iAS 1.0.2.2 do yourself a favor and get hold of iAS 9.0.2 (latest release). I'm installing 9.0.2 as I type, and it seems to be a lot smoother, albeit more bloated and slower - at least the install portion. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 4:09 PM To: Multiple recipients of list ORACLE-L Subject:RE: A DBA looks at OAS | IAS vs. Locally-built Apache This is Oracle9i Application Server Version 1.0.2.2.3a for NT. So, I'm guessing this is iAS. I have a hard enough time keeping up with Oracle marketing's changing the names/version of Oracle Net, parallel server, and MTS every opportunity they get!! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Wednesday, July 17, 2002 1:24 PM To: Multiple recipients of list ORACLE-L It really OAS and not iAS? If it is, you need to upgrade your software. There is a published exploit against the version of Apache used by Oracle's latest iAS release. Oracle has released a patch which stops the exploit I have built Oracle web servers for years, but I am now of the mind that these things should not be built by DBA's but by webmasters. I am undecided whether to one should go with iAS or construct your own with Apache. The mod_plsql module for instance was not created by Oracle. It and things such as forms server and reports server will run against such a construction. However, we were advised last week that the Windows NT machines will be converted to XP this year. As a result, I started to look at the 9i Internet Developer Suite. About every third line is a statement to the effect that the 9i database, 9 iAS, and 9 iDS are made to work together. I haven't figured out what one is giving up if one builds their own web server and also installs components for the 9 iAS distribution. Is it just convenience? One reason for giving up the convenience is security. An exploit is discovered and possibly published. Apache fixes the problem. If I have built my own I can get the patch from Apache and rebuild the web server. If I'm wedded to iAS I need to wait for Oracle to incorporate the patch into its offering. This could be a matter days to over a week. However weighing-in on the 9 iAS side is the ease of installing a fix. The Apache fix for the aforementioned problem required a rebuild; you need someone wise in the ways of make files and
RE: resizing/moving datafiles for performance ??
Hi, Assuming that all of the disk partitions are striped across all of the disk you probably won't see any performance difference wherever you put the files and whatever size you make them. At least nothing noticeable. If you can't change the disk layout maybe you can concentrate on scrutinising V$SQL to tune any queries that are generating too much disk activity. Regards, Mike Hately -Original Message- Sent: 19 July 2002 09:58 To: Multiple recipients of list ORACLE-L Guys, the DB is on 8.1.6 / Win2K. there entire DB ( 33 tables and 110 indexes) is in USERS tablespace. the USERS tablespace has only one datafile USERS.DAT of size 12GB. it's on 8 * 10 GB HDD with RAID 5. we are facing performance bottleneck now. V$SESSION_WAIT shows many rows for DB FILE SCATTERED READ and DB FILE SEQUENTIAL READ. all these events wait for USERS.DAT to be read. it's a highly read OLTP site. So,will moving the table and index data to different tablespaces with relatively smaller datafiles ( say 1 GB ) improve performance ? OR since it is on RAID5 , will moving make any difference ? 10-20 MB of data gets added to the DB daily. if resizing/moving improves performance,what should be the size of my datafile ? kindly give me a solution guys. TIA. This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike 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[2]: OFF TOPIC:Be careful from www.crescent.cc company
More links: Below has a guy called David from Crescent ([EMAIL PROTECTED]) asking about Oracle replication books.. http://www.amazon.de/exec/obidos/ASIN/1565924320/302-4085074-7640831 Below is a link pointing to a research paper on constraint directed problem solving, that Shiv Nagarajan worked on (to some success!).. Shiv was the guy that registered the domain, so is he the owner? http://www.uregina.ca/commun/Spark/limits.html I love detective work.. Not that it got me anywhere.. What do you think - should we phone Dr. Scott Goodwin to get Shiv's background? ; -Original Message- [EMAIL PROTECTED] Sent: 18 July 2002 17:53 To: Multiple recipients of list ORACLE-L Ruth, A search of the Internet for Crescent Cc revealed the following: Crescent Systems A Software Consuting Group Suite 1200 7735 Old Georgetown Rd. Bethesda, MD 20814 Phone: 301.657.8277 x222 fax: 301.657.3724 http://crescent.cc/ Which if you go there you end up with: The system cannot find the file specified. Looks like someone got scammed to me. Damned crooks/terrorists! Dick Goulet Reply Separator Author: Ruth Gramolini [EMAIL PROTECTED] Date: 7/18/2002 8:13 AM The domain .cc is defined as: CC Cocos (Keeling) Islands. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 10:23 AM Surely in your case that is all hypothetical isn't it Lee :) -Original Message- Sent: 18 July 2002 14:49 To: Multiple recipients of list ORACLE-L Caveat Emptor my friend. I would have never have sent either money or educational qualifications (esp. originals) either domestically or abroad to anyone, no matter what. Once bitten twice shy is a good way to look at it from your point of view. -Original Message- Sent: 18 July 2002 14:13 To: Multiple recipients of list ORACLE-L Hello, Guys, Thought of making all of you aware with dirty game played by Crescent Cc (www.crescent.cc). I got trapped with this company's offer letter and lost money, lost job, got lots of frustration etc. .etc Sharing this with all of you just thinking that - you guys will think twice before taking job with such fraud companies. This company takes either Original degree certificate or some big amount $$ from candidates to bring them in US. This is OK, if they at least fulfill their promises. But, this company simply puts candidate on hold I lost money... my few friends also lost money, couple of them sent original degree certificate... and company is not returning either their certificate or money... I am not sure - whether such companies are really existing in US? Can any one of you guys check if you stay in same town where company is having office? You will see n number of people calling before you sending certificate/money to them. Once they get certificate/money, they don't care about candidates. Few of those names are - Siva, Vidya Sharma, Yolandi Vanzyl, Andrew Tadikonda, Sebastian, Mehnaz Ahmed etc... etc Their email addresses are - Vidya - [EMAIL PROTECTED] Andrew Tadikonda - [EMAIL PROTECTED] Mehnaz Ahmed - [EMAIL PROTECTED] Yolandi Vanzyl - [EMAIL PROTECTED] Sebastian - [EMAIL PROTECTED] Siva - Don't know email id I am sharing my personal experience with all of you. Now, decision is up to you.. Just tried accessing www.crescent.cc website and seems to be down. Oops, has company shut down? Thanks. Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!! visit http://in.autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?SK=20OracleDBA?= 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. Thank You. -- Please see the
Re: fyi: oracle tech support link to free .zip utility
??? Is it the first free tool from Oracle :-) On Friday 19 July 2002 12:53, you wrote: follow up to the zip thread: http://ap103aru.oracle.com/unzips/unzips.html http://metalink.oracle.com/metalink/plsql/showDoc?db=NOTid=202255.1 ... Unzipping the Release 11.5.7 Maintenance Pack requires an unzip utility capable of handling a zip archive with more than 65,536 files. For example, Info-ZIP's UnZip (http://www.info-zip.org/pub/infozip/UnZip.html) version 5.41 or higher is capable of handling large zip archives. The UnZip source code is available for free, along with compiled executables of version 5.41 or higher for every Oracle Applications-certified operating system except IBM RS6000 AIX (please see below for alternatives). http://www.info-zip.org/pub/infozip/UnZip.html excerpt: | UnZip 5.50 | | The Third Most Portable Program in the World! * | | UnZip is an extraction utility for archives compressed in .zip format | (also called zipfiles). Although highly compatible both with | PKWARE's PKZIP and PKUNZIP utilities for MS-DOS and with Info-ZIP's | own Zip program, our primary objectives have been portability and | non-MSDOS functionality. ... -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- 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).
SET ORACLE-L NOMAIL
SET ORACLE-L NOMAIL Mit freundlichen Grüßen, Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 223-21 88 eMail: [EMAIL PROTECTED] -- 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: Where to Find Sample QUESTIONS for OCP-DBA Exams?
1. education.oracle.com 2. buy an ocp book or software from selftest.com joe Cruiser wrote: Hi list-guys ! I am a Newbee, preparing for OCP/DBA Oracle8i Exams. I would appreciate if some one can help me for the following queries. 1)When exactly Oracle8i is expiring? Is it favorible right now to register for Oracle 8i exams? 2)Is any body has sample questions for DBA exams or sort of BrainDumps (like MCSEs) ? BTW, I have visited http://orafaq.cs.rmit.edu.au checked 10 sample questions as the site offers as demo. But I need more free sample questions to pass exam, please help me. Syedriyaz. -- 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: Cognos
We had a similiar experience here. I would say that only 10% of the users are really using PowerPlay to its full potential. It requires: 1) a person with analytical skills 2) a person with a very good understanding of the data 3) a person that has time to play with the data. Most of the other users bring up canned PowerPlay reports, and tweak a dimension or two. Very few of them build their own reports and drill deep down into the data. I still think it is a great tool. I setup an cube based on the concurrent requests in our Oracle Financial system. I can find bottlenecks in the concurrent managers, see who submits the most intensive reports, etc. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 05:11PM We have deployed cognos, first a local install on all P.C.'s and we are now migrating to the Web based solution. The original selling point was that everybody would be able to quickly and easily create their own reports, with the users accessing our production databases. How wrong that was. What we have now is a central database (we call it a datawarehouse) that houses snapshots and custom reporting tables. All reports are basically canned, and we have a staff member who function is to maintain/build reports and the warehouse. At some point I am sure that users will be able to create their own reports, but from our datawarehouse, not production. -Original Message- Sent: July 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman 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: Browett, Darren 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Sequence number generation
So far we haven't gotten into a problem of locking, there are about 15-20 users of the system. -Original Message- Sent: Thursday, July 18, 2002 8:28 PM To: Multiple recipients of list ORACLE-L Subject:RE: Sequence number generation I really don't see where this method scores over a sequence number. But I can see a number of places where it loses out. What happens when you select from the table and then don't commit the transaction that selected it? You'll still have a gap in your sequence. It's the same as a sequence but with a larger overhead, slower performance and Igor mentioned the possibility of locks on the table stopping the update processes altogether. Just (as they say) my deux euros Mike - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 3:38 AM To have a better control, we always use tables for holding counters. Depending upon the requirement, either one table to hold different counters or multiple tables, sometime in master tables as well. This does not any additional coding, the trigger in which you fetch from sequence you select from table. To keep it synchronized with the transaction, we make counter table block HTH! Aleem -Original Message- Sent: Thursday, July 18, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sequence number generation It is not possible to avoid sequence number loss . If a user requests a sequence number, then ultimately rolls back that transaction, that sequence number is lost . However you can catch such lost sequence numbers programatically and reuse then. that would require a bit of extra coding. -Original Message- Sent: Thursday, July 18, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi Is it possible to avoid sequence number loss in the sequence number generation. if so how? Thanks in Advance Ayyappan.S Dreams translate into thoughts, and thoughts translate into action: Kalam This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S 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: Ratnesh Kumar Singh 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: Abdul Aleem 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
RE: SET ORACLE-L NOMAIL
HILFE -Original Message- Sent: Friday, July 19, 2002 7:33 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL Mit freundlichen Grüßen, Brigitte Türk KAUFHOF WARENHAUS AG IT-Controlling Datenbankadm. Leonhard-Tietz-Str. 1 D-50676 Köln Tel.:+49 (0)221 223-21 88 eMail: [EMAIL PROTECTED] -- 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: 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: finding pasword emails. Virus ???
DON'T OPEN THEM! It is the frenthem worm virus. It send itself to everyone in your address book if you use Outlook. Doesn't seem to do anything else. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 5:13 PM Hello list, I'm getting many finding pasword emails from non-registered users. have you got this type of email ? is it a spam or virus ? regards... -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) 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: Ruth Gramolini 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).
