RE: Importing Schema getting compilation errors on some triggers

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

RE: Importing Schema getting compilation errors on some

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

RE: Importing Schema getting compilation errors on some

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

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,

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:

RE: sql query: to_date() :ORA-01830: date format picture ends bef

') 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

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

RE: How long to hold onto old Oracle CDs?

(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

RE: Top 10 normalised down to Top 2

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

RE: How long to hold onto old Oracle CDs?

-- 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

RE: Programming languages that make DBA's lives easier

://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

RE: Teradata baned from IOUG???

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

RE: Updating error

-- 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

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

RE: Take Care of your DBAs

, 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

RE: 8i: how to find current scn number?

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

RE: Take Care of your DBAs

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

RE: Case of the Missing Rows

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

RE: Case of the Missing Rows

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

RE: Case of the Missing Rows

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

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(*)

RE: Producing .mdb output from sqlplus or SQL or PL/SQL

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