RE: Unix host name change - what happens to db?

2003-06-04 Thread Sarnowski, Chris
FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOV

RE: linux intel support matrix

2003-04-04 Thread Chris Berry
From: "Weaver, Walt" <[EMAIL PROTECTED]> They make you work in the afternoon --Walt Weaver Bozeman, Montana You mean sometimes you aren't at work? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside us, and sel

RE: Remote DBA

2003-04-03 Thread Chris Berry
boxes and vice versa. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides _ STOP MORE SP

Re: dbshut script - shutdown or shutdown immediate

2003-04-03 Thread Chris Berry
From: Joan Hsieh <[EMAIL PROTECTED]> Chris, We hang on shutdown immediate, not startup. That's why I choose to use shutdown abort. Well, in that case of course you'd use it, but personally, if it was me, I'd want to find out why it was hanging, and fix that instead. I'

RE: Remote DBA

2003-04-02 Thread Chris Berry
little experience with remotely managing Oracle on a Windows platform, but I'm sure someone on the list does it. I do both platforms, my recommendation is OpenSSH + VNC, they work great, they're free, and they're available for both platforms. Chris Berry [EMAIL PROTECTED] Sys

Re: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Chris Berry
From: Jeremiah Wilton <[EMAIL PROTECTED]> On Wed, 2 Apr 2003, Chris Berry wrote: > Shutdown abort is pretty drastic, are you sure shutdown immediate > didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://

Re: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Chris Berry
(some error, forgot on reporting database) otherwise, I will add to it. If it's hanging on the startup I recommend trying this: shutdown immediate startup nomount alter database mount alter database open You should get an error message at one of those

Re: dbshut script - shutdown or shutdown immediate

2003-04-02 Thread Chris Berry
t; any connections? > > Environment is Oracle 8.1.7 /AIX 4.3.3. From: Joan Hsieh <[EMAIL PROTECTED]> Peter, I modified to shutdown abort, starup then shutdown immediate. Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Chris Berry [EMAIL PROTECTED] Syste

RE: RMAN question.... (figured out if anywone is interested)....w

2003-04-02 Thread Chris Stephens
ase format '/oracle_backup/ASTU/%U' include current controlfile; ..places the contrlofile in the specified directory along with all other backup pieces. Thanks for all input. Chris And now for the next step... .anyone have a script handy to query the catalog directly and

Re: How to use small oracle database in my program

2003-04-01 Thread Chris Berry
application, and while I highly recommend it for OLTP and DSS, for your situation, you probably want something more like MySQL or MS Access. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside us, and seldom awakens. The sleeper

RE: Lies, damn lies and statistics

2003-04-01 Thread Sarnowski, Chris
are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarno

Re: OT- Start a process after oracle on Win 2K

2003-04-01 Thread Chris Berry
couple of scripts and I would envisage running them as a batch file What is best? If you have Active Directory just set it up in the GPO for the machine to run at startup. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside us, and seldom aw

RE: RMAN question....

2003-04-01 Thread Chris Stephens
ontrolfile to ''/oracle_backup/ASTU/astu_ctl''"; exit; EOF # Thanks for the input Dennis!! Ps. I read your review of "The Art and Science of Oracle Performance Tuning" on amazon and decided to give it a try myself.  I'm about 60 pages into it.  It

RMAN question....

2003-03-31 Thread Chris Stephens
ent controlfile); } sql "alter system switch logfile"; sql "alter system archive log all"; sql  "alter database backup controlfile to trace"; sql  "alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''"; exit; EOF # any and all help will be GREATLY appreciated.  I won't be sleeping well until I know the backup process is truly ok. Thanks Chris

RE: OT: uuencode adding characters

2003-03-28 Thread Chris Berry
file.txt"; while () { ®ex } close INPUT_FILE; close OUTPUT_FILE; sub regex { } Where the regex subroutine will contain the code which finds and eliminates the nasty characters you want to remove. If you're a minimalist, you could probably rewrite the whole thing to be a single inli

RE: may not be necessary -- was RE: Oracle DB Backups on SAN with

2003-03-28 Thread Sarnowski, Chris
cations of using this as a backup method. If you're not using Shadow mirror, but some other mirror method, the above may not apply. Hope this helps. -Chris > -Original Message- > From: Hemant K Chitale [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 27, 2003 9:44 AM >

Re: utl_smtp error

2003-03-28 Thread Chris Berry
From: Joan Hsieh <[EMAIL PROTECTED]> Thanks for explantion. I asked the smtp mail admin. He said The relays are running Exim-4.10. Is that help? What is it you're trying to mail from the database? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change,

RE: Configuring Oracle with RAID and OFA

2003-03-27 Thread Chris Berry
osting and leaving all the previous messages, but I don't want to break etiquette if that's desired here, how do you like your answers? (usually I trim and post to the bottom) Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside u

Re: utl_smtp error

2003-03-27 Thread Chris Berry
From: Joan Hsieh <[EMAIL PROTECTED]> Chris, you got me, what MTA stand for? Mail Transfer Agent, its the program that uses SMTP to send or recieve mail. Examples: Sendmail Courier Postfix Exim qmail MS Exchange Don't confuse this with an MUA (mail user agent) which allows you to c

Re: OT: uuencode adding characters

2003-03-27 Thread Chris Berry
lean it up, take about 3 lines of code. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken." -- Duke Leto Atreides __

RE: utl_smtp error

2003-03-27 Thread Chris Berry
t; I checked all the related documents regarding these errors. Nothing really matches our case. Does anyone can point me where I should look into it? What MTA are you running? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates "Without change, something sleeps inside us,

RE: Configuring Oracle with RAID and OFA

2003-03-27 Thread Chris Berry
x27;t make pronouncements like "you shouldn't run a production database on a single RAID set" because sometimes you have to. Oh yeah -- the database ran fine, we had no performance problems and we DID have good backups. So what setup would you have preferred if it was all up to you

RE: sort ip addresses

2003-03-25 Thread Sarnowski, Chris
r any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Serv

RE: Unix command

2003-03-25 Thread Sarnowski, Chris
find . -name \*.txt man ls and man find for many more details. If you do ls |grep txt as suggested by another list member, you'll get matches to txt.dat and nextxtsystem.config and so on. This is equivalent to ls -1 *txt* man grep for more details. -Chris > -Original Messag

memory for 9i

2003-03-18 Thread Sarnowski, Chris
one of the requirements. The reason this is an issue is because there is some interest in throwing this thing on a laptop, and I'd rather put it on a Sparc laptop than have to go through a crash course in Solaris for intel, Linux, or Windows management. Thanks for any advice. -Chris LEGAL

RE: log buffer space

2003-03-14 Thread Chris Stephens
Title: RE: log buffer space I think this might help... http://www.ixora.com.au/tips/tuning/log_buffer_size.htm -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Friday, March 14, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: log b

RE: Excessive SQL*Net message from client waits

2003-03-13 Thread Chris Stephens
Title: RE: Excessive SQL*Net message from client waits This is an idle wait event that just means the server is waiting to be given some work from the client.  Looks to me like you won't be needing to do any tuning on this database. -Original Message- From: Karen Morton [mailto:[EMAIL

RE: Oracle Database audit...

2003-03-11 Thread Chris Stephens
Title: Oracle Database audit... Oops.   This wasn't meant to go to the list.   sorry   -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Database

Oracle Database audit...

2003-03-11 Thread Chris Stephens
Title: Oracle Database audit... This may or may not be of value... Under the Security: Possibly users with the oracle account password on the machine? This would obviously allow people to conn / as sysdba. Maybe? :) Have a good one!

RE: Oracle position on hints

2003-03-08 Thread Grabowy, Chris
ay" __ 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?

OT - Oracle work in Tampa/Orlando, Florida.

2003-03-03 Thread Grabowy, Chris
Title: OT - Oracle work in Tampa/Orlando, Florida. Sorry for the off topic post. Does anyone on the list live/work in Orlando/Tampa?? I am looking to make a move down to that area sometime in the near future.  So I am obviously seeking any information anyone is willing to share about Orac

RE: update 30mil rows

2003-02-26 Thread Chris Stephens
Title: RE: update 30mil rows You did enable parallel dml right? =>alter session enable parallel dml; -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 25, 2003 3:27 PM To: Multiple recipients of list ORACLE-L Subject: update 30mil rows Hi all:

RE: Skill Sets - This may be a dumb question

2003-02-25 Thread Grabowy, Chris
Title: Message Don't you just HATE change.  You were getting all nice and comfy in your current job, and mgmt throws you a curve ball.   This has happened to me a few times, and I have learned to "step into their shoes" to try and better understand why.  Why me!!!?!?  Not that I ever agreed

RE: newbie sqlplus ?

2003-02-24 Thread Chris Stephens
ey to improving i/o rates.  The specifics are documented many places.  ...although it isn't very straight forward and depends on the usage of the database.   Off the top of my head, Steve Adam's website has some VERY good information on I/O.  www.ixora.com.au     chris -Original Me

RE: newbie sqlplus ?

2003-02-24 Thread Chris Stephens
w/o the install going haywire?  Can I still delete the old db w/ dbassist after the install? - Original Message - From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: Monday, February 24, 2003 1:30 PM Subject: RE: newbie sqlplus ?   Launch

RE: select count(case ...) slow in PL/SQL, any better way?

2003-02-24 Thread Sarnowski, Chris
ow you are using the counts - and don't tell me because we are competitors). -Chris > -Original Message- > From: gmei [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 4:07 PM > To: Multiple recipients of list ORACLE-L > Subject: select count(case ...)

RE: select count(case ...) slow in PL/SQL, any better way?

2003-02-24 Thread Sarnowski, Chris
k. > This is more the solution I was going to recommend but I'd do this instead: select sum(decode(geneid, geneid1, 1, 0)), sum(decode(geneid, geneid2, 1, 0)) into count1, count2 from isi.nametag where geneid in (geneid1, geneid2); If these are primary key values you are really

RE: newbie sqlplus ?

2003-02-24 Thread Chris Stephens
Title: RE: newbie sqlplus ? Launch $ORACLE_HOME/bin/dbassist and delete any database you have created. Then launch the installer from your oracle cd and select deinstall option to deinstall the software. chris -Original Message- From: Les Ayudo [mailto:[EMAIL PROTECTED]] Sent

RE: Teradata baned from IOUG???

2003-02-24 Thread Bowes, Chris
ave a problem with Rich's work and can prove it is incorrect and/or dangerous, then say so and put out your reasons.  You may save someone from a mistake that will cost them.  Let those who agree with Rich respond with their say and hash it out, here on the list.  That is, in it's essence, w

Production database configuration high-level check list...

2003-02-24 Thread Grabowy, Chris
ite papers, insults, etc.) Many thanks. Chris Security * Lock out back door accounts. * Change passwords for SYS, SYSTEM, and INTERNAL to non-dictionary words. * Change passwords for the application

function based indexes.

2003-02-21 Thread Chris Stephens
nd all design suggestions.   Thanks.  BEER ME! chris   -Original Message- From: Nick Wagner [mailto:[EMAIL PROTECTED] Sent: Friday, February 21, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oh Where Oh Where Is My Redo Coming From   Since SharePlex for Oracle

storing credit card numbers in a database

2003-02-21 Thread Chris Stephens
then pass that string to the database? We don't want anyone to be able to get to the numbers even if they have access to the table in which it is stored. Thanks for any input chris

RE: yapp_pack.zip

2003-02-19 Thread Chris Stephens
003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: yapp_pack.zip google can't find yapp_pack.zip, where did you find it? On Wed, Feb 19, 2003 at 12:50:20PM -0800, Chris Stephens wrote: > List, > > I've recently run this EXTREMELY useful set of scripts fro

RE: yapp_pack.zip

2003-02-19 Thread Chris Stephens
al Message- From: Chris Stephens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Subject: yapp_pack.zip   List, I've recently run this EXTREMELY useful set of scripts from miracle A/S to chart various info from my statsp

yapp_pack.zip

2003-02-19 Thread Chris Stephens
dated these scripts to work against the 9.2 statspack tables. Thanks, Chris

apache and mod_plsql (was RE: Plain old database)

2003-02-14 Thread Sarnowski, Chris
utput from htp.p etc calls and presents the output back to the browser. This is an over-simplified overview. -Chris -Original Message- Sent: Friday, February 14, 2003 5:14 AM To: Multiple recipients of list ORACLE-L Hi Steve mod_plsql is pretty much a module that allows you to setup co

RE: Oracle 8i or 9i ?

2003-02-14 Thread Chris Stephens
sh#tless if I found a job where I pretended to be a dba and justified it by my certification only to be given actual dba responsibilities.  ...i'd rather work at a coffee shop and not have to deal with the stress (but that's just me) Anyways, I'm rambling now.   Chris Oh yeah.

RE: [Q] how to start "intelegent agent" on ORACLE 9.2 version?

2003-02-13 Thread Chris Stephens
Title: RE: [Q] how to start "intelegent agent" on ORACLE 9.2 version? Agentctl start  (from the command line...not in lsnrctl) -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Subject: [

info on toplink?

2003-02-05 Thread Sarnowski, Chris
the toplink forum from otn.oracle.com but the page is just hanging. thanks in advance for any pointers, -Chris LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is

session idle time

2003-01-31 Thread Sarnowski, Chris
ections are reused. thanks for any help, and sorry for the legal goop at the end. -Chris -- LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you ar

RE: Configuring back up in Oracle 9i

2003-01-25 Thread Chris Stephens
ine where your database is. chris -Original Message- From: Sony kristanto [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 8:34 PM To: Multiple recipients of list ORACLE-L Subject: Configuring back up in Oracle 9i Hi listers, Can anyone in this list explain to me, how to back up

RE: auto backup and spfile restore

2003-01-25 Thread Chris Stephens
Total System Global Area 320301720 bytes Fixed Size 735896 bytes Variable Size 285212672 bytes Database Buffers 33554432 bytes Redo Buffers 798720 bytes RMAN>   thank you for the response Robert.   chris  -Original Message-From: Robert Freeman [mailto:[EMAIL PROTECTED]]Sent: Frid

auto backup and spfile restore

2003-01-24 Thread Chris Stephens
Title: auto backup and spfile restore  List, We are in the process of testing every recovery scenario we can think of using rman.  We don't use a catalog and controlfile autobackup is on which implies the spfile is automatically backed up. So one of the scenarios was to delete the spfile an

RE: RE: Upgrade from 7.3.4 to 8.0.6

2003-01-23 Thread Bowes, Chris
.  Right now, I only have permission to convert 2 bases.  The other 6 have to stay on 7.3.4, because "SAP may do away with that system, so don't do any requests on it or spend any real time on it..." "They don't call this place the resume stain for nothing"  (Dilbert).

RE: Upgrade from 7.3.4 to 8.0.6 - Possible Solution - Comments?

2003-01-21 Thread Bowes, Chris
le, but, does anyone know when it gets used?  Is what I did to fix this acceptable?   Changing dictionary tables is a major red flag, so before I even think of trying to push for this solution, I want any and all thoughts on this.   Thanks again.   --Chris       -Original Message---

RE: question about rman

2003-01-21 Thread Chris Stephens
f the queue and it is ready to be written to tape. At least that's what happens with Legato.   Regards, Sujatha   -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 22 January 2003 7:05 AMTo: Multiple recipients of list

RE: question about rman

2003-01-21 Thread Chris Stephens
ROTECTED]] Sent: Tuesday, January 21, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: question about rman Chris - We use RMAN to back up to disk, then copy the files to tape. We found the MML piece VERY expensive.     The part I don't understand about your original note i

RE: question about rman

2003-01-21 Thread Chris Stephens
you can find on Amazon.com! -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 21, 2003 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: question about rman I could test this myself but that would require coordinatio

question about rman

2003-01-21 Thread Chris Stephens
er environment and RMAN can't find the necesary file(s) will it return a message asking where those files are?  ...at which point i would call the sys admins to restore the particular file.  or would i be hosed? thank you very much for any responses. (i plan on buying 9i rman soon but didn

RE: Upgrade from 7.3.4 to 8.0.6

2003-01-21 Thread Bowes, Chris
was offline or needed recovery, the base would be dead.   Any thoughts?   Thank you again,   --Chris   -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Upgrade

Upgrade from 7.3.4 to 8.0.6

2003-01-20 Thread Bowes, Chris
acle hasn't been able to find it.  Has anyone seen this and know the fix? Thanks in advance. --Chris [EMAIL PROTECTED]

RE: 100% CPU utilization, urgent

2003-01-20 Thread Chris Stephens
Title: 100% CPU utilization, urgent we had a problem with cpu usage and it ended up being the 'intelligent' agent.  ...after some consideration we decide there wasn't any reason we HAD to have the agent running so we just shut it down.   ...just a shot in the dark.   chris

RE: temp space

2003-01-20 Thread Chris Stephens
ients of list ORACLE-LSubject: RE: temp space Hi Chris,   The error ORA-1652 is because of the temporary tablespace for the corresponding table is not enough. The temporary tablespace for the table normally assigned when create the table. Or when create the user. If you're

RE: Positive comments

2003-01-19 Thread Chris Stephens
since 2001. GO RAIDERS!! chris -Original Message- From: M Rafiq [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 19, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Positive comments And CREDIT goes to Jared keeping this list alive for a long time. and We all must b

temp space

2003-01-17 Thread Chris Stephens
Title: temp space anyone know how to identify the session that caused a ORA-1652? -thank you

RE: RMAN backup - basic Qs

2003-01-16 Thread Chris Stephens
Title: RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 1:54 PM To

RE: one datafile lost.

2003-01-16 Thread Chris Stephens
absolutely. -Original Message-From: BigP [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: one datafile lost. Just wondering what will happen in this condition .   supposse I have two tablespaces data_

RE: Ideas for future authors

2003-01-16 Thread Chris Stephens
Title: RE: Ideas for future authors care to share that method?? :) -Original Message- From: Stephen Andert [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 9:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: Ideas for future authors I know I've really enjoyed

RE: Multiple block sizes in 9i

2003-01-16 Thread Chris Stephens
the 'same block size' restriction has been removed.   chris -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 7:14 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes in 9i List, Oracle 9i supported multiple b

Internet file system

2003-01-13 Thread Chris Stephens
Title: Internet file system as per usual, technet website is confusing as heck.  I am trying to locate the latest release on IFS.  I am on the products website and see the following on the IFS webpage: Content Management Software Development Kit (CMSDK) Version 9.0.3   (Note: this rele

RE: Some of you may find this useful

2003-01-10 Thread Chris Stephens
Title: RE: Some of you may find this useful what is it that i am looking at after running this query?? pardon the ignorance. chris -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 9:20 AM To: Multiple recipients of list ORACLE-L

Another myth goes by the wayside

2002-12-13 Thread Bowes, Chris
April fools day is just around the corner), slip a rogue tnsnames file out there on your fellow DBA's and see if he finds it...   Cheers! --Chris

RE: warehouse builder's dependance on oem job system.

2002-12-13 Thread Chris Stephens
tiple recipients of list ORACLE-L Subject: RE: warehouse builder's dependance on oem job system. Chris,   the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as set p_oper_mode [lindex $parList [incr parList_i]] set p_audit_level [lindex $parList [incr parLi

RE: Daily job to populate table in another database

2002-12-10 Thread Grabowy, Chris
: [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

RE: warehouse builder's dependance on oem job system.

2002-12-10 Thread Chris Stephens
ror, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer.  Thank you.   -Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 12:31 PMTo: Multiple rec

RE: warehouse builder's dependance on oem job system.

2002-12-10 Thread Chris Stephens
--Original Message-From: Chris Stephens [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 10, 2002 11:31 AMTo: Multiple recipients of list ORACLE-LSubject: warehouse builder's dependance on oem job system. ok, here's the situation:  we are loading our warehouse via etl pr

warehouse builder's dependance on oem job system.

2002-12-10 Thread Chris Stephens
Title: warehouse builder's dependance on oem job system. ok, here's the situation:  we are loading our warehouse via etl processes generated by warehouse builder (owb).  we went live with this a little over a week ago.  up to this point we have been running the jobs manually through owb.  for

NT Memory Leak 7.3.4

2002-11-27 Thread Bowes, Chris
vance. --Chris

RE: export in full mode but exclude particular user?

2002-11-21 Thread Chris Stephens
20, 2002 8:29 PM To: Multiple recipients of list ORACLE-L in the past there was a way described here on the list, TOTALLY UNSUPPORTED by tweaking one of the underlying views. joe Chris Stephens wrote: > i'm 99% sure that can't be done.  you'll have to explicitly name

RE: export in full mode but exclude particular user?

2002-11-20 Thread Chris Stephens
Title: RE: export in full mode but exclude particular user? i'm 99% sure that can't be done.  you'll have to explicitly name all the other users with owner=user_a,user_b,...  ...then you can do an import with full=y  ...or flip/flop by full=y on export and owner=.. on the import. ...first

OT: Getting data out of DB2...any DB2 DBAs out there?

2002-11-13 Thread Grabowy, Chris
ample jobs that they would be willing to share? Many thanks!! Chris

RE: Solaris vs Windows 2000

2002-11-13 Thread Grabowy, Chris
CTED] 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: [EMAI

RE: PIC 9(9)V99 ??

2002-11-13 Thread Grabowy, Chris
And then two digits after the decimal point? And the actual data would have a decimal point? So in this case, for a total of 12 characters? 123456789.99 ? TIA!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Netwo

OT: PIC 9(9)V99 ??

2002-11-12 Thread Grabowy, Chris
tual data would have a decimal point? So in this case, for a total of 12 characters? 123456789.99 ? TIA!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

Help: ORA-980 raised if a PLSQL block references a remote public synonym

2002-11-06 Thread Borrill, Chris
offer a solution to this problem? Thankyou, Chris

Adhoc queries and limiting the amount of records queried...

2002-10-29 Thread Grabowy, Chris
Title: Adhoc queries and limiting the amount of records queried... I just wanted to ping the list to see what other people have done to control or constrain adhoc query users??? We have a group that is struggling with the adhoc query piece that's in production.  Some of the users end up fir

RE: Flat file generation integrity ideas...

2002-10-29 Thread Grabowy, Chris
2002 > 06:14 > Please respond > to ORACLE-L > > > > > > > I do not see how the file can get "scrambled". > You write it out ok. > The ftp is guaranteed. > So what is the problem. > > I wi

RE: Flat file generation integrity ideas...

2002-10-26 Thread Grabowy, Chris
ks. CG -Original Message- From: Jared Still [mailto:jkstill@;cybcon.com] Sent: Sat 10/26/2002 10:45 PM To: [EMAIL PROTECTED]; Tim Gorman; Grabowy, Chris Cc: Subject: Re: Flat file generation integ

RE: Flat file generation integrity ideas...

2002-10-25 Thread Grabowy, Chris
Title: Message Tim, I can always count on you for a slick answer.  Thanks.  I will have to check into that. -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 6:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Flat fil

RE: Flat file generation integrity ideas...

2002-10-25 Thread Grabowy, Chris
Yes, which is the ideal solution, but the other systems aren't ready for XML. Anytime we have a really good solution it's "defered to the next phase". -Original Message- Sent: Thursday, October 24, 2002 6:33 PM To: Multiple recipients of list ORACLE-L Chris - Yo

RE: Flat file generation integrity ideas...

2002-10-24 Thread Grabowy, Chris
uot;. You write it out ok. The ftp is guaranteed. So what is the problem.   I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection.   Yechiel AdarMehish - Original Message - From: Grabowy, Chris To:

Flat file generation integrity ideas...

2002-10-24 Thread Grabowy, Chris
Title: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record

RE: Flat file generation integrity ideas...

2002-10-24 Thread Grabowy, Chris
-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Flat file generation integrity ideas... Chris,   have you thought about summing a number column in the record and placing this sum

RE: Flat file generation integrity ideas...

2002-10-24 Thread Grabowy, Chris
I will have to keep those in mind, if I ever get back onto a UNIX platform. Right now, I'm sticking to Tom's suggestion because I religiously follow KISS. Thanks!! -Original Message- Sent: Thursday, October 24, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Chris

RE: Flat file generation integrity ideas...

2002-10-24 Thread Grabowy, Chris
Title: Message Yes, Melissa also mentioned this to me.  I will have to look into that function...along with the million other procedures and functions that Oracle has.  At this point, Tom's suggestion seems to be the simpliest/effective/fastest.  Any other suggestions? -Original Me

RE: How to zip a file on From Unix shell script

2002-10-17 Thread Grabowy, Chris
Title: Message Dude, you are nailing the jokes left and right, either your having a really bad day or a really good one... -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 2:55 PMTo: Multiple recipients of list ORACLE-LSubje

RE: ORA-01031: insufficient privileges

2002-10-17 Thread Grabowy, Chris
- JNJDSS_STG_T What the heck??? (shaking my head) What am I missing here?? Help? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatci

RE: ORA-01031: insufficient privileges

2002-10-17 Thread Grabowy, Chris
GRANTED VARCHAR2(3) -Original Message- Sent: Thursday, October 17, 2002 1:15 PM To: Grabowy, Chris; [EMAIL PROTECTED] Chris, According to the docs: Prerequisites To grant a system privilege, you must either have been granted the system privilege with the ADMIN OPTION or have been gra

RE: ORA-01031: insufficient privileges

2002-10-17 Thread Grabowy, Chris
inal Message- Sent: Thursday, October 17, 2002 12:55 PM To: '[EMAIL PROTECTED]' Cc: Grabowy, Chris Chris, Does the OPS$JNJDBA account have DBA privs? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 17, 2002 1:28 PM To: Multiple

ORA-01031: insufficient privileges

2002-10-17 Thread Grabowy, Chris
sername = 'JNJDSS_STG_T'; USERNAME -- JNJDSS_STG_T What the heck??? (shaking my head) What am I missing here?? Help? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Servi

<    1   2   3   4   5   6   7   >