RE: Importing Schema getting compilation errors on some triggers
Scott: My first thought is to ask if there are any external references (other schemas, SYS packages, etc.) in the triggers that may not exist in TRAIN that do exist in TEST Rick Weiss -Original Message- Sent: Friday, April 04, 2003 13:14 To: Multiple recipients of list ORACLE-L Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Importing Schema getting compilation errors on some
Do you have execute privs set for MAILER.DBMS_OFFICE?? Does it exist on the second database?? Is the MAILER schema on the database? (I'm climbing my ladder of thoughts as I'd check them) Just a thought Rick Weiss Helena, MT USA -Original Message- Sent: Friday, April 04, 2003 15:24 To: Multiple recipients of list ORACLE-L Here is the output of the show errors command (which I didn't know about... Thanks). == SQL show errors trigger famis_pr_status_insert Errors for TRIGGER FAMIS_PR_STATUS_INSERT: LINE/COL ERROR - 106/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 106/32 PL/SQL: Statement ignored 180/32 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 180/32 PL/SQL: Statement ignored SQL SQL show errors trigger famis_req_insert Errors for TRIGGER FAMIS_REQ_INSERT: LINE/COL ERROR - 187/21 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 187/21 PL/SQL: Statement ignored 264/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 264/25 PL/SQL: Statement ignored 339/25 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 339/25 PL/SQL: Statement ignored 416/24 PLS-00201: identifier 'MAILER.DBMS_OFFICE' must be declared 416/24 PL/SQL: Statement ignored SQL = I'm guessing it's a problem with DBMS_OFFICE and not with the trigger after seeing this. -Scott At 01:43 PM 4/4/03 -0800, you wrote: Scott, can you run this command in sqlplus and e-mail the results out to us... show errors trigger triggername [EMAIL PROTECTED] 04/04/03 02:14PM Hello, Oracle 8.1.7.4 HPUX 11.11 App is Famis Maintenance Management System I have 3 instances TEST, TRAIN, PROD and I am trying to refresh the whole famis schema on TRAIN with the famis schema on TEST. Every time I try to do the import, I get compilation errors for 4 triggers (out of 75). I tried to re-compile them in the TRAIN instance after the import and get the same compilation errors. I try to re-compile them in TEST which is where they came from and they compile without a problem. I don't understand why this would happen when I exported the whole schema from TEST and imported the whole .dmp file into TRAIN. Any Thoughts? -Scott ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California
RE: Importing Schema getting compilation errors on some
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.net--Author: Darrell Landrum INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [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).**Scott StefickSystems / Oracle Certified DBAWm. Rainey Harper College847.925.6130**-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Scott Stefick INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list you want to be removed from). You may also send the HELPcommand for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Weiss, Rick INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). ** Scott Stefick Systems / Oracle Certified DBA Wm. Rainey Harper College 847.925.6130**
Copying PL/SQL Objects
Title: Copying PL/SQL Objects I have a question for the group: What is the best way to copy a large set (400 pkgs alone) of PL/SQL objects (procedures, packages, etc.) from SCHEMA_A on database A (8.1.7.2 on AIX) to SCHEMA_A on database B (9.2.0.2 on W2K) without whacking the tables, indexes on database B? I have thought about EXP/IMP, but the tablespace names do not match. Thanks Rick Weiss
RE: POLL: Database to DBA ratio
Title: Message Not mention the afternoons at Big Sky and Bridger working as a ski run quality assurance tester! ; ) Rick Weiss -- Helena, Montana We know better -Original Message-From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 12:51To: Multiple recipients of list ORACLE-LSubject: RE: POLL: Database to DBA ratio We have 4 production Oracle databases and 3 DBA's. Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines. --Walt Weaver Bozeman, Montana -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: sql query: to_date() :ORA-01830: date format picture ends bef
You are comparing CHAR to DATE, you would need one of the following
conditions
1- where DATECREATED = to_date('01-FEB-03 07:53:28','DD-MON-YY HH24:MI:SS')
2- where to_char(DATECREATED,'DD-MON-YYY HH24:MI:SS') = '01-FEB-03 07:53:28'
to be able to complete the WHERE clause
Rick Weiss
Oracle DBA
-Original Message-
Sent: Tuesday, March 11, 2003 13:20
To: Multiple recipients of list ORACLE-L
Hi...
I am getting the following error with a query like this
select * from cust where
to_char(DATECREATED,'DD-MON-YYY HH24:MI:SS') = to_date('01-FEB-03
07:53:28','DD-MON-YY HH24:MI:SS')
ORA-01830: date format picture ends before converting entire input string
What is the problem?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Weiss, Rick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Skill Sets - This may be a dumb question
Title: Message Ken: My sympathies go out to you too, I spent the time from 04/01 until 12/01 unemployed as well. Tough way to go in any market, try one in a small (30K population) market that is 90+% dependent on asmall state's government for work. I'm very thankful to be working yet (contract could end any day). (Arise to soapbox) And yes Lisa, I am considered by many around here to be more of a Data Architect than a DBA (which I must say irritates me quite a bit)since I have designed (from first cut E/R design through physical implementations in DEV, TEST and PROD)from ground zero more than 10 different systems in the last 7 years. I do try to keep my hand in the tuning and administration of the systems until they are turned over to clients for operational support. I want to get a production support type contract in the future to further enhance my skills, but whatever it takes to keep the mortgage paid. (Step down and don flame proof clothing) Rick Weiss -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:04To: Multiple recipients of list ORACLE-LSubject: Re: Skill Sets - This may be a dumb question Lisa: I know you are disappointed, but be happy you have a job. I was laid off a year ago and the job situation here in the TC's area is not improving. I'll trade places with you any day. Ken Janusz, CPIM Hugo, MN - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Tuesday, February 25, 2003 10:34 AM Subject: Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft Oracle/AIX environment but management here decided that it was more important to separate a husband and wife that both work in the same department, and assigned one of them to be primary support in this environment instead of me. (sshh: The new person who is primary doesn't know a thing about Unix.) My primary job is now suppossed to be data modeling and data warehouse/mart design, moving on into Problematica (er, Informatica) development into a Sql Server database. I will not be the admin on the Sql Server database. My new boss referred to this as "database architecture". ?? What? They have already decided what they want done and just want someone to take the pretty pictures and implement them with unrealistic deadlines. The main reason why I am upset is because it seems to me that data modeling is such a "soft" skill. I am concerned about keeping my skills up to date and keeping my hands in an Oracle environment, whether it's a mess or not. Seems to me that data modeling alone isn't something that can land you a new job or really spiff up your resume. I think that having a finite list of skills (Oracle, Unix, Windows 2000, Erwin, Project, crap like that) is more what employers search for, and is what HR depts can easily deal with. Am I wrong? This job pays well and working for a huge company has it's benefits, if you can deal with the bureaucracy similar to what is described in the 1st paragraph. And I know in this market I am just lucky to have a job. And please tell me if I'm whining. I may just need a KITA. Who knows anymore... Lisa Koivu Oracle Drink Beer Again Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking proactive and remedial action about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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 long to hold onto old Oracle CDs?
Tim: I can't say that I can shoot BB's @ 10M, I prefer a .30 caliber @ 150 yds, although I must admit that I can't keep them inside the center hole at that distance. I do know they don't load worth a hoot with 3 or 4 extra holes in them ;} Rick Weiss -Original Message- Sent: Monday, February 24, 2003 09:14 To: Multiple recipients of list ORACLE-L Under no circumstances would you consider moving your production db back from 8.1.7 to 7.3.3, would you? So the only possible reason for retaining them would be to support a newly-acquired application (!?!?!?!). Even if you still had the CDs, shouldn't you just say you didn't? :-) They make great tacky drink coasters. If you're into skeet shooting or plinking, then there's another good use... Speaking of plinking, former Minnesota Governor (and boa-wearing pro wrestler) Jesse Ventura had a quote that was relevant: Gun control? Sure I believe in gun control. Putting three shots through the same hole -- that's gun control! If you can put a BB through the drive hole of the CD without touching from 10 meters out, that's gun control! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 24, 2003 8:33 AM I stil have my 4.1.14 installation for DOS 3.3. (3 5.25 floppies) -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Subject: How long to hold onto old Oracle CDs? Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore. Anybody want some old CDs? :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Top 10 normalised down to Top 2
Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (It's everywhere that I am!) Author of several books you can find on Amazon.com! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Darrell Landrum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com
RE: How long to hold onto old Oracle CDs?
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Programming languages that make DBA's lives easier
FORTRAN - Only one or two of us left that have even heard of it, much less actually made $$$ using it Rick Weiss -Original Message- Sent: Thursday, February 20, 2003 10:59 PM To: Multiple recipients of list ORACLE-L Assembler. On Wednesday 19 February 2003 03:33, Robson, Peter wrote: I wonder if I can throw in a further caveat to the choices people would make? If you had to choose a programming language in which to write a program or application in which you wished to conceal your intellectual property, which would you use? peter edinburgh -Original Message- Sent: Tuesday, February 18, 2003 10:56 AM To: Multiple recipients of list ORACLE-L On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Teradata baned from IOUG???
The PHB is from Dilbert (Pointy Haired Boss) Rick Weiss -Original Message- Sent: Wednesday, February 12, 2003 8:04 PM To: Multiple recipients of list ORACLE-L PHB's? I looked it up and all I could find that fit was Psycho Hose Beast. Is that correct? http://www.acronymfinder.com/af-query.asp?Acronym=PHB Jared.Still@radis ys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Teradata baned from IOUG??? 02/12/03 05:03 PM Please respond to ORACLE-L I can't imagine why they would want to replace Oracle with Teradata. It's expensive. It runs only on NCR or Windoze. The architecture is nothing special. I imagine the PHB's had their fingers in those moves. Been there, got the T-shirt, now it's a dust rag. Jared James Howerton [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/12/2003 01:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Teradata baned from IOUG??? DBA's Check the article's comment on Oracle trying to ban Teradata from IOUG Teradata Steals Oracle's Data Mart Users ... Teradata pushes consolidation and woos away Oracle customers. But Oracle strikes back. Sort of. Will bean counters surf the Web with Excel? Will Steve Ballmer and Larry Ellison become immortal? http://computerworld.com/newsletter/0%2C4902%2C78375%2C0.html?nlid=DM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Updating error
David: I would say that there is a foreign key on the originating_carrier column and the value 0110 does not exist in the parent table. Rick Weiss -Original Message- Sent: Tuesday, February 11, 2003 11:00 AM To: Multiple recipients of list ORACLE-L I attempt to update a record and receive following error. How do I fix it? update trunkgroup set originating_carrier = 0110,trunkgroup_id2 = 606,' where trunkgroup_id = '0TWPAAEDS0' and gateway_id = 'GAAA0'; ERROR at line 1: ORA-02291: integrity constraint (DBIMPL.CARRIER_FK9) violated - parent key not found Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Version Controlling in Oracle database - Ideas ?
Title: Message There is a product from CA (they got it when they bought out Platinum Technology) called SQL-Station. It is now a part of the Unicenter environment. It provides a cooperative development that includes versioning and deployment options. I've used it in an environment with 15 developers working on various pieces of a system without problems. It does code management through a database repository, and it has a code debugger and analyzer available. Rick Weiss -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 11:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Version Controlling in Oracle database - Ideas ? Is it available in the Market OR is there a special procurement Channel for it ? Any Details please , Links , Docs ? Thanks -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Friday, February 07, 2003 11:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Version Controlling in Oracle database - Ideas ? I believe this feature coming in new TOAD ... its available in Beta though ... I think it is called 'Team Coding ... something' Another product is Oracle SCM ... Raj -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Version Controlling in Oracle database - Ideas ? Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from TOAD and Y needs to work on the same file (assuming they have the same privilege), Y should not be allowed to work on the object till X finishes working on it. We want to put a restriction on the database objects such that simultaneously no two users should be able to work it. Integrating VSS with TOAD was not acceptable since it would be file based(saving the .sqls). Qs. Is there any feature available in Oracle(with oracle 8.1.7) or any third party tool that does this ? so send the HELP command for other information (like subscribing).
RE: Take Care of your DBAs
You ought to see what happens in Phoenix when it rains. Wrecks, traffic snarls, yuck. It must be the fact that they never see anything remotely resembling water (except in pools). Oh yeah, that's right. I left there years ago for Montana. Never mind. Snow, rain, four seasons. This is living Rick Weiss -Original Message- Sent: Thursday, January 30, 2003 9:01 AM To: Multiple recipients of list ORACLE-L You gentlemen do not know what it is like to have snow related traffic problems. In Atlanta a snow flake can cause a multi-car pileup with a 3 hour commute delay. Why just having cold weather (20 degrees F) will cause schools to close. Boy I miss New England. Transplanted CT Yankee, Ron [EMAIL PROTECTED] 01/30/03 10:09AM It's nice to have four seasons. As long as the temperature doesn't drop under 60 during any of those four seasons. Four feet of snow? Here in CT, we had few inches and the traffic collapsed. What do you drive? Sherman tank? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: 8i: how to find current scn number?
How about this method?? Real ugly
SQL*Plus: Release 9.2.0.1.0 - Production on Thu Jan 30 12:25:17 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
12:25:19 SQL CREATE TABLE scn ( scn varchar2(25));
Table created.
12:25:40 SQL INSERT INTO scn VALUES(
TO_CHAR(userenv('commitscn'),999));
1 row created.
12:26:41 SQL select * from scn;
SCN
-
98038268
1 row selected.
12:26:48 SQL
I hope that I haven't totally missed the question
There's always more than one way to do the Oracle thing
Rick Weiss
-Original Message-
Sent: Thursday, January 30, 2003 11:36 AM
To: Multiple recipients of list ORACLE-L
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
With the Partitioning option
JServer Release 8.1.7.3.0 - Production
SQL create table scn(scn number);
Table created.
SQL insert into scn values(userenv('COMMITSCN'));
1 row created.
SQL select * from SCN;
SCN
--
4.3002E+12
SQL
Unfortunately, you cannot directly 'SELECT' the function ...
- Original Message -
From: Daiminger, Helmut
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thu, 30 Jan 2003 05:25:14
Hi!
How do I find out the current scn number that the
database is at?
In 9i I could use dbms_flashback package...
This is 8.1.7 on Solaris 8.
Thanks,
Helmut
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroul
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Weiss, Rick
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: Take Care of your DBAs
Although I might resemble that remark, I still welcome the opportunity to take fellow DBA's on a hike/hunt/fish expedition in Big Sky country. But you have to bring your own pepper spray and bear bells Rick Weiss -Original Message- Sent: Wednesday, January 29, 2003 3:30 PM To: Multiple recipients of list ORACLE-L Lisa - Some of us became DBAs because we realized we would never be able to feed our families on our physical abilities. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 29, 2003 3:55 PM To: Multiple recipients of list ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, January 29, 2003 2:49 PM To: Multiple recipients of list ORACLE-L shooting hoops? Just out of curiosity, how many people on the list have a group of DBAs at their company that they shoot hoops with? Some good points, some odd ones. I'll echo Patrice's sigh (as someone who enjoys both parts of the job). Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Case of the Missing Rows
Title: Message Nope, .BAD file is empty, I have been experimenting this morning with cloning the table as suggested earlier, but every DDL statement against the table drops the rows (#'s 70-1417) of the ID PK Column. Still working on that angle Rick Weiss -Original Message-From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 8:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Case of the Missing Rows Could they be in the .bad file? I have had stuff go there if a column was too long or something. Ruth - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Monday, January 27, 2003 7:43 PM Subject: Re: Case of the Missing Rows My guess is that SQL*Loader didn't really load 88,640 rows, but rejected or discarded about 1400 of them? - Original Message - From: Weiss, Rick To: Multiple recipients of list ORACLE-L Sent: Monday, January 27, 2003 4:53 PM Subject: Case of the Missing Rows I have a recurring, repeatable problem I was wondering about its cause. Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4 Step 1 - I do an SQLLDR process that loads 88640 rows to a table Step 2 - SQL*Plus session - SELEC COUNT(*) from the table returns 88640 rows Step 3 - Do an EXP on the table (to allow fall back to this point) - only exports 87257 rows Step 4 - SQL*Plus session again - SELEC COUNT(*) from the table returns 87257 rows No one else has access to the database. There are no unusual entries in the alert log. There is nothing I have found in the UDUMP or BDUMP directories that would help. Has anyone else experienced this?? Thanks Rick Weiss
RE: Case of the Missing Rows
Title: Message Dan: Thanks, I think I got through it, here's what I've found (explanations would be greatly appreciated) 1) Created table as before from Designer/2000 scripts with indexes and constraints 2) SQLLDR to create initial data list 3) SELECT COUNT(*) FROM TB - yields 88640 rows 4) RENAME TB TO TB_HOLD (takes indexes along) 5) SELECT COUNT(*) FROM TB_HOLD - yields only 87257 rows (ahhh nuts) 6) TRUNCATE TABLE TB_HOLD 7) CREATE TB AS SELECT * FROM TB_HOLD - two empty tables 8) SQLLDR into TB 9) SELECT COUNT(*) FROM TB - yields 88640 rows 10) INSERT INTO TB_HOLD (SELECT * FROM TB) - inserts 88640 rows 11) ANALYZE both tables COMPUTE STATISTICS 12) SELECT COUNT(*) FROM TB - yields 88640 rows 13) SELECT COUNT(*) FROM TB - yields 88640 rows 14) EXP - both tables now export 88640 rows What in the world is going on?? Great puzzler for the group to mull over No jobs scheduled except for RMAN level 0 on Friday mornings@ 5:30 and other daily level 1 cumulatives and a weekly full DB export on Fridays @ 2:30 Rick Weiss Oracle DBA -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 7:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Case of the Missing Rows Rick, Try the following to see which rows are missing. It the same rows are missing each time, perhaps there is a common thread. If not, well After Step 2, do a create table as select or sql*plus copy. This will create a backup version. Do a count(*) from each to make sure the numbers agree. After Step 4, select * from table1 minus select * from backup_copy to locate the missing rows. Dan Fink -Original Message-From: Weiss, Rick [mailto:[EMAIL PROTECTED]]Sent: Monday, January 27, 2003 4:54 PMTo: Multiple recipients of list ORACLE-LSubject: Case of the Missing Rows I have a recurring, repeatable problem I was wondering about its cause. Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4 Step 1 - I do an SQLLDR process that loads 88640 rows to a table Step 2 - SQL*Plus session - SELEC COUNT(*) from the table returns 88640 rows Step 3 - Do an EXP on the table (to allow fall back to this point) - only exports 87257 rows Step 4 - SQL*Plus session again - SELEC COUNT(*) from the table returns 87257 rows No one else has access to the database. There are no unusual entries in the alert log. There is nothing I have found in the UDUMP or BDUMP directories that would help. Has anyone else experienced this?? Thanks Rick Weiss
RE: Case of the Missing Rows
Yes, only after an empty build from scratch No triggers at all on either table Rick -Original Message- Sent: Tuesday, January 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L swag -- is there a trigger on either of those tables? sounds like the possibility of an AFTER STATEMENT trigger this is of course, total guesswork but it only occurs when you create the table from scratch, or at least that's how I'm reading what you wrote --- Weiss, Rick [EMAIL PROTECTED] wrote: Dan: Thanks, I think I got through it, here's what I've found (explanations would be greatly appreciated) 1) Created table as before from Designer/2000 scripts with indexes and constraints 2) SQLLDR to create initial data list 3) SELECT COUNT(*) FROM TB - yields 88640 rows 4) RENAME TB TO TB_HOLD (takes indexes along) 5) SELECT COUNT(*) FROM TB_HOLD - yields only 87257 rows (ahhh nuts) 6) TRUNCATE TABLE TB_HOLD 7) CREATE TB AS SELECT * FROM TB_HOLD - two empty tables 8) SQLLDR into TB 9) SELECT COUNT(*) FROM TB - yields 88640 rows 10) INSERT INTO TB_HOLD (SELECT * FROM TB) - inserts 88640 rows 11) ANALYZE both tables COMPUTE STATISTICS 12) SELECT COUNT(*) FROM TB - yields 88640 rows 13) SELECT COUNT(*) FROM TB - yields 88640 rows 14) EXP - both tables now export 88640 rows What in the world is going on?? Great puzzler for the group to mull over No jobs scheduled except for RMAN level 0 on Friday mornings@ 5:30 and other daily level 1 cumulatives and a weekly full DB export on Fridays @ 2:30 Rick Weiss Oracle DBA -Original Message- Sent: Tuesday, January 28, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Rick, Try the following to see which rows are missing. It the same rows are missing each time, perhaps there is a common thread. If not, well After Step 2, do a create table as select or sql*plus copy. This will create a backup version. Do a count(*) from each to make sure the numbers agree. After Step 4, select * from table1 minus select * from backup_copy to locate the missing rows. Dan Fink -Original Message- Sent: Monday, January 27, 2003 4:54 PM To: Multiple recipients of list ORACLE-L I have a recurring, repeatable problem I was wondering about its cause. Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4 Step 1 - I do an SQLLDR process that loads 88640 rows to a table Step 2 - SQL*Plus session - SELEC COUNT(*) from the table returns 88640 rows Step 3 - Do an EXP on the table (to allow fall back to this point) - only exports 87257 rows Step 4 - SQL*Plus session again - SELEC COUNT(*) from the table returns 87257 rows No one else has access to the database. There are no unusual entries in the alert log. There is nothing I have found in the UDUMP or BDUMP directories that would help. Has anyone else experienced this?? Thanks Rick Weiss __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Case of the Missing Rows
Title: Case of the Missing Rows I have a recurring, repeatable problem I was wondering about its cause. Oracle 9.2.0.1 on W2K Professional (SP2) Dell Optiplex workstation Pentium 4 Step 1 - I do an SQLLDR process that loads 88640 rows to a table Step 2 - SQL*Plus session - SELEC COUNT(*) from the table returns 88640 rows Step 3 - Do an EXP on the table (to allow fall back to this point) - only exports 87257 rows Step 4 - SQL*Plus session again - SELEC COUNT(*) from the table returns 87257 rows No one else has access to the database. There are no unusual entries in the alert log. There is nothing I have found in the UDUMP or BDUMP directories that would help. Has anyone else experienced this?? Thanks Rick Weiss
RE: Producing .mdb output from sqlplus or SQL or PL/SQL
Patrice: I have used the data extract function in EXCEL to select data from views and tables in my database using an ODBC connection. I imagine you could do the same thing from within ACCESS as well. You run the query and it populates the spreadsheet which can then be saved. Rick Weiss Oracle DBA (certifiable, but not certified) -Original Message- Sent: Friday, January 24, 2003 2:19 PM To: Multiple recipients of list ORACLE-L I am wondering if it is possible to produce .mdb or .xls format files from inside Oracle. Can this be done? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weiss, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
