RE: Perl code example

[Hatzistavrou Giannis]

A good solution might be to read the eviromental parameters of the UNIX
session. In there you can set the SID and username/password.

>From within the Perl code then do:

$data_source="dbi:Oracle:" . $ENV{};
$dbbscs = DBI->connect($data_source,$ENV{},$ENV{);
$sqlstmt_tmcode = "select ... from ...";
$stmt_tmcode = $dbbscs->prepare($sqlstmt_tmcode) || die "Couldn't prepare
the tmcode statement!\n";
$stmt_tmcode->execute || die "Couldn't execute the tmcode statement!\n";

Regards,

Hatzistavrou Yannis

> -Original Message-
> From: Hagedorn, Linda [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, September 18, 2001 01:00
> To:   Multiple recipients of list ORACLE-L
> Subject:  Perl code example
> 
> Hello, 
> 
> I'm looking for a Perl example passing parameters.  
> 
> The code below has the userids and passwords hardcoded in clear text in
> the system line, parms 3 and 5 (five lines from the bottom), and the
> Oracle sid is hardcoded also.  The code has to be changed to 1) read .pwd1
> and .pwd2 files containing the passwords, and set a literal for the SID
> and substitute it at in the code.  
> 
> I'm not a Perl coder, and would appreciate any information, hints, or
> links to the manual.  
> 
> Thanks, Linda 
> 
> 
> 
> #!/usr/local/bin/perl 
> # 
> use CGI qw(:standard); 
> # 
> $| = 1; 
> ($sec,$min,$hour,$mday,$mmonth,$myear,$wday,$yday,$isdst) =
> localtime(time); 
> if ($myear < 99) { 
> $myear++; 
> } 
> $myear += 1900; 
> $mmonth += 1; 
> print header; 
> if (!param()) { 
> print start_html('dev02 QRX4 DB Refresh'), 
> h1('dev02 QRX4 DB Refresh for Formulary qRx Version 4.0'),
> 
> hr, 
> "", 
> "Enter a date to start the Oracle database refresh script,", 
> "then hit Submit to kick off the refresh for that
> date.", 
> start_form, 
> "Enter the target refresh date: ", 
> textfield('day',$mday,2), 
> textfield('month',$mmonth,2), 
> textfield('year',$myear,4), 
> p, submit('Submit'), 
> end_form, 
> hr; 
> } else { 
> #print "You entered :"; 
> $dy = param('day'); 
> $mo  = param('month'); 
> $yr  = param('year'); 
> print "You are transferring all data modified on or after ", $dy, "-",
> $mo,"-", $yr, " to update"; 
>print  "\n"; 
>  print "QRX4: Starting script with
> /opt/oracle/scripts/staging/cerebellum/refresh.sh  $dy-$mo-$yr\n"; 
> print "  2.pl>>Return to previous page",hr;
> 
> print ""; 
> system "/opt/oracle/scripts/staging/refresh.sh gui4 pwd1 qrx4 pwd2
> $dy-$mo-$yr dev02"; 
> print ""; 
> print "  2.pl>>Return to previous page",hr;
> 
> print end_html; 
> } 
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hatzistavrou Giannis
  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: Subtract 1 month from current date

[Hatzistavrou Giannis]

select ADD_MONTHS(trunc(),-1)
from dual;
> -Original Message-
> From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 17:40
> To:   Multiple recipients of list ORACLE-L
> Subject:  Subtract 1 month from current date
> 
> Can someone tell me how to subtract 1 month from the current date?  Also,
> where can I find answers and examples to this type of coding question?
> 
> Thanks!
> Ron Smith
> Database Administrator
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   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: Hatzistavrou Giannis
  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: Way off topic - Volunteering

[VIVEK_SHARMA]

Also Enlisted as volunteer 

Being Physically in INDIA , may NOT be of much help  


> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 10:40 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Way off topic - Volunteering
> 
> 
> Kevin,
>  I received following information from a different listserv and
> hope it
> helps:
> For information on how to offer IT assistance or support to businesses
> in
> New York's World Trade Center, please visit our Web site at
> www.computerworld.com  , where you can
> register to help through our IT Volunteers database (click on the red
> Volunteer IT banner). If your services are needed by businesses
> affected by
> Tuesday's attack, you will be contacted.
> 
> Jessie
> 
> 
>  
> 
> Kevin Bachelder
> 
>  recipients of list ORACLE-L 
> pring.com>   <[EMAIL PROTECTED]>
> 
> Sent by: cc:
> 
> [EMAIL PROTECTED] Subject: Way off
> topic - Volunteering
>  
> 
>  
> 
> 09/17/2001 07:10
> 
> AM
> 
> Please respond to
> 
> ORACLE-L
> 
>  
> 
>  
> 
> 
> 
> 
> 
> Hi everyone,
> 
> I am looking to find a way to volunteer my time to assist non-profits
> or
> similar organizations that need technical assistance or maybe be a
> technical tutor or resource at a community center, etc.  I knows this
> sounds crazy but my early attempts to find these opportunities near my
> local community have come up empty.  Does anyone have any suggestions
> on
> how they have gone about this or similar things.
> 
> Take care,
> 
> Kevin
> 
> --
> Kevin Bachelder
> 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
  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).

ORA-00600

[Sirisha]

Hi
I get this error ORA-00600 when i try to execute a stored procedure.

The stored procedure gets compiled perfectly but gives this error at
run-time while executing it from a java code. This is what i found in
the alert log.

Tue Sep 18 04:57:14 2001
Errors in file
/usr/local/oracle/8i/u01/app/oracle/admin/HHME1/udump/ora_2825.trc:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [6529], [6707],
[1049600], [1], [], [], []

Can someone tell me how to deal with this problem,

Thanx,
Sirisha.


*
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*
Visit us at http://www.mahindrabt.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sirisha
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9i D/l

[Molina, Gerardo]

I think you just have to keep trying.  Maybe at different times.  I
experienced the same as you but with the 9i for Linux download.

HTH
Gerardo

-Original Message-
Sent: Monday, September 17, 2001 11:15 PM
To: Multiple recipients of list ORACLE-L


Hi List

Have any of you been successful in d/lng 9i for NT from technet ?? I am
getting Server not found.  Is there any other mirror fromwhich I can d/l ??

TIA

Srini

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VeniVas
  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: Molina, Gerardo
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

9i D/l

[VeniVas]

Hi List

Have any of you been successful in d/lng 9i for NT from technet ?? I am
getting Server not found.  Is there any other mirror fromwhich I can d/l ??

TIA

Srini

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VeniVas
  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: truncating snapshots

[Mario Alberto Ramos Arellano]

Henry,
I think what you're talking about is Basic Replication.
What's the purpose of truncating the snapshot between refreshes though?

Salu2

Mario Alberto Ramos

>>> [EMAIL PROTECTED] 16/09/01 09:40 >>>
Henry,

I'm not sure what you're trying to accomplish by
truncating the snapshot.  The whole point of the
refresh process is to keep the snapshot in sync with
the master site.

Presumably you are doing a CTAS off of the snapshot to
do your manipulations, so what is the point in
truncating the snapshot?  I don't have a db handy to
test whether Oracle detects that the snapshot has been
truncated and does a complete refresh, but if the
snapshot is very large it would probably be faster to
drop and recreate it than to do a complete refresh.

A more detailed explanation of the process would help.

HTH,

-- Anita

--- Henry Poras <[EMAIL PROTECTED]> wrote:
> !! Please do not post Off Topic to this List !!
> 
> I need to move the changes in a table from one
> database to another. It
> seemed that fast snapshots would be a good way to do
> this as the database
> will automatically keep track of the changes for me.
> The question is that
> once I move the data to the snapshot side, I need to
> manipulate it, move it
> into another table, and start the cycle again. This
> means truncating the
> snapshot between refreshes. I tried this on a test
> system and it seesm to
> work, but I don't think Oracle supports it. I don't
> want updatable snapshots
> as this is strictly one way movement of data. Has
> anyone else tried this?
> Are there any potential problems? I think I am just
> truncating a table
> underlying the snapshot view so I don't see what
> could go wrong.
> 
> Thanks.
> 
> Henry
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com 
> -- 
> Author: Henry Poras
>   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).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/ 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mario Alberto Ramos Arellano
  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: WinNT / Oracle 8.0.5 / Problem with mapped drive

[George Hofilena]

List,

I've got it all figured out.  I restarted all Oracle services under a domain
account and added the UNC path to the UTL_FILE_DIR parameter.

George

-Original Message-
Sent: Monday, September 17, 2001 4:15 PM
To: Multiple recipients of list ORACLE-L


List,

One of our web developers wants to extract a text file from Oracle and put
it directly into a mapped drive that points to another NT server which acts
as our web server.  He's using a trigger to do this.  I thought we could map
one of the web server's drive on the database server, have Oracle see it
through the UTIL_DIR parameter and the problem should be solved.  Well,
partly.  This will only work if the OS account that was used to create the
mapped drive is currrently logged into the database server.  Onec the
account/user is logged offOtherwise, it doesn't.

We considered calling a NET USE command from within the PL/SQL program but
it doesn't look as simple as we thought it should be.  Is there a different
solution to this problem or a better way than using the external procedure
approach?

Thanks,

George
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Hofilena
  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: George Hofilena
  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: Copy Oracle's binary.

[Deshpande, Kirti]

This becomes a bit easier when ORACLE_BASE is set to ORACLE_HOME before
installing the Oracle 8i software. This way, one can sepatate the
oraInventory directory related to a particular version of 8i/9i. I also like
to keep the OUI directory within the particular ORACLE_HOME. I have
installed 8.1.6/8.1.7/9.0.1 on a couple of servers using this method. I have
not had any problems copying the entire ORACLE_HOME (8.1.7) to another
binary compatible server. In addition, copying the
/var/opt/oracle/oraInst.loc file that has the directory name for the
oraInventory location is helpful. When applying any patches to a particular
verion of 8i, simply modify this name in the oraInst.loc file to point to
the correct oraInventory directory. This  will keep all versions of 8i/9i
clean. 

Refer to Note:134076.1 on Metalink for more information...

HTH,

Regards,

- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com

> -Original Message-
> From: Charlie Mengler [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 8:45 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: Copy Oracle's binary.
> 
> As long as everything is identical between the source system & the target
> system, 
> you can probably get away with using tar or similar utility. 
> 
> HOWEVER if the source system has only V8.1.7 installed while the target
> system 
> already has only V8.1.5 on it, I suspect that you'll struggle with simply
> copying 
> V8.1.7 onto the target system & being able to upgrade both V8.1.5 & V8.1.7
> 
> in the future. This is regardless of how similar the "paths" may be or how
> much 
> space exists on the volumes on the target system. 
> 
> Since 8i, OUI is rather painless to use & all it takes is a few hours to
> allow 
> it to create a SUPPORTED installation; I have allowed OUI to do its thing,
> 
> while I tend to other tasks in other windows. 
> 
> "Hagedorn, Linda" wrote: 
> 
>   Copying the software is not supported under 8i. The oraInventory and
> the ORACLE_HOME are hardcoded in the inventory.  As long as these paths
> are identical on both systems, the copy should be ok.  If the paths are
> different on the two machines, you will be able to run the database on
> that machine, but you will not be able to apply patches because
> theORACLE_HOME and inventory locations point to the original machine,
> where the bins originated.  -Original Message- 
>   From: Kimberly Smith [ ] 
>   Sent: Monday, September 17, 2001 4:25 PM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: RE: Copy Oracle's binary. 
> 
> 
>   Have you upgraded those databases?  Its no longer possible
> to justcopy ORACLE_HOME and expect to be able to upgrade it.  That
> beingsaid, I never did bother to identify the other directories as I
> feltit was just as easy to install the software. You could do a full
> system copy though.  
> 
>   -Original Message- 
>   From: Feng, Jun [ ] 
>   Sent: Monday, September 17, 2001 3:50 PM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: RE: Copy Oracle's binary. 
>
>   Sure. We have done that many times.Jun 
> 
>   -Original Message- 
>   From: Thanh-truc Nguyen [ ] 
>   Sent: Monday, September 17, 2001 6:31 PM 
>   To: Multiple recipients of list ORACLE-L 
>   Subject: Copy Oracle's binary. 
>
>   Hello, I've two machines (with the same unix's
> configuration on Sun Solaris). On has Oracle 8.1.7. installed and a
> database. Do you think it's possible to copy Oracle's binary and the
> database on Unix level to the new serveur instead of installing and
> cloning the db ? Thank you very much. Thanh-truc Nguyen
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  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: Alternatives to roles in procedures?

[Rachel Carmichael]

um, create the procedures in schema A and grant execute to schema B?  
removes the need for direct grants on the tables.


>From: "Jesse, Rich" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Alternatives to roles in procedures?
>Date: Mon, 17 Sep 2001 12:30:24 -0800
>
>So, there we are, in 8.1.7 on HP/UX 11.0.  We have several dozen tables in
>schema "A" that need to be accessed from procedures in schema "B".  We had
>previously been using a role to grant access to these tables but now with
>the procedures, this ain't an option.
>
>Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc
>on each table to schema "B"?
>
>TIA,
>Rich Jesse  System/Database Administrator
>[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Looking for 24 X 7 Design Considerations

[Rachel Carmichael]

Joe, you really have to learn how to let your feelings out and tell us what 
you really think :)

Okay, teasing aside, I agree... I dislike putting critical production 
systems on a brand-new release of ANYTHING!  9i is too rough around th edges 
as yet, I figure we'll move there in a year at the earliest.

Rachel


>From: "JOE TESTA" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Looking for 24 X 7 Design Considerations
>Date: Mon, 17 Sep 2001 12:40:18 -0800
>
>Anyone contemplating upgrading anything more important than a sandbox 
>database to 9i is nutso.
>
>9i is ready for development playing around in 6-8 months, production no 
>earlier than 12-18 months is my estimation.
>
>joe
>
>
> >>> [EMAIL PROTECTED] 09/17/01 03:25PM >>>
>Tracy - Is there any possibility of upgrading these databases to Oracle8i,
>or even better 9i before you implement 24X7? Oracle is claiming new 
>features
>in 9i will support 24X7. I would also imagine that if you could bring all
>databases up to the same level, it would be easier to establish policies.
>For 7.3.4, you might need to do something entirely different. Also there is
>a book "Oracle 24x7 Tips and Techniques" by Venkat S. Devraj, but the
>publishing date was 1999, so the information may be dated.
>
>Dennis Williams
>DBA
>Lifetouch, Inc.
>[EMAIL PROTECTED]
>
>
>-Original Message-
>Sent: Monday, September 17, 2001 10:15 AM
>To: Multiple recipients of list ORACLE-L
>
>
>We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that 
>do
>not have a  24x7 restriction.  Now, management is looking to bring in new
>products that will need to be 24X7.  They are looking for costs to 
>determine
>the viability of such a decision.  I have no 24x7 experience and am looking
>for
>ideas or options to consider.  [At least initially they are stating there
>can
>be no downtime for maintenance (upgrades/reorgs)]
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Tracy Rahmlow
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Copy Oracle's binary.

[Charlie Mengler]

As long as everything is identical between the source system & the
target system,
you can probably get away with using tar or similar utility.
HOWEVER if the source system has only V8.1.7 installed while the target
system
already has only V8.1.5 on it, I suspect that you'll struggle with
simply copying
V8.1.7 onto the target system & being able to upgrade both V8.1.5
& V8.1.7
in the future. This is regardless of how similar the "paths" may be
or how much
space exists on the volumes on the target system.
Since 8i, OUI is rather painless to use & all it takes is a few
hours to allow
it to create a SUPPORTED installation; I have allowed OUI to do its
thing,
while I tend to other tasks in other windows.
"Hagedorn, Linda" wrote:

Copying
the software is not supported under 8i. The
oraInventory and the ORACLE_HOME are hardcoded in the inventory. 
As long as these paths are identical
on both systems, the copy should be ok.  If the paths are different
on the two machines, you will be
able to run the database on that
machine, but you will not be able to apply patches because theORACLE_HOME and
inventory locations point to the original machine, where the bins originated. 
-Original Message-
From: Kimberly Smith
[mailto:[EMAIL PROTECTED]]
Sent: Monday, September
17, 2001 4:25 PM
To: Multiple recipients
of list ORACLE-L
Subject: RE: Copy
Oracle's binary.
 
Have
you upgraded those databases?  Its no longer possible to justcopy
ORACLE_HOME and expect to be able to upgrade it.  That beingsaid,
I never did bother to identify the other directories as I feltit
was just as easy to install the software. You
could do a full system copy though. 

-Original
Message-
From: Feng, Jun [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17,
2001 3:50 PM
To: Multiple recipients of
list ORACLE-L
Subject: RE: Copy Oracle's
binary.
 
Sure.
We have done that many times.Jun

-Original
Message-
From: Thanh-truc Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17,
2001 6:31 PM
To: Multiple recipients of
list ORACLE-L
Subject: Copy Oracle's binary.
 
Hello, I've two machines
(with the same unix's configuration on Sun Solaris). On has Oracle 8.1.7.
installed and a database. Do you think it's possible to copy Oracle's binary
and the database on Unix level to the new serveur instead of installing
and cloning the db ? Thank you very much. Thanh-truc
Nguyen

RE: Looking for 24 X 7 Design Considerations

[satar naghshineh]

I'm pretty much in the same boat. All my global
databases are doing well. There are virtually no
database issues. People wonder why the company pays me
so much money for doing nothing. 

However, I still get those calls at odd hours of the
day/night (because of the time differences) from
system administrators that think something is wrong
with Oracle. Also, management loves to implement
software upgrades/patches during the Holidays or
weekends. 

I'm just glad that I live in California, where a
recent law (Assembly Bill 60)forces my employer to pay
me by the hour. Overtime and off hour phone calls are
my new best friends!

Regards,
Satar

Please understand that the Muslim faith does not
advocate violence. The animals who targeted America
are not TRUE believers of the faith and acted on EVIL,
instead of the teachings of the Koran. Please do not
displace your anger on innocent Muslims living in your
local area.

--- Kimberly Smith <[EMAIL PROTECTED]>
wrote:
> Now I must disagree with this.  Although I am on 
> call every annoying day of the year it is so rare
> that I have database issues its not even funny.
> I think nothing of leaving for the weekend.  At the
> very least I can talk someone though something, even
> if I am at the top of a mountain.  Calls have
> to wait while I am on the wall at Smith Rock though 
> (or my climbing partner is on the wall).
> 
> 
> 5. Kiss your weekends and Holidays good bye!
> 
> 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  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: Copy Oracle's binary.

[Charlie Mengler]

While it is possible to copy /mnt_point/app/oracle tree to a different
host
and still get oracle to run, you might be in for a RUDE surprise in the
future.

After I copied an 8.1.6 tree onto a test system earlier this year,
Oracle
refused to allow it to be upgraded to V8.1.7 because the "inventory"
directory did NOT contain any knowledge of the 8.1.6 installation.

I am NOT saying that you can't work around such problems,
I'm just warning that it has the potential for future additional work.

HTH & YMMV!

"Feng, Jun" wrote:

> Sure. We have done that many times.Jun
>
>  -Original Message-
>  From: Thanh-truc Nguyen [mailto:[EMAIL PROTECTED]]
>  Sent: Monday, September 17, 2001 6:31 PM
>  To: Multiple recipients of list ORACLE-L
>  Subject: Copy Oracle's binary.
>
>  Hello, I've two machines (with the same unix's configuration
>  on Sun Solaris). On has Oracle 8.1.7. installed and a
>  database. Do you think it's possible to copy Oracle's binary
>  and the database on Unix level to the new serveur instead of
>  installing and cloning the db ? Thank you very
>  much. Thanh-truc Nguyen
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: Looking for 24 X 7 Design Considerations

[Charlie Mengler]

Just so folks do NOT get the wrong idea, let me clarify.
Please note I said "a production" database. It is not "THE
Production Database"; which is still firmly planted in V7.3.4.5.
I've taken a few limited activity tablespaces up to 9i to
take advantage of 8i features; such as partitioning. I, too
would be hesitant to move into Production code that
makes use of 9i Bleeding Edge features. However I am
perfectly comfortable with moving V7 code onto a
tested 9i DB. Since our tests showed a stable DB,
I moved directly to 9i to avoid doing multiple upgrades
over the next 6 - 12 months.

As always, YMMV, so please be sure to test until you
are comfortable with 9i's stability for your situation. If
your tests with 9i fail, then obviously 9i is not for you.
If exhaustive tests show NO problems with 9i, then
I see no reason to avoid using it; even if it is considered
a DOT-ZERO release. If you upgrade without exhaustive
testing, then I hope I don't own any stock in your company.

Paul Baumgartel wrote:

> I agree with you, Charlie.  The fact that an Oracle release is
> relatively new doesn't mean it's riddled with bugs (although that was
> once the case); neither does the fact that it's been out for 12 months
> or so mean that there aren't any show-stoppers lurking within.
>
> I've made the case before that 9i should be considered more as if it
> were 8.2.  Yes, it's new, and yes, you should test and verify
> carefully, but it's not as large a leap as going from Oracle7 to
> Oracle8, for example.
>
> Paul Baumgartel
>
> --- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> > I guess then I'm "nutso", because I have a 9i DB in production.
> > Any independently verifiable substantiation for your claim would be
> > welcomed.
> > This 9i instance has had flawless performance for the last two
> > months;
> > which
> > is how long it has been in production.
> >
> >  Original Message 
> >  Subject: RE: Looking for 24 X 7 Design Considerations
> > Date: Mon, 17 Sep 2001 12:40:18 -0800
> > From: "JOE TESTA" <[EMAIL PROTECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > Organization: Fat City Network Services, San Diego, California
> >   To: Multiple recipients of list ORACLE-L
> >   <[EMAIL PROTECTED]>
> >
> >  Anyone contemplating upgrading anything more important than a
> > sandbox
> > database to 9i is nutso. 9i is ready for development playing around
> > in
> > 6-8 months, production no earlier than 12-18 months is my
> > estimation. joe
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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).

DB Names in multiple oracle installs

[Sujatha Madan]

Hi,
 
Is it 
possible to call two databases the same name if they are residing on the same 
machine, in different oracle homes? ... One database is version 8.0.6 and the 
other is 8.1.7.
 
Thanks
 
Sujatha

Re: Looking for 24 X 7 Design Considerations

[Joe Testa]

Sure i've hit the undo management bug that wiped out my SAND box
database just last week, db got hung up, had to shutdown abort and then
redo logs/undo management tablespace couldnt be mounted so it was
screwed.

Sorry but I've been an oracle dba since version 5 almost 10 years ago
and my personal opinion is i'd never put a x.0 version of oracle in
production mode before its been out for 12 months.

joe
Paul Baumgartel wrote:
> 
> I agree with you, Charlie.  The fact that an Oracle release is
> relatively new doesn't mean it's riddled with bugs (although that was
> once the case); neither does the fact that it's been out for 12 months
> or so mean that there aren't any show-stoppers lurking within.
> 
> I've made the case before that 9i should be considered more as if it
> were 8.2.  Yes, it's new, and yes, you should test and verify
> carefully, but it's not as large a leap as going from Oracle7 to
> Oracle8, for example.
> 
> Paul Baumgartel
> 
> --- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> > I guess then I'm "nutso", because I have a 9i DB in production.
> > Any independently verifiable substantiation for your claim would be
> > welcomed.
> > This 9i instance has had flawless performance for the last two
> > months;
> > which
> > is how long it has been in production.
> >
> >  Original Message 
> >  Subject: RE: Looking for 24 X 7 Design Considerations
> > Date: Mon, 17 Sep 2001 12:40:18 -0800
> > From: "JOE TESTA" <[EMAIL PROTECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > Organization: Fat City Network Services, San Diego, California
> >   To: Multiple recipients of list ORACLE-L
> >   <[EMAIL PROTECTED]>
> >
> >  Anyone contemplating upgrading anything more important than a
> > sandbox
> > database to 9i is nutso. 9i is ready for development playing around
> > in
> > 6-8 months, production no earlier than 12-18 months is my
> > estimation. joe
> >
> 
> __
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Information/

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
IM: n8xcthome or joen8xct
-- 
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).

BLOB field in group by

[Mark Liggayu]

I have to include a blob type field in a group by statement.  Is there a way
around it?  Please find select statement below.  The blob type field is
FND_LOBS.FILE_DATA.

I appreciate all the help I can have.

Thanks,
Mark



SELECT
--  :c_q2_delivery_id c_q3_delivery_id
--, :c_q2_print_all c_q3_print_all
 &p_item_flex c_item_flex
,det.inventory_item_id c_inv_item_id
, nvl(det.item_description,msi.description) c_item_description
, det.customer_item_id c_customer_item_id
, det.source_header_number c_so_number
,det.source_line_number c_so_line_number
, det.cust_po_number c_po_number
, sum ( round(nvl(det.requested_quantity,0),:p_quantity_precision))
c_req_qty
, det.requested_quantity_uom c_req_qty_uom
, det.requested_quantity_uom2 c_req_qty_uom2
, det.src_requested_quantity_uom c_src_req_uom
, det.src_requested_quantity_uom2 c_src_req_uom2
 -- src_requested_quantity remains the same for delivery details from the
same source_line_id
--  so we take the avg. For other columns take the sum.
,avg( round(nvl(det.src_requested_quantity,0),:p_quantity_precision) )c_src_
req_qty
,avg( round(nvl(det.src_requested_quantity2,0),:p_quantity_precision) )
c_src_req_qty2
, sum(round(nvl(det.shipped_quantity,0),:p_quantity_precision) ) c_ship_qty
,sum( round(nvl(det.shipped_quantity2,0),:p_quantity_precision)) c_ship_qty2
,sum( round(nvl(det.delivered_quantity,0),:p_quantity_precision) ) c_del_qty
,sum( round(nvl(det.src_requested_quantity,0)-nvl(det.shipped_quantity,0)-nv
l(det.requested_quantity,0),:p_quantity_precision) )c_back_qty -- this
column no longer being used as it is wrong.
,
sum(round(nvl(det.src_requested_quantity2,0)-nvl(det.shipped_quantity2,0)-nv
l(det.requested_quantity2,0),:p_quantity_precision) )c_back_qty2 -- this
column should also be ot used ,
, det.customer_id c_customer_id
, det.source_code c_src_code
, det.source_header_id c_src_hdr_id
, det.source_line_id c_src_line_id
, det.lot_number  c_lot_number
, det.sublot_number c_sublot_number
, det.preferred_grade c_preferred_grade
, det.shipping_instructions c_ship_instructions
,FND_LOBS.FILE_DATA
,FND_DOCUMENTS_TL.MEDIA_ID
,OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF
, det.packing_instructions c_pack_instructions
FROM
  wsh_delivery_details det
, wsh_delivery_assignments das
,OE_ORDER_LINES_ALL
,FND_ATTACHED_DOCUMENTS
,FND_DOCUMENTS_TL
,FND_LOBS
, mtl_system_items msi
WHERE det.delivery_detail_id=das.delivery_detail_id
  AND det.container_flag='N'
--AD nvl(det.released_status, 'N') in ('Y', 'C', 'X')
  AND das.delivery_id=:c_q2_delivery_id
  AND msi.organization_id(+)=:p_organization_id
  AND msi.inventory_item_id(+)=det.inventory_item_id
AND FND_LOBS.FILE_ID=FND_DOCUMENTS_TL.MEDIA_ID
  AND FND_DOCUMENTS_TL.DOCUMENT_ID=FND_ATTACHED_DOCUMENTS.DOCUMENT_ID
  AND FND_ATTACHED_DOCUMENTS.PK1_VALUE=OE_ORDER_LINES_ALL.LINE_ID
  AND OE_ORDER_LINES_ALL.LINE_ID=det.SOURCE_LINE_ID
group by
 &p_item_flex
,det.inventory_item_id
, nvl(det.item_description,msi.description)
, det.customer_item_id
, det.source_header_number
,det.source_line_number
, det.cust_po_number
, det.requested_quantity_uom
, det.requested_quantity_uom2
, det.src_requested_quantity_uom
, det.src_requested_quantity_uom2
, det.customer_id
, det.source_code
, det.source_header_id
, det.source_line_id
,FND_DOCUMENTS_TL.MEDIA_ID
,OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF
, det.lot_number
, det.sublot_number
, det.preferred_grade
, det.shipping_instructions
, det.packing_instructions
ORDER BY &p_order_by

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Liggayu
  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: Copy Oracle's binary.

[Hagedorn, Linda]

Copying 
the software is not supported under 8i.  
 
The 
oraInventory and the ORACLE_HOME are hardcoded in the inventory.  As long 
as these paths are 
identical on both systems, the copy should be ok.  If the paths are 
different on the two machines, you will 
be able 
to run the database on that machine, but you will not be able to 
apply patches because the
ORACLE_HOME and inventory locations point to the original 
machine, where the bins originated.  
  
 
 -Original 
Message-From: Kimberly Smith 
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 
2001 4:25 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Copy Oracle's binary.

  Have 
  you upgraded those databases?  Its no longer possible to 
  just
  copy 
  ORACLE_HOME and expect to be able to upgrade it.  That 
  being
  said, I never did bother to identify the other 
  directories as I felt
  it 
  was just as easy to install the software.  
   
  You 
  could do a full system copy though.  
  
-Original Message-From: Feng, Jun 
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 3:50 
PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
Copy Oracle's binary.
Sure. We have done that many 
times.
 
Jun

  -Original Message-From: Thanh-truc Nguyen 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 6:31 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Copy Oracle's binary.
  Hello,
   
  I've two machines (with the same unix's 
  configuration on Sun Solaris). On has Oracle 8.1.7. installed and a 
  database. Do you think it's possible to copy Oracle's binary and the 
  database on Unix level to the new serveur instead of installing and 
  cloning the db ?
   
  Thank you very much.
   
  Thanh-truc Nguyen  
  

RE: Looking for 24 X 7 Design Considerations

[Paul Baumgartel]

I agree with you, Charlie.  The fact that an Oracle release is
relatively new doesn't mean it's riddled with bugs (although that was
once the case); neither does the fact that it's been out for 12 months
or so mean that there aren't any show-stoppers lurking within.

I've made the case before that 9i should be considered more as if it
were 8.2.  Yes, it's new, and yes, you should test and verify
carefully, but it's not as large a leap as going from Oracle7 to
Oracle8, for example.

Paul Baumgartel

--- Charlie Mengler <[EMAIL PROTECTED]> wrote:
> I guess then I'm "nutso", because I have a 9i DB in production.
> Any independently verifiable substantiation for your claim would be
> welcomed.
> This 9i instance has had flawless performance for the last two
> months;
> which
> is how long it has been in production.
> 
>  Original Message 
>  Subject: RE: Looking for 24 X 7 Design Considerations
> Date: Mon, 17 Sep 2001 12:40:18 -0800
> From: "JOE TESTA" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Organization: Fat City Network Services, San Diego, California
>   To: Multiple recipients of list ORACLE-L
>   <[EMAIL PROTECTED]>
> 
>  Anyone contemplating upgrading anything more important than a
> sandbox
> database to 9i is nutso. 9i is ready for development playing around
> in
> 6-8 months, production no earlier than 12-18 months is my
> estimation. joe
> 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: Renaming GLOBAL_NAME

[ARUN K C]

Have u added the db_domain in the init parameter that should change the 
domain u want.
I am not sure about this but I have a feeling this should work.
And one of the person said the WORLD is the default.


>From: Paul Baumgartel <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Renaming GLOBAL_NAME
>Date: Mon, 17 Sep 2001 10:05:19 -0800
>
>I don't think you can do this.  GLOBAL_NAME by definition consists of
>the database name and database domain, which defaults to WORLD.
>
>Paul Baumgartel
>
>--- [EMAIL PROTECTED] wrote:
> >
> > Hi All,
> >
> > I am trying to rename the global_name from SIMSNT7B.WORLD to
> > SIMSNT7B.
> >
> > I issued the following command to change the global_name.
> >
> > ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;
> >
> > Still it is showing SIMSNT7B.WORLD when I query the global_name view.
> > SQL> select * from global_name;
> >
> > GLOBAL_NAME
> > --
> > SIMSNT7B.WORLD
> >
> > Values for the following parameters in v$parameter view,
> > GLOBAL_NAMES  parameter value is FALSE and DB_DOMAIN parameter value
> > is
> > NULL.
> > We are not using Oracle Names server.  I renamed SQLNET.ORA file in
> > network\admin location.
> > Init.ora file has global_names set to false.
> >
> > How do I change to SIMSNT7B?  This database is on Windows NT and it
> > is
> > 8.1.6.
> >
> > Thanks in advance for your help.
> >
> > Best regards
> > Prasad
> >
> >
> > --
> > 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).
>
>
>__
>Terrorist Attacks on U.S. - How can you help?
>Donate cash, emergency relief information
>http://dailynews.yahoo.com/fc/US/Emergency_Information/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Baumgartel
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ARUN K C
  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: Copy Oracle's binary.

[Kimberly Smith]

Have 
you upgraded those databases?  Its no longer possible to 
just
copy 
ORACLE_HOME and expect to be able to upgrade it.  That 
being
said, 
I never did bother to identify the other directories as I 
felt
it was 
just as easy to install the software.  
 
You 
could do a full system copy though.  

  -Original Message-From: Feng, Jun 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 3:50 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Copy Oracle's binary.
  Sure. We have done that many 
  times.
   
  Jun
  
-Original Message-From: Thanh-truc Nguyen 
[mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 6:31 
PMTo: Multiple recipients of list ORACLE-LSubject: 
Copy Oracle's binary.
Hello,
 
I've two machines (with the same unix's configuration 
on Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you 
think it's possible to copy Oracle's binary and the database 
on Unix level to the new serveur instead of installing and cloning the 
db ?
 
Thank you very much.
 
Thanh-truc Nguyen  

WinNT / Oracle 8.0.5 / Problem with mapped drive

[George Hofilena]

List,

One of our web developers wants to extract a text file from Oracle and put
it directly into a mapped drive that points to another NT server which acts
as our web server.  He's using a trigger to do this.  I thought we could map
one of the web server's drive on the database server, have Oracle see it
through the UTIL_DIR parameter and the problem should be solved.  Well,
partly.  This will only work if the OS account that was used to create the
mapped drive is currrently logged into the database server.  Onec the
account/user is logged offOtherwise, it doesn't.

We considered calling a NET USE command from within the PL/SQL program but
it doesn't look as simple as we thought it should be.  Is there a different
solution to this problem or a better way than using the external procedure
approach?

Thanks,

George
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Hofilena
  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).

Perl code example

[Hagedorn, Linda]

Title: Perl code example





Hello, 


I'm looking for a Perl example passing parameters.  


The code below has the userids and passwords hardcoded in clear text in the system line, parms 3 and 5 (five lines from the bottom), and the Oracle sid is hardcoded also.  The code has to be changed to 1) read .pwd1 and .pwd2 files containing the passwords, and set a literal for the SID and substitute it at in the code.  

I'm not a Perl coder, and would appreciate any information, hints, or links to the manual.  


Thanks, Linda 




#!/usr/local/bin/perl
#
use CGI qw(:standard);
#
$| = 1;
($sec,$min,$hour,$mday,$mmonth,$myear,$wday,$yday,$isdst) = localtime(time);
if ($myear < 99) {
    $myear++;
}
$myear += 1900;
$mmonth += 1;
print header;
if (!param()) {
    print start_html('dev02 QRX4 DB Refresh'),
    h1('dev02 QRX4 DB Refresh for Formulary qRx Version 4.0'),
    hr,
    "",
    "Enter a date to start the Oracle database refresh script,",
    "then hit Submit to kick off the refresh for that date.",
    start_form,
    "Enter the target refresh date: ",
    textfield('day',$mday,2),
    textfield('month',$mmonth,2),
    textfield('year',$myear,4),
    p, submit('Submit'),
    end_form,
    hr;
} else {
#    print "You entered :";
    $dy = param('day');
    $mo  = param('month');
    $yr  = param('year');
    print "You are transferring all data modified on or after ", $dy, "-", $mo,"-", $yr, " to update";
   print  "\n";
 print "QRX4: Starting script with /opt/oracle/scripts/staging/cerebellum/refresh.sh  $dy-$mo-$yr\n";
    print "http://parietal.corpdc.epocrates.com/cgi-bin/staging/productionDater_dev02.pl>Return to previous page",hr;

    print "";
    system "/opt/oracle/scripts/staging/refresh.sh gui4 pwd1 qrx4 pwd2 $dy-$mo-$yr dev02";
    print "";
    print "http://parietal.corpdc.epocrates.com/cgi-bin/staging/productionDater_dev02.pl>Return to previous page",hr;

    print end_html;
}

RE: Copy Oracle's binary.

[Feng, Jun]

Sure. 
We have done that many times.
 
Jun

  -Original Message-From: Thanh-truc Nguyen 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 6:31 
  PMTo: Multiple recipients of list ORACLE-LSubject: Copy 
  Oracle's binary.
  Hello,
   
  I've two machines (with the same unix's configuration on 
  Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you think 
  it's possible to copy Oracle's binary and the database on Unix level 
  to the new serveur instead of installing and cloning the db ?
   
  Thank you very much.
   
  Thanh-truc Nguyen  

RE: Alternatives to roles in procedures?

[Thomas Jeff]

Title: RE: Alternatives to roles in procedures?





We don't allow granting IUD privileges to remote schemas at our site.   


All DML to be applied on tables within a given schema is performed
only by stored procedures owned by that schema.   We essentially have
just two roles (assume ABC schema):   ABC_ROLE, which consists only
of execute privileges on stored procedures in ABC, and ABC_RO_ROLE
which are SELECT privileges only on tables in ABC.


Jeff T.
[EMAIL PROTECTED]



-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Alternatives to roles in procedures?



So, there we are, in 8.1.7 on HP/UX 11.0.  We have several dozen tables in
schema "A" that need to be accessed from procedures in schema "B".  We had
previously been using a role to grant access to these tables but now with
the procedures, this ain't an option.


Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc
on each table to schema "B"?


TIA,
Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Copy Oracle's binary.

[Thanh-truc Nguyen]

Hello,
 
I've two machines (with the same unix's configuration on 
Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you think 
it's possible to copy Oracle's binary and the database on Unix level 
to the new serveur instead of installing and cloning the db ?
 
Thank you very much.
 
Thanh-truc Nguyen  

RE: 8.1.7.2.1 patch for hp-ux 64 bit

[Kimberly Smith]

Just a thought Matt, but did you remember
to do the download in binary?

-Original Message-
Sent: Monday, September 17, 2001 2:36 PM
To: Multiple recipients of list ORACLE-L


I have no problems whatsoever. Donloaded, untarred & installed.

-Original Message-
Sent: Monday, September 17, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L



Has anybody successfully downloaded this patch from 
Oracle Metalink?  I can't get the tar file 
to extrace from the zip file. 

Matt 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 8.1.7.2.1 patch for hp-ux 64 bit

[Adams, Matthew (GEA, 088130)]

Title: 8.1.7.2.1 patch for hp-ux 64 bit



I 
figured out the problem 
 
PKzip 
was unable to read the tar file, but WinZip was.

  -Original Message-From: Vergara, Michael (TEM) 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 5:36 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  8.1.7.2.1 patch for hp-ux 64 bit
  It's not zipped.  Just take off the .gz and then 
  try un-tar-ing it.
   
  ---
  ===
  Michael P. 
  Vergara
  Oracle DBA
  Guidant Corporation
  (909) 914-2304
  
-Original Message-From: Adams, Matthew (GEA, 
088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, September 
17, 2001 1:51 PMTo: Multiple recipients of list 
ORACLE-LSubject: 8.1.7.2.1 patch for hp-ux 64 
bit
Has anybody successfully downloaded this patch from 
Oracle Metalink?  I can't get the tar file 
to extrace from the zip file. 
Matt 

RE: 8.1.7.2.1 patch for hp-ux 64 bit

[Veronica Levin]

Title: 8.1.7.2.1 patch for hp-ux 64 bit









Hi listers,

I have downloaded the 8.1.7.2 patch
for AIX and haven’t been able to unzip it.

Is this comment valid for all oracle
patches? 

 

Saludos, 

Veronica Levin Enriquez

Administrador AIX

Compañía Cervecera de Nicaragua

 

-Mensaje
original-
De: Vergara, Michael (TEM)
[mailto:[EMAIL PROTECTED]]
Enviado el: Lunes, 17 de
Septiembre de 2001 03:36 p.m.
Para: Multiple recipients of list
ORACLE-L
Asunto: RE: 8.1.7.2.1 patch for
hp-ux 64 bit

 

It's not zipped.  Just take off the
.gz and then try un-tar-ing it.

 

---

===

Michael
P. Vergara

Oracle DBA

Guidant Corporation

(909) 914-2304

-Original
Message-
From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001
1:51 PM
To: Multiple recipients of list
ORACLE-L
Subject: 8.1.7.2.1 patch for hp-ux
64 bit

Has
anybody successfully downloaded this patch from 
Oracle Metalink?  I can't get the tar
file 
to extrace from the zip file. 

Matt 

RE: RE: how to zip email?

[Srini . Chavali]

Close, but no cigar !
It's an outlook export file extension.
(Dunno if you were being sarcastic ;-))
Srini




"Gogala, Mladen" <[EMAIL PROTECTED]>@fatcity.com on 09/17/2001 04:35:55 PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:



Pacific Standard Time?

> -Original Message-
> From: Christopher Spence [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 4:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OT: RE: how to zip email?
>
>
> Just create a PST, and then zip that.
>
> "Do not criticize someone until you walked a mile in their
> shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
>
> Christopher R. Spence
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
>
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>
>
>
> -Original Message-
> Sent: Monday, September 17, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
>
> Hi all,
>
> This is not an Oracle question, but thought peoele on
> this list might know:
>
> I saved many emails about Oracle, Unix in the
> Microsoft Outlook, and I like to send these
> information esle where.  I'd like to know where are
> these emails stored in the local or network directory,
> so I can make a zip.  (NT 4.0, Microsoft Outlook 97).
>
> Thank you!
>
> Andrea
>
>
> __
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Information/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andrea Oracle
>   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: Christopher Spence
>   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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Alternatives to roles in procedures?

[Jared . Still]

Short answer:  No

When using procedures to allow access to a schema, you really should
consider using 3 schemas, not 2.

The C schema gets execute access to the procs in Schema B.   No users
will have access to the tables this way.

Jared



   
  
"Jesse, Rich"  
  

world.com>cc:  
  
Sent by:  Subject: Alternatives to roles in 
procedures?  
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
09/17/01 01:30 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




So, there we are, in 8.1.7 on HP/UX 11.0.  We have several dozen tables in
schema "A" that need to be accessed from procedures in schema "B".  We had
previously been using a role to grant access to these tables but now with
the procedures, this ain't an option.

Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc
on each table to schema "B"?

TIA,
Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
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: The DBA in the IS organization

[satar naghshineh]

As for me, this is my 3rd job as an Oracle DBA.

My first job was working for a Porno Company based out
of Beverly Hills, CA. It was a small company (130
internal employees and 200 outside employees aka phone
actress and actors) that owned the majority of the
phone sex lines (over 10,000 lines coming in). As the
DBA, I reported to the owner. I supported and worked
closely with the developers and network admins. But my
major tasks were to automate business practices and to
suggest ways to improve perversion efficiency.

My Second job was working for a national VAR (value
added reseller) company which had strong ties to Sun
Microsystems, IBM, HP, SGI, etc. I reported to the
Co-owner of the company. My job role was to work
closely with the system admins to implement enterprise
solutions for major corporations.

My current job involves a large international
Manufacturing company. As the DBA, I report to the CIO
of the company. Each division has a MIS manager. My
role is to provide support to each division (which
sucks because I have to travel a lot, especially to
the UK...no offense to the people of the UK, but the
only good thing about the UK that I like are the
PUBS!!! The weather, some people and food is another
story).  My major tasks are to consolidate the
companies on a data level, which means I work closely
witht the ERP developers. I also make hardware and
software suggestions to ease operations.

Hope this helps! As far as being with the developers,
you will need to be with them regardless, either at
the beginning of development to make sure they don't
mess up the database or after development to fix the
problems that they did mess up.

Regards,
Satar

Please remember that TRUE muslims do not advocate
violence. Please do not displace your anger on
innocent muslims living in your local area.
--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote:
> >> From: "Farnsworth, Dave"
> <[EMAIL PROTECTED]>
> >> Date: Sat, 15 Sep 2001 05:49:20 -0500
> >> Subject: The DBA in the IS organization
> >>
> >>I am wondering how my fellow DBA's fit into their
> IS organization.  My
> >>situation is this.  I was hired just a little over
> a year ago as a DBA but
> >>my official title is network programmer.  Except
> for some job scripting I
> >>have not done any coding.  I am the only DBA for 5
> Oracle databases and 4
> >>SQL Server installations.  Currently my boss is
> the head of development.
> I
> >>work with the developers and with the network
> admins equally.  I sometimes
> >>feel a bit of a conflict with me being under the
> developers.  I have been
> >>thinking about approaching the VP of IS about
> having me be under him
> rather
> >>than being under development.  I feel I need to
> have equal footing with
> the
> >>development managers and with the network admins. 
> Right now I am kind in
> >>limbo with no real authority.
> >>So anyway, I am just wondering where you fit in
> your organization and what
> >>is the appropriate place for the DBA.
> >>And yes I got called into work.  Sucks to be me
> today.  :o)
> 
> FWIW, I as the only DBA report directly to the IS
> Manager.  We don't do much
> in-house development preferrring to purchase OTS
> solutions.  We have 2 folk
> managing the Network and Server Admin one of whom
> reports directly to the IS
> Manager.  We have some information analysts who also
> report directly to the
> IS Manager.   We're an NT house.  I have local admin
> rights on servers which
> host Oracle databases 6 in all with 10 databases.  I
> share an office with
> the NT admin folk.
> 
> I would have thought that you being separate from
> developers from a
> reporting point of view would be an advantage. 
> Being amoung them is an
> advantage in that you might get to raise matters of
> concern before they go
> too far down the line.  I would think you'd need
> autonomy to defend amoungst
> other topics issues relating to database performance
> potentially with
> developers and/or adminstrators.
> 
> So what perks if any do you get for being called in
> on a Saturday?.  The
> longer I hang around in this DBA field the more it
> seems to be like a
> "vocation" ;)  
> 
> 
> Sean :)
> 
> Rookie Data Base Administrator
> Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
>   
> Organon (Ireland) Ltd.
> E-mail: [EMAIL PROTECTED]   [subscribed: Digest
> Mode]
> 
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
> 
> "Nobody loves me but my mother... and she could be
> jivin' too."  - BB King
> 
> 
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: O'Neill, Sean
>   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:

RE: Looking for 24 X 7 Design Considerations

[Kimberly Smith]

Now I must disagree with this.  Although I am on 
call every annoying day of the year it is so rare
that I have database issues its not even funny.
I think nothing of leaving for the weekend.  At the
very least I can talk someone though something, even
if I am at the top of a mountain.  Calls have
to wait while I am on the wall at Smith Rock though 
(or my climbing partner is on the wall).


5. Kiss your weekends and Holidays good bye!


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Renaming GLOBAL_NAME

[Prasada . Gunda1]

Thank you all for your replies. I  bounced the database and still it has
the same problem.

Regards,
Prasad



   

"Rachel

Carmichael"  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
Subject: Re: Renaming GLOBAL_NAME 

Sent by:   

root@fatcity.  

com

   

   

09/17/2001 

03:30 PM   

Please 

respond to 

ORACLE-L   

   

   





you need to reboot your database, changing the init.ora parameter to
global_name to false:

SQL> select value from v$parameter where name like 'global_name%';

VALUE
--
FALSE

SQL> select * from global_name;

GLOBAL_NAME
--
UREGPROD



>From: Paul Baumgartel <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Renaming GLOBAL_NAME
>Date: Mon, 17 Sep 2001 10:05:20 -0800
>
>I don't think you can do this.  GLOBAL_NAME by definition consists of
>the database name and database domain, which defaults to WORLD.
>
>Paul Baumgartel
>
>--- [EMAIL PROTECTED] wrote:
> >
> > Hi All,
> >
> > I am trying to rename the global_name from SIMSNT7B.WORLD to
> > SIMSNT7B.
> >
> > I issued the following command to change the global_name.
> >
> > ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;
> >
> > Still it is showing SIMSNT7B.WORLD when I query the global_name view.
> > SQL> select * from global_name;
> >
> > GLOBAL_NAME
> > --
> > SIMSNT7B.WORLD
> >
> > Values for the following parameters in v$parameter view,
> > GLOBAL_NAMES  parameter value is FALSE and DB_DOMAIN parameter value
> > is
> > NULL.
> > We are not using Oracle Names server.  I renamed SQLNET.ORA file in
> > network\admin location.
> > Init.ora file has global_names set to false.
> >
> > How do I change to SIMSNT7B?  This database is on Windows NT and it
> > is
> > 8.1.6.
> >
> > Thanks in advance for your help.
> >
> > Best regards
> > Prasad
> >
> >
> > --
> > 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).
>
>
>__
>Terrorist Attacks on U.S. - How can you help?
>Donate cash, emergency relief information
>http://dailynews.yahoo.com/fc/US/Emergency_Information/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Baumgartel
>   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') an

RE: RE: how to zip email?

[Gogala, Mladen]

Pacific Standard Time? 

> -Original Message-
> From: Christopher Spence [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 4:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: OT: RE: how to zip email?
> 
> 
> Just create a PST, and then zip that.
> 
> "Do not criticize someone until you walked a mile in their 
> shoes, that way
> when you criticize them, you are a mile a way and have their shoes."
> 
> Christopher R. Spence 
> Oracle DBA
> Phone: (978) 322-5744
> Fax:(707) 885-2275
> 
> Fuelspot
> 73 Princeton Street
> North, Chelmsford 01863
>  
> 
> 
> -Original Message-
> Sent: Monday, September 17, 2001 1:15 PM
> To: Multiple recipients of list ORACLE-L
> 
> Hi all, 
> 
> This is not an Oracle question, but thought peoele on
> this list might know:
> 
> I saved many emails about Oracle, Unix in the
> Microsoft Outlook, and I like to send these
> information esle where.  I'd like to know where are
> these emails stored in the local or network directory,
> so I can make a zip.  (NT 4.0, Microsoft Outlook 97).
> 
> Thank you!
> 
> Andrea
> 
> 
> __
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
> http://dailynews.yahoo.com/fc/US/Emergency_Information/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Andrea Oracle
>   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: Christopher Spence
>   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: Gogala, Mladen
  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: 8.1.7.2.1 patch for hp-ux 64 bit

[Vergara, Michael (TEM)]

Title: 8.1.7.2.1 patch for hp-ux 64 bit



It's not zipped.  Just take off the .gz and then 
try un-tar-ing it.
 
---
===
Michael P. 
Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

  -Original Message-From: Adams, Matthew (GEA, 088130) 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 
  1:51 PMTo: Multiple recipients of list ORACLE-LSubject: 
  8.1.7.2.1 patch for hp-ux 64 bit
  Has anybody successfully downloaded this patch from 
  Oracle Metalink?  I can't get the tar file 
  to extrace from the zip file. 
  Matt 

RE: 8.1.7.2.1 patch for hp-ux 64 bit

[Gogala, Mladen]

I have no problems whatsoever. Donloaded, untarred & installed.

-Original Message-
Sent: Monday, September 17, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L



Has anybody successfully downloaded this patch from 
Oracle Metalink?  I can't get the tar file 
to extrace from the zip file. 

Matt 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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: OPEN_CURSORS

[Deepak Thapliyal]

hi cyril,

open_cursors determines the maximum # of open cursors
u can have in ur shared sql area / libray cache of the
shared pool. assumimg that u previously had this set
to 500. Now when u set it to 1000, obviously oracle
needs more memory to handle additional open cursors.. 

the risks of ur application failing with an out of
open_cursors errors far outweigh the memory
requirements to maintain these .. and these days when
memory is cheap .. it should not impact memory .. i
mean its not that this will suck off all available
memory

deepak

--- [EMAIL PROTECTED] wrote:
> Hi all,
> 
>   I was just wondering what was the performance and
> impact of having
> open_cursors set to 1000. Will it require more
> shared_memory, etc...
> 
>   Thanks
> 
> Cyril Jaouich (Consultant Unix)
> ---
> Centre de support informatique CSI
> --
> Tél 514-289-2211 x6237 (jusqu'au 7 sept)
> Tél 514-840-3000 x5527 (à partir du 10 sept)
> 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: OPEN_CURSORS

[Christopher Spence]

Title: OPEN_CURSORS









A few bytes, I think it is something like
16 bytes per open cursor setting.  
I think Steve Adams once mentioned an exact number.



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, September 17, 2001 4:45 PM
To: Multiple recipients of list ORACLE-L
Subject: OPEN_CURSORS

 

Hi all, 

    I was just wondering what was the performance and impact of having
open_cursors set to 1000. Will it require more shared_memory, etc...

    Thanks 

Cyril Jaouich (Consultant
Unix) 
---

Centre
de support informatique CSI 
--

Tél
514-289-2211 x6237 (jusqu'au 7 sept) 
Tél
514-840-3000 x5527 (à partir du 10 sept) 

Oracle DBA Needed in Albany New York

[OraStaff]

We have a client requirement an for Oracle DBA  in Albany, New York.
This is a private, nonprofit educational corporation that supports research,
education and public service at The State University of New York through
the innovative and efficient management of sponsored programs.
The selected individual will be a key member of the database
administration team supporting the Oracle Financial applications and
related enterprise reporting systems.

This is a full time staff position so no sub-contractors or third parties
please.

Please do not call or send a resume if you are not in the U.S. and/or need 
sponsorship.


Requirements:
- A degree in Computer Science or related field
- 2-3+ years Oracle DBA experience including:
* Database tuning
* SQL Tuning
* Database Architectural Design
* Installation of Oracle add-on products such as OEM and Discoverer.

- U.S. citizens or permanent residents only

This position offers:
* Opportunity to become a key member of the I.T. team
* Base Salary -D.O.E-70-75K
* Great Benefits package
* Relocation package may be available for the right candidate

NO sub contracting positions available.
*U.S. citizenship or green card holders only
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as an attachment to:
Bill Law, 
Oracle Placement Specialist
OraStaff, Inc.
Ph: 1-800-549-8502-Please do not call if you need sponsorship
Email: [EMAIL PROTECTED]
Please use job code: One/Albany/DBA/University/Suzanne

All Submissions are handled in confidence.

We pay referral fees.
So please contact me if you know of anyone who would be qualified/interested
in the
posiition described above- if it is not a match for your skills.
Thanks,
Bill Law





--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: OraStaff
  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: Looking for 24 X 7 Design Considerations

[satar naghshineh]

All the databases that I have worked on or been
responsible for, have been 24x7. Here are some
suggestions:

1. Know the requirements of your environment in
regards to UPTIME. Have it documented. The best
practice that works well is Service Level Agreements,
if there is none in place, implement them. There is a
world of cost differences between systems that can be
down for 2 hours to those which can't be down at all.

2. In high availability databases, a Hardware cluster
configuiration is highly recommended for 2 purposes:
(A) Fast recovery and (B) Software upgrades (both APP
and DB).

3. If you do not have a Test server, buy one!

4. Make sure that everyone (network Admins, DBAs,
System Admins, etc.) has a way to communicate with one
another. I suggest Cell phones as apposed to pagers. 

5. Kiss your weekends and Holidays good bye!

If you have any specific questions, please feel free
to contact me at [EMAIL PROTECTED]

Regards,
Satar

Please remember that TRUE muslims do not advocate
violence. Please do not displace your anger upon
innocent muslims in your local area. 

--- Tracy Rahmlow <[EMAIL PROTECTED]> wrote:
> We currently have 15+ databases (7.3.4 & 8i using
> IBM AIX and HACMP) that do
> not have a  24x7 restriction.  Now, management is
> looking to bring in new
> products that will need to be 24X7.  They are
> looking for costs to determine
> the viability of such a decision.  I have no 24x7
> experience and am looking for
> ideas or options to consider.  [At least initially
> they are stating there can
> be no downtime for maintenance (upgrades/reorgs)]
> 


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: satar naghshineh
  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: READING EXPLAIN PLAN

[Greg Moore]

>> How do you read the explain plan 
output?
 
See, Use EXPLAIN PLAN and TKPROF To Tune Your 
Applications
http://www.dbspecialists.com/4dbas/presos/use_explain.html
 
 

  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  Sent: Monday, September 17, 2001 1:05 
  PM
  Subject: READING EXPLAIN PLAN
  
  HOw doyou read the explain plan outout ? I format 
  it with a script and still do not know how to read it . Which line I must read 
  first?The output of my explain plan is below and how do you read this 
  output pleASE?
   
  OPERATION  
  OPTIONS    
  OBJECT_NAME  
  POSITION--   
  --   --  
  --SELECT 
  STATEMENT  
   
  3141  
  FILTER 
  1    HASH 
  JOIN 
     
  OUTER   1  
  HASH 
  JOIN    
  1    HASH 
  JOIN  1  
  TABLE 
  ACCESS  
  FULL    
    
  K_GD_AB_BINA    
  1  HASH 
  JOIN  
                  
              
   
  2    TABLE 
  ACCESS    
  FULL   
          
  BOLUM   
  1    HASH 
  JOIN      
   
  OUTER  
           
      
  2  
  MERGE JOIN   
     
  CARTESIAN    
  1    
  TABLE ACCESS   BY INDEX 
  ROWID 
  KODLAR    
   
  1  
  INDEX      
        RANGE 
  SCAN   
  IND_KODLAR_KOD_TABLO 
  1    
  SORT  
          
  JOIN   
                  
      
  2  
  TABLE ACCESS     BY INDEX 
  ROWID 
  KODLAR  
      
  1    
  INDEX          
      RANGE 
  SCAN 
  IND_KODLAR_KOD_TABLO    
  1  
  TABLE ACCESS     
  FULL 
        
  KADRO_TERFI 
  2    TABLE 
  ACCESS   
      
  FULL   
          
  SICIL 
     2  TABLE 
  ACCESS 
      
  FULL   
          
  KADRO_TERFI   
  
   
  Here is my sql .
  
  SELECT T_SICIL.KURUM_SICIL_NO, T_SICIL.AD,T_SICIL.SOYAD, 
  T_SICIL.AYR_TRH, T_SICIL.SAKAT_GRB, T_BOL.BIRIMKOD,T_BOL.BOLUMAD AS 
  BIRIMI,T_BOL.BOLUMAD2 AS GOREV_YERI, T_BOL.KAT, T_BOL.ODA_NO, 
  T_KADRO.DOGUM_YILI, T_KOD.KODACK AS UNVANI,T_KADRO.UNVAN2, 
  T_KODG.KODACK, T_KADROG.GOREV,T_SICIL.DOGUM_TRH AS 
  DOGUM_TARIHI,T_BOL.BINA_KOD ,T_BINA.BINA_ADI AS BINA
  FROM
   KADRO_TERFI T_KADRO, SICIL T_SICIL, BOLUM T_BOL, S_UYAPPERS_KODLAR 
  T_KOD, S_K_GD_AB_BINA T_BINA, S_UYAPPERS_KODLAR T_KODG, KADRO_TERFI 
  T_KADROG
  WHERE
   (T_KADRO.SICIL_NO = T_SICIL.SICIL_NO) AND (T_KADRO.BRM = 
  T_BOL.BIRIMKOD )AND (T_KADRO.UNVAN2 (+) = T_KOD.KOD AND 
  T_KOD.TABLO = 'UNVAN') AND (T_BOL.BINA_KOD = 
  T_BINA.BINA_KODU)AND ((T_KADROG.SICIL_NO = T_SICIL.SICIL_NO) 
  AND (T_KADROG.GOREV (+) = T_KODG.KOD AND T_KODG.TABLO = 
  'GOREV'))

[Fwd: RE: Looking for 24 X 7 Design Considerations]

[Charlie Mengler]

I guess then I'm "nutso", because I have a 9i DB in production.
Any independently verifiable substantiation for your claim would be
welcomed.
This 9i instance has had flawless performance for the last two months;
which
is how long it has been in production.
 Original Message 


Subject: 

RE: Looking for 24 X 7 Design Considerations



Date: 

Mon, 17 Sep 2001 12:40:18 -0800



From: 

"JOE TESTA" <[EMAIL PROTECTED]>



Reply-To: 

[EMAIL PROTECTED]



Organization: 

Fat City Network Services, San Diego, California



To: 

Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>



 Anyone contemplating upgrading anything more important than a
sandbox database to 9i is nutso. 9i is ready for development playing
around in 6-8 months, production no earlier than 12-18 months is my estimation. joe 

9iAS Forms on Solaris (or Unix)

[Charlie Mengler]

I have a collection of *mmb, *olb, & *plx files
which are needed to successfully compile *fmb files in *fmx.
At the present I have all of these libraries residing in a
single directory which is included in FORMS60_PATH; but f60gen
does not seem to be able to resolve objects that reside in
these libraries.

If/when I placed the fmb file into this "library" directory
and make it my current working directory, I can successfully
get f60gen to create the desired *fmx file. 

So far Oracle Tech. Sup. has been unable to assist.
It is not clear whether the source of the problem is
related to an environmental variable, filename case
sensitivity (since the FMB files were created on NT),
or something else.

I'd like to hear from anyone who is successfully using 
*mmb, *olb, & *plx files on Unix to generate fmx files.

-- 
Charlie MenglerMaintenance Warehouse  
[EMAIL PROTECTED]   10641 Scripps Summit Ct.
858-831-2229   San Diego, CA 92131
There is at least one infinite resource in the universe. Stupidity!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  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: Looking for 24 X 7 Design Considerations

[Christopher Spence]

SLA = Service Level Agreement.  An example is:  Customer response time to
submit transaction will be completed in 5 seconds.  Or, login process will
take 10 seconds.  It gives you things to quantify, they are very good
measures.

Trending, I would recommend I/Watch or Q-Diagnostics.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, September 17, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L


What is SLA?
How are you doing trending?



 

Christopher

Spence   To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Looking for 24 X 7
Design Considerations  
Sent by:

root@fatcity.

com

 

 

09/17/01

11:00 AM

Please

respond to

ORACLE-L

 

 





In my opinion, one of the biggest things with 24x7 is planning.
Documenting
what is normal maintenance either it be for your application or for the
database itself.  This means finding out how often normal maintenance
(index
rebuilds, re-orgs, data loads) runs, and how long.  This is a good step
regardless if the shop is 24x7, this way you know at all times what is
needed and when.

Then you need to determine which systems are critical to the success of the
application, i.e. database, backups, hubs and such.  Then I would work on a
solution that will provide redundancy for these devices.  One thing I like
to do is make a list of all types of failure, and then my expected results,
and time frame of recovery.  Then I would consult with management and
determine which are acceptable and which are not.

I cannot stress the usefulness of SLA's, either to a customer or to a
department (generally it is good to have both).  This will give you a
baseline you must follow.  If you have something that takes 10 seconds, and
you say it must be faster than 15 seconds, and one day it becomes 11 or 12,
you have a good idea how things are going and can take measures.  Finding
important areas where you attach a metric.

Another thing to be concerned with, and which can be a life saver is
trending.  This is very important in 24x7 environments so you can say "Ok,
in 6 months we are going to add 50Gb and a second tape drive, this is going
to cost $10,000 and will take 6 hours of time.".

In a 24x7 environment the best thing is to already know the problem.  It is
the problems that come up unexpectantly that make things very difficult.
Preparation and planning is critical to 24x7 environments.  Knowing what
can
happen and what you will do to resolve it ahead time can be a big
difference.

Hope this helps,

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, September 17, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L

We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that
do
not have a  24x7 restriction.  Now, management is looking to bring in new
products that will need to be 24X7.  They are looking for costs to
determine
the viability of such a decision.  I have no 24x7 experience and am looking
for
ideas or options to consider.  [At least initially they are stating there
can
be no downtime for maintenance (upgrades/reorgs)]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
  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: Christopher Spence
  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, 

RE: trace files

[Jamadagni, Rajendra]

A generate a lot of trace files when I am debugging some problem, I never
had this problem.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*1

This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.

*1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  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).

8.1.7.2.1 patch for hp-ux 64 bit

[Adams, Matthew (GEA, 088130)]

Title: 8.1.7.2.1 patch for hp-ux 64 bit





Has anybody successfully downloaded this patch from
Oracle Metalink?  I can't get the tar file 
to extrace from the zip file.


Matt

Alternatives to roles in procedures?

[Jesse, Rich]

So, there we are, in 8.1.7 on HP/UX 11.0.  We have several dozen tables in
schema "A" that need to be accessed from procedures in schema "B".  We had
previously been using a role to grant access to these tables but now with
the procedures, this ain't an option.

Are there any alternatives to granting SELECT, INSERT, UPDATE, DELETE, etc
on each table to schema "B"?

TIA,
Rich Jesse  System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OPEN_CURSORS

[Jaouich . Cyril]

Title: OPEN_CURSORS





Hi all,


    I was just wondering what was the performance and impact of having open_cursors set to 1000. Will it require more shared_memory, etc...

    Thanks


Cyril Jaouich (Consultant Unix)
---
Centre de support informatique CSI
--
Tél 514-289-2211 x6237 (jusqu'au 7 sept)
Tél 514-840-3000 x5527 (à partir du 10 sept)

RE: Oracle Pure Name and Address

[Gary Weber]

Title: Oracle Pure Name and Address



Used 
along with Data warehouse Builder to cleanse Names and Addresses, along with 
geo-coding (based on US Post Office data).
 
NOT 
included with any product, but an extra add-on ($20k/CPU I 
think).
 
This 
was purchased by Oracle from someone recently and 
repackaged.
Gary WeberSenior DBACharles Jones, LLC609-530-1144, 
ext 5529 
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, 
088130)Sent: Monday, September 17, 2001 2:30 PMTo: 
Multiple recipients of list ORACLE-LSubject: Oracle Pure Name and 
Address
Recently got a 8.1.7 shipment (for hp-ux) and found some CDs I've never seen in an Oracle shipment before 
Oracle Pure Name & Address (5.5.0.33) Oracle Pure Name & Address (North America) (5.5.0.33) 
Oracle Pure Name & Address (Europe, Middle East & 
Africa , Asia Pacific, and Latin America) 
(5.5.0.33) Oracle Geocode (US Data) (5.5.0.33) 

Anybody familiar with this stuff?  
(I could just drop it in the CD-ROM but I don't have time 
at the moment.) 
Matt Adams GE Appliances 

RE: Subtract 1 month from current date

[Kevin Lange]

Ron;
  Oracle 8, The Complete Referene By Koch and Loney, Oracle Press , ISBN:
0-07-88-2396-X

I hardly ever look syntax up online.

-Original Message-
Sent: Monday, September 17, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L


Thanks to everyone who replied to this question.  It appears I am the only
one who didn't know about 'add_months'.
I miss not having hardcopy documentation.  I don't like the documantation on
CD. 
Now that I know the answer I can find 'add_months' on the CD.  It's easy
when you know where to look!
 
Thanks again!
Ron

-Original Message-
Sent: Monday, September 17, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L



Hi Ron, 

Here it is 

(INV.WORLD-SYSTEM)>select add_months(sysdate,-1) from dual; 

ADD_MONTH 
- 
17-AUG-01 

For conversions, etc. it's best to study the sql*plus doco.  In fact I had
to visit this exact chapter this morning to refresh my memory of date
formats and date functions.  I used to have a crib sheet i got in dba class
that showed every single conversion format and sql*plus function (like
add_months()) but I think I loaned it out and it never returned...

Lisa Koivu 
Oracle Database Administrator 
Fairfield Resorts, Inc. 
954-935-4117 


-Original Message- 
Sent:   Monday, September 17, 2001 11:40 AM 
To: Multiple recipients of list ORACLE-L 

Can someone tell me how to subtract 1 month from the current date?
Also, 
where can I find answers and examples to this type of coding question? 

Thanks! 
Ron Smith 
Database Administrator 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Smith, Ron L. 
  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: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Looking for 24 X 7 Design Considerations

[JOE TESTA]

Anyone contemplating upgrading anything more important than a sandbox 
database to 9i is nutso.
 
9i is ready for development playing around in 6-8 months, production no 
earlier than 12-18 months is my estimation.  
 
joe
>>> [EMAIL PROTECTED] 09/17/01 03:25PM 
>>>Tracy - Is there any possibility of upgrading these databases to 
Oracle8i,or even better 9i before you implement 24X7? Oracle is claiming new 
featuresin 9i will support 24X7. I would also imagine that if you could 
bring alldatabases up to the same level, it would be easier to establish 
policies.For 7.3.4, you might need to do something entirely different. Also 
there isa book "Oracle 24x7 Tips and Techniques" by Venkat S. Devraj, but 
thepublishing date was 1999, so the information may be dated.Dennis 
WilliamsDBALifetouch, 
Inc.[EMAIL PROTECTED]-Original Message-Sent: 
Monday, September 17, 2001 10:15 AMTo: Multiple recipients of list 
ORACLE-LWe currently have 15+ databases (7.3.4 & 8i using IBM 
AIX and HACMP) that donot have a  24x7 restriction.  Now, 
management is looking to bring in newproducts that will need to be 
24X7.  They are looking for costs to determinethe viability of such a 
decision.  I have no 24x7 experience and am lookingforideas or 
options to consider.  [At least initially they are stating 
therecanbe no downtime for maintenance (upgrades/reorgs)]-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Tracy 
Rahmlow  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
DENNIS WILLIAMS  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).

test schema from prod

[Raghu Kota]

Hi Friends,

Great input and wonderful info guys!! Thanks to all. Its always nice to see 
different view points.

Thanks again
Raghu.

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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: Looking for 24 X 7 Design Considerations

[DBarbour]

SLA - Service Level Agreement
How do you do trending?  Monitor the heck out of your DB and plan ahead.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

Sandi.McClary@f

lyingj.comTo: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
Sent by:  cc:  

[EMAIL PROTECTED]   Subject: RE: Looking for 24 X 7 Design 
Considerations
m  

   

   

09/17/2001 

02:05 PM   

Please respond 

to ORACLE-L

   

   






What is SLA?
How are you doing trending?




Christopher

Spence   To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: Looking for 24 X
7 Design Considerations
Sent by:

root@fatcity.

com



09/17/01

11:00 AM

Please

respond to

ORACLE-L







In my opinion, one of the biggest things with 24x7 is planning.
Documenting
what is normal maintenance either it be for your application or for the
database itself.  This means finding out how often normal maintenance
(index
rebuilds, re-orgs, data loads) runs, and how long.  This is a good step
regardless if the shop is 24x7, this way you know at all times what is
needed and when.

Then you need to determine which systems are critical to the success of the
application, i.e. database, backups, hubs and such.  Then I would work on a
solution that will provide redundancy for these devices.  One thing I like
to do is make a list of all types of failure, and then my expected results,
and time frame of recovery.  Then I would consult with management and
determine which are acceptable and which are not.

I cannot stress the usefulness of SLA's, either to a customer or to a
department (generally it is good to have both).  This will give you a
baseline you must follow.  If you have something that takes 10 seconds, and
you say it must be faster than 15 seconds, and one day it becomes 11 or 12,
you have a good idea how things are going and can take measures.  Finding
important areas where you attach a metric.

Another thing to be concerned with, and which can be a life saver is
trending.  This is very important in 24x7 environments so you can say "Ok,
in 6 months we are going to add 50Gb and a second tape drive, this is going
to cost $10,000 and will take 6 hours of time.".

In a 24x7 environment the best thing is to already know the problem.  It is
the problems that come up unexpectantly that make things very difficult.
Preparation and planning is critical to 24x7 environments.  Knowing what
can
happen and what you will do to resolve it ahead time can be a big
difference.

Hope this helps,

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, September 17, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L

We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that
do
not have a  24x7 restriction.  Now, management is looking to bring in new
products that will need to be 24X7.  They are looking for costs to
determine
the viability of such a decision.  I have no 24x7 experience and am looking
for
ideas or options to consider.  [At least initially they are stating there
can
be no downtime for maintenance (upgrades/reorgs)]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
  

RE: trace files

[Christopher Spence]

You can make as many trace files you like.  There is a limit to size, but I
don't know any limits to frequency.  If you log in and then out, the trace
file name will change with the new pid.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, September 17, 2001 3:05 PM
To: Multiple recipients of list ORACLE-L

A developer here claims that he can only generate one trace file per day.

Even if he logs out and then back onto Oracle.

Oracle 8.1.7.2.1 on NT.

Does this make any sense?

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.com
-- 
Author: Boivin, Patrice J
  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: Christopher Spence
  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: Using CLOB

[Christopher Spence]

Title: Using CLOB









Funny, I just did this today for a developer,
it does not go to a table, it uses Oracle 8i's new feature to use clob's
without a table to point to, thus memory only.

 

create or replace procedure
DisplayClob 
is

myclob1  CLOB;
myclob2  CLOB;
buffer   VARCHAR2(32000);
output   VARCHAR2(32000);
amount   NUMBER := 50;
offset   NUMBER := 1;
clob_length  NUMBER;
read_counter NUMBER;

begin

--
Create text for the buffer
buffer := '1234567890abcdefghijklmnopqrstuvwxyz';
DBMS_OUTPUT.PUT_LINE('Buffer: ' || buffer);

--
Determine the length of the buffer
amount := length(buffer);
DBMS_OUTPUT.PUT_LINE('Buffer Length: ' || TO_CHAR(amount));

--
Create lob locator (Temporary)
DBMS_LOB.CREATETEMPORARY(myclob1,FALSE,DBMS_LOB.CALL);
DBMS_LOB.CREATETEMPORARY(myclob2,FALSE,DBMS_LOB.CALL);

--
Write data into the clob initially.
DBMS_LOB.WRITE(myclob2, amount, 1, buffer);

FOR i IN 1 .. 1000
LOOP
    DBMS_LOB.APPEND(myclob1, myclob2);
END LOOP;

--
Display size of clob
clob_length := DBMS_LOB.GETLENGTH(myclob1);
DBMS_OUTPUT.PUT_LINE('CLOB Size: ' || clob_length);

--
Display data from the temporary clob
read_counter := 0;

WHILE read_counter < clob_length
LOOP
    DBMS_LOB.READ(myclob1, amount, offset, output);
    DBMS_OUTPUT.PUT_LINE('Clob contents: ' || output);

    read_counter := read_counter +
amount;
END LOOP;

DBMS_LOB.FREETEMPORARY(myclob1);
DBMS_LOB.FREETEMPORARY(myclob2);

end DisplayClob;

 

 



"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way and
have their shoes."

Christopher R. Spence 
Oracle DBA 
Phone: (978) 322-5744 
Fax:    (707) 885-2275 

Fuelspot 
73 Princeton Street 
North, Chelmsford 01863 
  



-Original Message-
From: Yuval Arnon
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, September 17, 2001
2:40 PM
To: Multiple recipients of list ORACLE-L
Subject: Using CLOB

 

Hi, 
How
can you assign a text to a CLOB column defined in the DECLARE section of
PL/SQL.I am getting an error on wrong type.

i.e.. 

SQL> l 
 
1  declare 
 
2  c clob ; 
 
3  BEGIN 
 
4  c := 'This is a test'; 
 
5* END; 
SQL>
/ 
c :=
'This is a test'; 

* 
ERROR
at line 4: 
ORA-06550:
line 4, column 6: 
PLS-00382:
expression is of wrong type 
ORA-06550:
line 4, column 1: 
PL/SQL:
Statement ignored 

Yuval Arnon

RE: Using CLOB

[Jack C. Applewhite]

Title: Using CLOB



Yuval,
 
AFAIK, 
you can't do it by simply assigning values.  You've got to use 
the procedures and functions supplied package DBMS_LOB to create and 
manipulate "temporary" LOBs.
 
Jack
Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, 
Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Yuval ArnonSent: 
  Monday, September 17, 2001 1:40 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Using CLOB
  Hi, How can you 
  assign a text to a CLOB column defined in the DECLARE section of PL/SQL.I am 
  getting an error on wrong type.
  i.e.. 
  SQL> l   
  1  declare   2  c clob 
  ;   3  BEGIN   4  c := 'This is a test';   5* END; SQL> 
  / c := 'This is a test';  * ERROR at line 4: ORA-06550: line 4, 
  column 6: PLS-00382: expression is of wrong 
  type ORA-06550: line 4, column 1: 
  PL/SQL: Statement ignored 
  Yuval Arnon 
  

RE: Subtract 1 month from current date

[Smith, Ron L.]

Thanks to everyone who replied to this question.  It appears I am the only
one who didn't know about 'add_months'.
I miss not having hardcopy documentation.  I don't like the documantation on
CD. 
Now that I know the answer I can find 'add_months' on the CD.  It's easy
when you know where to look!
 
Thanks again!
Ron

-Original Message-
Sent: Monday, September 17, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L



Hi Ron, 

Here it is 

(INV.WORLD-SYSTEM)>select add_months(sysdate,-1) from dual; 

ADD_MONTH 
- 
17-AUG-01 

For conversions, etc. it's best to study the sql*plus doco.  In fact I had
to visit this exact chapter this morning to refresh my memory of date
formats and date functions.  I used to have a crib sheet i got in dba class
that showed every single conversion format and sql*plus function (like
add_months()) but I think I loaned it out and it never returned...

Lisa Koivu 
Oracle Database Administrator 
Fairfield Resorts, Inc. 
954-935-4117 


-Original Message- 
Sent:   Monday, September 17, 2001 11:40 AM 
To: Multiple recipients of list ORACLE-L 

Can someone tell me how to subtract 1 month from the current date?
Also, 
where can I find answers and examples to this type of coding question? 

Thanks! 
Ron Smith 
Database Administrator 
[EMAIL PROTECTED] 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Smith, Ron L. 
  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: Smith, Ron L.
  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: Renaming GLOBAL_NAME

[Rachel Carmichael]

you need to reboot your database, changing the init.ora parameter to 
global_name to false:

SQL> select value from v$parameter where name like 'global_name%';

VALUE
--
FALSE

SQL> select * from global_name;

GLOBAL_NAME
--
UREGPROD



>From: Paul Baumgartel <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Renaming GLOBAL_NAME
>Date: Mon, 17 Sep 2001 10:05:20 -0800
>
>I don't think you can do this.  GLOBAL_NAME by definition consists of
>the database name and database domain, which defaults to WORLD.
>
>Paul Baumgartel
>
>--- [EMAIL PROTECTED] wrote:
> >
> > Hi All,
> >
> > I am trying to rename the global_name from SIMSNT7B.WORLD to
> > SIMSNT7B.
> >
> > I issued the following command to change the global_name.
> >
> > ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;
> >
> > Still it is showing SIMSNT7B.WORLD when I query the global_name view.
> > SQL> select * from global_name;
> >
> > GLOBAL_NAME
> > --
> > SIMSNT7B.WORLD
> >
> > Values for the following parameters in v$parameter view,
> > GLOBAL_NAMES  parameter value is FALSE and DB_DOMAIN parameter value
> > is
> > NULL.
> > We are not using Oracle Names server.  I renamed SQLNET.ORA file in
> > network\admin location.
> > Init.ora file has global_names set to false.
> >
> > How do I change to SIMSNT7B?  This database is on Windows NT and it
> > is
> > 8.1.6.
> >
> > Thanks in advance for your help.
> >
> > Best regards
> > Prasad
> >
> >
> > --
> > 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).
>
>
>__
>Terrorist Attacks on U.S. - How can you help?
>Donate cash, emergency relief information
>http://dailynews.yahoo.com/fc/US/Emergency_Information/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Baumgartel
>   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).


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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: Migration

[JOE TESTA]

You don't migrate a database from 8.x to 8.x, migrations happen between 
major version numbers(like 7 to 8), heck 8 to 9 isnt even a migration 
nowadays.
 
anyway, break out the migration guide( a misnomer at best) and start 
reading the chapters on upgrading from 8.0 to 8.1.
 
joe
>>> [EMAIL PROTECTED] 09/17/01 03:50PM 
>>>
Hi 
Folks,
 
In the weekend I will 
migrate my database 8.0.5 to 8.1.7 any steps to follow.
 
Actually Oracle 
8.0.5,
 
- Compaq Proliant 
ML530
- 2 Pentium III 800 MHZ 
processor
- 1 GB 
Memory
- 6 Hard Drives of 9GB = 
54 GB (In a Raid 0 or 5 get confused, all as big disk)
- DLT 20/40 
GB
- 40 
users
 
Want to implement LMT 
tablespace.
 
In the very near future 
want to migrate the applications to web style, Intranet.
 
What products install 
?
 
Is an obligation install 
9i Application Server ?
 
TIA,
 
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
 

RE: Looking for 24 X 7 Design Considerations

[DENNIS WILLIAMS]

Tracy - Is there any possibility of upgrading these databases to Oracle8i,
or even better 9i before you implement 24X7? Oracle is claiming new features
in 9i will support 24X7. I would also imagine that if you could bring all
databases up to the same level, it would be easier to establish policies.
For 7.3.4, you might need to do something entirely different. Also there is
a book "Oracle 24x7 Tips and Techniques" by Venkat S. Devraj, but the
publishing date was 1999, so the information may be dated.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, September 17, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that do
not have a  24x7 restriction.  Now, management is looking to bring in new
products that will need to be 24X7.  They are looking for costs to determine
the viability of such a decision.  I have no 24x7 experience and am looking
for
ideas or options to consider.  [At least initially they are stating there
can
be no downtime for maintenance (upgrades/reorgs)]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tracy Rahmlow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

OT: RE: how to zip email?

[Christopher Spence]

Just create a PST, and then zip that.

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Monday, September 17, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L

Hi all, 

This is not an Oracle question, but thought peoele on
this list might know:

I saved many emails about Oracle, Unix in the
Microsoft Outlook, and I like to send these
information esle where.  I'd like to know where are
these emails stored in the local or network directory,
so I can make a zip.  (NT 4.0, Microsoft Outlook 97).

Thank you!

Andrea


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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: Christopher Spence
  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: Subtract 1 month from current date

[Ramon Estevez]

Hola Ron,

select sysdate, add_months(sysdate, -1) from dual


SYSDATEADD_MONTHS
-- --
17/09/2001 17/08/2001


HTH,

Saludos,

Ramon E. Estevez
[EMAIL PROTECTED]  
Dominican Republic
809-565-3121


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Smith, Ron L.
Enviado el: Monday, 17 September, 2001 10:40 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Subtract 1 month from current date


Can someone tell me how to subtract 1 month from the current date?  Also,
where can I find answers and examples to this type of coding question?

Thanks!
Ron Smith
Database Administrator
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: Ramon Estevez
  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).

READING EXPLAIN PLAN

[Bunyamin K. Karadeniz]

HOw doyou read the explain plan outout ? I format 
it with a script and still do not know how to read it . Which line I must read 
first?The output of my explain plan is below and how do you read this 
output pleASE?
 
OPERATION  
 
OPTIONS    
OBJECT_NAME  
POSITION--   
--   --  
 --SELECT 
STATEMENT  
 
3141  
FILTER 
 1    HASH 
JOIN 
   
OUTER   1  
HASH 
JOIN    
1    HASH 
JOIN  1  
TABLE 
ACCESS  
FULL    
  
K_GD_AB_BINA    
1  HASH 
JOIN  
                
            
 
2    TABLE 
ACCESS    
FULL   
        
BOLUM   
1    HASH 
JOIN      
 
OUTER  
         
    
2  
MERGE JOIN   
   
CARTESIAN    
1    
TABLE ACCESS   BY INDEX 
ROWID 
KODLAR    
 
1  
INDEX      
      RANGE 
SCAN   
IND_KODLAR_KOD_TABLO 
1    
SORT  
         
JOIN   
                
    
2  
TABLE ACCESS     BY INDEX 
ROWID 
KODLAR  
    
1    
INDEX          
    RANGE 
SCAN 
IND_KODLAR_KOD_TABLO    
1  
TABLE ACCESS     
FULL 
      
KADRO_TERFI 
2    TABLE 
ACCESS   
    
FULL   
        
SICIL 
   2  TABLE 
ACCESS 
    
FULL   
        
KADRO_TERFI   

 
Here is my sql .

SELECT T_SICIL.KURUM_SICIL_NO, T_SICIL.AD,T_SICIL.SOYAD, T_SICIL.AYR_TRH, 
T_SICIL.SAKAT_GRB, T_BOL.BIRIMKOD,T_BOL.BOLUMAD AS 
BIRIMI,T_BOL.BOLUMAD2 AS GOREV_YERI, T_BOL.KAT, T_BOL.ODA_NO, 
T_KADRO.DOGUM_YILI, T_KOD.KODACK AS UNVANI,T_KADRO.UNVAN2, 
T_KODG.KODACK, T_KADROG.GOREV,T_SICIL.DOGUM_TRH AS 
DOGUM_TARIHI,T_BOL.BINA_KOD ,T_BINA.BINA_ADI AS BINA
FROM
 KADRO_TERFI T_KADRO, SICIL T_SICIL, BOLUM T_BOL, S_UYAPPERS_KODLAR 
T_KOD, S_K_GD_AB_BINA T_BINA, S_UYAPPERS_KODLAR T_KODG, KADRO_TERFI 
T_KADROG
WHERE
 (T_KADRO.SICIL_NO = T_SICIL.SICIL_NO) AND (T_KADRO.BRM = 
T_BOL.BIRIMKOD )AND (T_KADRO.UNVAN2 (+) = T_KOD.KOD AND 
T_KOD.TABLO = 'UNVAN') AND (T_BOL.BINA_KOD = 
T_BINA.BINA_KODU)AND ((T_KADROG.SICIL_NO = T_SICIL.SICIL_NO) 
AND (T_KADROG.GOREV (+) = T_KODG.KOD AND T_KODG.TABLO = 
'GOREV'))

Migration

[Ramon Estevez]

Hi 
Folks,
 
In the weekend I will 
migrate my database 8.0.5 to 8.1.7 any steps to follow.
 
Actually Oracle 
8.0.5,
 
- Compaq Proliant 
ML530
- 2 Pentium III 800 MHZ 
processor
- 1 GB 
Memory
- 6 Hard Drives of 9GB = 
54 GB (In a Raid 0 or 5 get confused, all as big disk)
- DLT 20/40 
GB
- 40 
users
 
Want to implement LMT 
tablespace.
 
In the very near future 
want to migrate the applications to web style, Intranet.
 
What products install 
?
 
Is an obligation install 
9i Application Server ?
 
TIA,
 
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
 

RE: Subtract 1 month from current date

[Smith, Ron L.]

Thanks Steve!  Didn't know there was such a thing as an unimployed Oracle
DBA.  Good Luck!
Ron

-Original Message-
Sent: Monday, September 17, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L


select add_months(sysdate,-1) from dual;

In the SQL manual.

Steve
unemployed DBA

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 9:40 AM


> Can someone tell me how to subtract 1 month from the current date?  Also,
> where can I find answers and examples to this type of coding question?
> 
> Thanks!
> Ron Smith
> Database Administrator
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   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: Steve Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Pure Name and Address

[Haskins, Ed]

Title: Oracle Pure Name and Address



I 
think it could be part of the Oracle Business Intelligence Suite (ETL: Extract, 
Transform, and Load).  I know Oracle has a feature within such that allows 
for cleaning up names and addresses!!
 
Ed 
Haskins

  -Original Message-From: Adams, Matthew (GEA, 088130) 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 
  2:30 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Oracle Pure Name and Address
  Recently got a 8.1.7 shipment (for hp-ux) and found some CDs I've never seen in an Oracle shipment before 
  Oracle Pure Name & Address (5.5.0.33) Oracle Pure Name & Address (North America) (5.5.0.33) 
  Oracle Pure Name & Address (Europe, Middle East & 
  Africa , Asia Pacific, and Latin America) 
  (5.5.0.33) Oracle Geocode (US Data) (5.5.0.33) 
  
  Anybody familiar with this stuff?  
  (I could just drop it in the CD-ROM but I don't have time 
  at the moment.) 
  Matt Adams GE Appliances 

RE: Way off topic - Volunteering

[Gogala, Mladen]

Please, let me know if you find a way. I am an Oracle DBA which lives
in southern Connecticut, cca 1.5 hours away from the Grand Central station
by train from Bridgeport, CT. Despite my reluctance to use I95, this is an 
option too, during the weekends. I can volunteer my time on weekends and 
my private email address is:[EMAIL PROTECTED] I can backup, recover, 
optimize,  install or do almost anything with a Unix instance or a cluster
of 
those. For the detailed information, please drop me an email. Once again,
this
is meant as a help for those affected by the WTC disaster and is completely 
free.

> -Original Message-
> From: Kevin Bachelder [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 10:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Way off topic - Volunteering
> 
> 
> Hi everyone,
> 
> I am looking to find a way to volunteer my time to assist 
> non-profits or 
> similar organizations that need technical assistance or maybe be a 
> technical tutor or resource at a community center, etc.  I knows this 
> sounds crazy but my early attempts to find these 
> opportunities near my 
> local community have come up empty.  Does anyone have any 
> suggestions on 
> how they have gone about this or similar things.
> 
> Take care,
> 
> Kevin
> 
> --
> Kevin Bachelder
> 
> Microsoft Certified Systems Engineer - Windows NT 4.0 (MCSE)
> Microsoft Certified Professional - Windows 2000 (MCP)
> Citrix Certified Administrator (CCA)
> CompTIA A+ Certified Computer Repair Technician (A+)
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kevin Bachelder
>   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: Gogala, Mladen
  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: test schema from prod

[Ron Rogers]

Raghu,
 That depends on what you call fast and how big your database is. I created a test 
environment on a Linux box Oracle 8.1.7 and I decided to use LMT for the tablespace. 
The data consists of 8 years worth of data (72 GIG). The data tables were small 4K to 
large 8 GIG. Some of them are dynamic amd some static. It took the better part of a 
week to calculate the LMT datafile size and which table went in which datafile for 
maximun efficiency. The actual data load took another week using "insert into .. 
select" across a network.
If you can build the new database and use export/import.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 09/17/01 11:35AM >>>

Hi Friends,

I want to create test schema from my production database, What is best way 
to do that!! Any ideas or ways to create test schema fast!! I appreciate 
your time.


TIA
Raghu.




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Raghu Kota
  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: Ron Rogers
  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: test schema from prod

[Steve Smith]

Refer to doc 135651.1 on metalink.  How to Make a Copy of an Open Database
on the Same Machine.

I have used that method many times.  It works great.

Steve

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 11:10 AM


> import fromuser touser?
>
> -Original Message-
> Sent: Monday, September 17, 2001 10:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi Friends,
>
> I want to create test schema from my production database, What is best way
> to do that!! Any ideas or ways to create test schema fast!! I appreciate
> your time.
>
>
> TIA
> Raghu.
>
>
>
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Raghu Kota
>   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: Smith, Ron L.
>   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: Steve Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

trace files

[Boivin, Patrice J]

A developer here claims that he can only generate one trace file per day.

Even if he logs out and then back onto Oracle.

Oracle 8.1.7.2.1 on NT.

Does this make any sense?

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.com
--
Author: Boivin, Patrice J
  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: test schema from prod

[DBarbour]

Restore a backup of your production DB to another box and rename it.  Great
practice for recovery as well.  If you need help renaming the DB after
you've got it restored (big hint - create controlfile), let us know.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
"Raghu Kota"   
   
  
mail.com>cc:   
   
Sent by: Subject: test schema from prod
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
09/17/2001 
   
10:35 AM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   





Hi Friends,

I want to create test schema from my production database, What is best way
to do that!! Any ideas or ways to create test schema fast!! I appreciate
your time.


TIA
Raghu.




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: how to zip email?

[Jack C. Applewhite]

Andrea,

Search for the file outlook.pst.  That's the single file in which Outlook
stores all emails, notes, addresses, everything.  It's a pain, but what do
you expect from Micros**t.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068


-Original Message-
Oracle
Sent: Monday, September 17, 2001 12:15 PM
To: Multiple recipients of list ORACLE-L


Hi all,

This is not an Oracle question, but thought peoele on
this list might know:

I saved many emails about Oracle, Unix in the
Microsoft Outlook, and I like to send these
information esle where.  I'd like to know where are
these emails stored in the local or network directory,
so I can make a zip.  (NT 4.0, Microsoft Outlook 97).

Thank you!

Andrea

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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: Renaming GLOBAL_NAME

[Scott Canaan]

I always issue an update statement to change it, when I clone instances:

update global_name
set global_name = 'SIMSNT7B';

commit;

This works every time.

[EMAIL PROTECTED] wrote:

> Hi All,
>
> I am trying to rename the global_name from SIMSNT7B.WORLD to SIMSNT7B.
>
> I issued the following command to change the global_name.
>
> ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;
>
> Still it is showing SIMSNT7B.WORLD when I query the global_name view.
> SQL> select * from global_name;
>
> GLOBAL_NAME
> --
> SIMSNT7B.WORLD
>
> Values for the following parameters in v$parameter view,
> GLOBAL_NAMES  parameter value is FALSE and DB_DOMAIN parameter value is
> NULL.
> We are not using Oracle Names server.  I renamed SQLNET.ORA file in
> network\admin location.
> Init.ora file has global_names set to false.
>
> How do I change to SIMSNT7B?  This database is on Windows NT and it is
> 8.1.6.
>
> Thanks in advance for your help.
>
> Best regards
> Prasad
>
> --
> 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).

--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  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: Looking for 24 X 7 Design Considerations

[Sandi . McClary]

What is SLA?
How are you doing trending?



   
 
Christopher
 
Spence   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>
Subject: RE: Looking for 24 X 7 Design 
Considerations  
Sent by:   
 
root@fatcity.  
 
com
 
   
 
   
 
09/17/01   
 
11:00 AM   
 
Please 
 
respond to 
 
ORACLE-L   
 
   
 
   
 




In my opinion, one of the biggest things with 24x7 is planning.
Documenting
what is normal maintenance either it be for your application or for the
database itself.  This means finding out how often normal maintenance
(index
rebuilds, re-orgs, data loads) runs, and how long.  This is a good step
regardless if the shop is 24x7, this way you know at all times what is
needed and when.

Then you need to determine which systems are critical to the success of the
application, i.e. database, backups, hubs and such.  Then I would work on a
solution that will provide redundancy for these devices.  One thing I like
to do is make a list of all types of failure, and then my expected results,
and time frame of recovery.  Then I would consult with management and
determine which are acceptable and which are not.

I cannot stress the usefulness of SLA's, either to a customer or to a
department (generally it is good to have both).  This will give you a
baseline you must follow.  If you have something that takes 10 seconds, and
you say it must be faster than 15 seconds, and one day it becomes 11 or 12,
you have a good idea how things are going and can take measures.  Finding
important areas where you attach a metric.

Another thing to be concerned with, and which can be a life saver is
trending.  This is very important in 24x7 environments so you can say "Ok,
in 6 months we are going to add 50Gb and a second tape drive, this is going
to cost $10,000 and will take 6 hours of time.".

In a 24x7 environment the best thing is to already know the problem.  It is
the problems that come up unexpectantly that make things very difficult.
Preparation and planning is critical to 24x7 environments.  Knowing what
can
happen and what you will do to resolve it ahead time can be a big
difference.

Hope this helps,

"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863



-Original Message-
Sent: Monday, September 17, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L

We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that
do
not have a  24x7 restriction.  Now, management is looking to bring in new
products that will need to be 24X7.  They are looking for costs to
determine
the viability of such a decision.  I have no 24x7 experience and am looking
for
ideas or options to consider.  [At least initially they are stating there
can
be no downtime for maintenance (upgrades/reorgs)]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
  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 containi

Re: Subtract 1 month from current date

[JOE TESTA]

do u want to see the 17th of aug as your answer?
 
joe
>>> [EMAIL PROTECTED] 09/17/01 11:40AM >>>Can 
someone tell me how to subtract 1 month from the current date?  
Also,where can I find answers and examples to this type of coding 
question?Thanks!Ron SmithDatabase 
Administrator[EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com-- Author: 
Smith, Ron L.  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
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).

RE: Looking for 24 X 7 Design Considerations

[Kevin Tsay]

Tracy:

There's a book "Oracle 24X7" by Oracle Press Author : Venkat S. Devraj ISBN
: 0-07-211999-3
could be your good start point & reference.

Kevin

-Original Message-
Rahmlow
Sent: Monday, September 17, 2001 8:15 AM
To: Multiple recipients of list ORACLE-L


We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that do
not have a  24x7 restriction.  Now, management is looking to bring in new
products that will need to be 24X7.  They are looking for costs to determine
the viability of such a decision.  I have no 24x7 experience and am looking
for
ideas or options to consider.  [At least initially they are stating there
can
be no downtime for maintenance (upgrades/reorgs)]


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tracy Rahmlow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Tsay
  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: Subtract 1 month from current date

[Koivu, Lisa]

Title: RE: Subtract 1 month from current date





Hi Ron, 


Here it is


(INV.WORLD-SYSTEM)>select add_months(sysdate,-1) from dual;


ADD_MONTH
-
17-AUG-01


For conversions, etc. it's best to study the sql*plus doco.  In fact I had to visit this exact chapter this morning to refresh my memory of date formats and date functions.  I used to have a crib sheet i got in dba class that showed every single conversion format and sql*plus function (like add_months()) but I think I loaned it out and it never returned...

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   Smith, Ron L. [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, September 17, 2001 11:40 AM
To: Multiple recipients of list ORACLE-L
Subject:    Subtract 1 month from current date


Can someone tell me how to subtract 1 month from the current date?  Also,
where can I find answers and examples to this type of coding question?


Thanks!
Ron Smith
Database Administrator
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: ORA-04030 error

[Mercadante, Thomas F]

BigP,
 
Have 
you increased your Shared_Pool_Size param?
 
Stored 
procedures live in the Shared Pool.  Maybe you shared pool is too 
small.
 
Increase it, and try your import 
again.
 
LittleT
 
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Big Planet 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 
  1:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: ORA-04030 error
  Yes .
  
- Original Message - 
From: 
Jeram 
To: Multiple 
recipients of list ORACLE-L 
Sent: Sunday, September 16, 2001 8:10 
PM
Subject: Re: ORA-04030 error

Have applied oracle Patch set for 
8.1.7.?
 
Rgds/jeram

  -Original Message-From: 
  Big Planet <[EMAIL PROTECTED]>To: 
  Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: 
  Saturday, September 15, 2001 8:13 AMSubject: ORA-04030 
  error
  Hi All 
  ,
  I am getting this error 
  ORA-04030  out of memory when 
  importing in 8.1.7 Solaris 8 .  There is no data in import it is just 
  empty tables and stored procs .The error comes with one stored proc 
  .
  Any Idea how this can be solved 
  .
   
  TIA ,
  -BigP
   

Re: Looking for 24 X 7 Design Considerations

[Don Granaman]

That is going to be really tough - especially for 7.3.4.  Absolutely "no
downtime" for anything - including Oracle, OS, application, etc. patches and
upgrades isn't feasible unless you simply prohibit them.

There are a lot of good white papers out there that talk about basic concepts
and the pros/cons of specific technological solutions.  One such recently
revised "primer" is: http://www.evergreen-database.com/TD_HA.doc

The closest you can come to 24 x forever is with parallel server, but even that
isn't 100% - and it will require VERY serious planning - for everyone involved -
DBA, SA, app dev, etc.  With 8i, you can come a lot closer.  TAF with 8i OPS
helps a lot.

I'm most familiar with Sun, Veritos, EMC, and Oracle.  I'm not familiar with IBM
HACMP.  Isn't it essentially a "takeover" solution - similar to, for example,
Veritos HA cluster?  Any "HA" solution will have a little more downtime in the
event of a failure than a well-designed OPS solution - you have to remount
volumes, start a new instance, etc.  In addition, client failover to the HA
"survivor" generally requires more explicit action by the clients.

There are two core technical considerations in Oracle availability - instance
failure and database failure.  (Disaster recovery scenarios might be considered
a special case of both - with additional considerations like complete site
failure).  OPS and HA clusters address instance failure, but not database
failure or site failure.  Standby databases, geomirroring, backups, etc. address
database failure, but are poor true "high availability" solutions.  There is no
realistic possibility of obtaining 100% uptime with only a standby database.
Advanced replication is a bit of a special case - it may address both modes of
failure, but has major application design and performance constraints.  In
reality, any expectation of 100% uptime for all possible failure scenarios is
simply unrealistic - for any technology or hybrid of technologies.  The best
possible solution will require hybrids of technologies.  (e.g. Perhaps an 8i/9i
OPS cluster, TAF, standby database, EMC SRDF to synchronously mirror redo log
files and archive log dest, DR site, and all the other required supporting
infrastructure and procedures.)

The often mentioned "five nines" (99.999% availability) is MUCH more often
touted and claimed than actually attained.  (Real life example:  One claimed
"high availability" solution at a large insurance company consisted of only cold
hardware, a powered off spare server sitting next to the primary - with no
cluster or automation software at all!  The intent was simply to plug the array
into the spare if the primary failed.  Availability - yes.  "High"?  No!)  True
"high availability" is neither easy nor cheap.  The toughest part of the job is
usually in getting realistic requirements and building realistic expectations.
The most critical questions are: "How much data can you afford to lose?", "How
long can you afford to be down?", and "How much can you afford to spend?".  The
first two (at least) need to be considered in each of many possible failure
scenarios.

-Don Granaman
[OraSaurus - Honk if you remember UFI!]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 10:15 AM


> We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that do
> not have a  24x7 restriction.  Now, management is looking to bring in new
> products that will need to be 24X7.  They are looking for costs to determine
> the viability of such a decision.  I have no 24x7 experience and am looking
for
> ideas or options to consider.  [At least initially they are stating there can
> be no downtime for maintenance (upgrades/reorgs)]


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: dba_waiters.lock_type = "Disk Space Transaction" - significan

[Gogala, Mladen]

Did you try going to v$session_wait for the waiting sessions and see
what event exactly are they waiting for? There are brief descriptions of
most of the events on metalink . The other good source for version 7
is Anjo Kolk's paper.

-Original Message-
Sent: Friday, September 14, 2001 11:30 PM
To: Multiple recipients of list ORACLE-L



I have a background process running that's doing an analyze on tables, and
storing the information in another table. The table in which it's trying to
store information has currently reached the maximum number of extents (I'm
doing a test to see how the background job handles ORA- errors, so far not
very gracefully.)

Now other sessions are "stuck" behind the one session doing the analyze.
What could be the causes for this lock_type? ("disk space transaction")

Oracle 8.1.7 - Windows 2000 

SQL> select * from dba_waiters ; 

WAITING_SESSION HOLDING_SESSION LOCK_TYPE 
--- --- -- 
MODE_HELD 
 
MODE_REQUESTED 
 
LOCK_ID1 
 
LOCK_ID2 
 
 12  21 Disk Space Transaction 
Exclusive 
Exclusive 
0 
0 

 17  21 Disk Space Transaction 
Exclusive 
Exclusive 
0 
0 

 20  21 Disk Space Transaction 
Exclusive 
Exclusive 
0 
0 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  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: test schema from prod

[Schoen Volker]

export schema/import new schema (fromuser= touser=)

regards

Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de



-Ursprüngliche Nachricht-
Von: Raghu Kota [mailto:[EMAIL PROTECTED]]
Gesendet: Monday, September 17, 2001 5:35 PM
An: Multiple recipients of list ORACLE-L
Betreff: test schema from prod



Hi Friends,

I want to create test schema from my production database, What is best way 
to do that!! Any ideas or ways to create test schema fast!! I appreciate 
your time.


TIA
Raghu.




_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Raghu Kota
  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: Schoen Volker
  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).

Using CLOB

[Yuval Arnon]

Title: Using CLOB





Hi,
How can you assign a text to a CLOB column defined in the DECLARE section of PL/SQL.I am getting an error on wrong type.

i.e..


SQL> l
  1  declare
  2  c clob ;
  3  BEGIN
  4  c := 'This is a test';
  5* END;
SQL> /
c := 'This is a test';
 *
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00382: expression is of wrong type
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored


Yuval Arnon

as a reminder

[JOE TESTA]

Off topic posts are not supposed to be on the [EMAIL PROTECTED] list anymore.
 
if you want to post OT list, feel free to join the [EMAIL PROTECTED] 
list.
 
instructions follow:
 


  
  
Post message:
[EMAIL PROTECTED]
  
S_u_b_s_c_r_i_b_e: 
[EMAIL PROTECTED]
  
U_n_s_u_b_s_c_r_i_b_e: 
[EMAIL PROTECTED]
  
List owner: 

  [EMAIL PROTECTED]
 

Re: Subtract 1 month from current date

[Steve Smith]

select add_months(sysdate,-1) from dual;

In the SQL manual.

Steve
unemployed DBA

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 9:40 AM


> Can someone tell me how to subtract 1 month from the current date?  Also,
> where can I find answers and examples to this type of coding question?
> 
> Thanks!
> Ron Smith
> Database Administrator
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   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: Steve Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-1410 on interMedia Text Index - SOLVED

[Jack C. Applewhite]

Hi,

Just a follow-up for you interMedia Text fans out there.

The statement below worked for us to eliminate the ORA-1410 and ORA-600
[12700] errors.

   Alter Table DR$$R table to Cache Reads for its Data LOB column.  Metalink Bug
1668041 indicates that changing Cache Reads to just Cache for the DR$...$R
table solved the problem for an 8.1.7. WinNT DB.

Has anyone else experienced this?  I'm rebuilding the index now (for the 2nd
time this week! - takes 7.25 hours) and want to know if this fix will work.

Thanks for any advice or suggestions.

Jack


Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  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).

how to zip email?

[Andrea Oracle]

Hi all, 

This is not an Oracle question, but thought peoele on
this list might know:

I saved many emails about Oracle, Unix in the
Microsoft Outlook, and I like to send these
information esle where.  I'd like to know where are
these emails stored in the local or network directory,
so I can make a zip.  (NT 4.0, Microsoft Outlook 97).

Thank you!

Andrea


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrea Oracle
  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: veritas backupexec horribly slow on one NT server

[Jack C. Applewhite]

Jeffrey,
 
What version(s) of Oracle?  Are you 
using RMan?

We use Veritas NetBackup Data Center 3.4GA because our colocation facility 
supplies it.  We run Oracle8i 8.1.6 under 
Win2k (dual 500MHz CPUs, 2GB RAM) and see in the neighborhood of 300MB/min ( 
about 200GB of backup in about 10 hrs), using RMan to feed the hot backup files 
to the Veritas tape server.  That's with nightly batch processes running 
against that database as well.  This rate is pretty much "out of the box", 
since I've not tried to tune or optimize it in any way.
Jack
Jack C. ApplewhiteDatabase 
Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, 
Texaswww.iNetProfit.com[EMAIL PROTECTED](512)327-9068

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Jeffrey BeckstromSent: 
  Monday, September 17, 2001 10:35 AMTo: Multiple recipients of list 
  ORACLE-LSubject: veritas backupexec horribly slow on one NT 
  server
  Running backupexec 7.3 on 5 database servers.  4 of 5 run at 40-50 
  M/minute.  One is running at only 20 M / minute.  weird thing is 
  that the slow one is running on our fastest box (2 - 1000 MHz 
  processors).  Any ideas.  Veritas just says that the database is 
  slow.  While this is a development instance with all users currently 
  locked out.
   
  Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional 
  Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 
  781-4204

Oracle Pure Name and Address

[Adams, Matthew (GEA, 088130)]

Title: Oracle Pure Name and Address





Recently got a 8.1.7 shipment (for hp-ux) and
found some CDs I've never seen in an Oracle
shipment before


Oracle Pure Name & Address (5.5.0.33)
Oracle Pure Name & Address (North America) (5.5.0.33)
Oracle Pure Name & Address (Europe, Middle East & Africa
, Asia Pacific, and Latin America) (5.5.0.33)
Oracle Geocode (US Data) (5.5.0.33)


Anybody familiar with this stuff?  


(I could just drop it in the CD-ROM but I don't have time 
at the moment.)


Matt Adams
GE Appliances

Re: Renaming GLOBAL_NAME

[Paul Baumgartel]

I don't think you can do this.  GLOBAL_NAME by definition consists of
the database name and database domain, which defaults to WORLD.

Paul Baumgartel

--- [EMAIL PROTECTED] wrote:
> 
> Hi All,
> 
> I am trying to rename the global_name from SIMSNT7B.WORLD to
> SIMSNT7B.
> 
> I issued the following command to change the global_name.
> 
> ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;
> 
> Still it is showing SIMSNT7B.WORLD when I query the global_name view.
> SQL> select * from global_name;
> 
> GLOBAL_NAME
> --
> SIMSNT7B.WORLD
> 
> Values for the following parameters in v$parameter view,
> GLOBAL_NAMES  parameter value is FALSE and DB_DOMAIN parameter value
> is
> NULL.
> We are not using Oracle Names server.  I renamed SQLNET.ORA file in
> network\admin location.
> Init.ora file has global_names set to false.
> 
> How do I change to SIMSNT7B?  This database is on Windows NT and it
> is
> 8.1.6.
> 
> Thanks in advance for your help.
> 
> Best regards
> Prasad
> 
> 
> -- 
> 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).


__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  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: Way off topic - Volunteering

[Jessie_Yau]

Kevin,
 I received following information from a different listserv and hope it
helps:
For information on how to offer IT assistance or support to businesses in
New York's World Trade Center, please visit our Web site at
www.computerworld.com  , where you can
register to help through our IT Volunteers database (click on the red
Volunteer IT banner). If your services are needed by businesses affected by
Tuesday's attack, you will be contacted.

Jessie


   
   
Kevin Bachelder
   
   <[EMAIL PROTECTED]>
   
Sent by: cc:   
   
[EMAIL PROTECTED] Subject: Way off topic - Volunteering 
   
   
   
   
   
09/17/2001 07:10   
   
AM 
   
Please respond to  
   
ORACLE-L   
   
   
   
   
   




Hi everyone,

I am looking to find a way to volunteer my time to assist non-profits or
similar organizations that need technical assistance or maybe be a
technical tutor or resource at a community center, etc.  I knows this
sounds crazy but my early attempts to find these opportunities near my
local community have come up empty.  Does anyone have any suggestions on
how they have gone about this or similar things.

Take care,

Kevin

--
Kevin Bachelder

Microsoft Certified Systems Engineer - Windows NT 4.0 (MCSE)
Microsoft Certified Professional - Windows 2000 (MCP)
Citrix Certified Administrator (CCA)
CompTIA A+ Certified Computer Repair Technician (A+)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Bachelder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: How to subtract 1 from current month

[schmoldt]

Use the ADD_MONTHS function:

ADD_MONTHS(sysdate,6) adds 6 months to the current date.

ADD_MONTHS(sysdate,-1) subtracts 1 month from the current date.

Dave

> -Original Message-
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 11:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How to subtract 1 from current month
> 
> 
> I am trying to find coding examples of date functions.  I 
> need to subtract 1
> from the current month.  Can anyone tell me where to find this type of
> coding examples?
> 
> Ron Smith
> Database Administrator
> [EMAIL PROTECTED]
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Smith, Ron L.
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Subtract 1 month from current date

[DBarbour]

Ron,

The only problem you might have here is in defining what is a 'month.'  Is
it 30 days, 31 days, 28 days or 29 days?  Other wise it's quite simple -

 Select (sysdate - 30) from dual;<== parentheses are not necessary,
I tend to include them for clarity.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
"Smith, Ron
   
L."  To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]   cc:   
   
om>  Subject: Subtract 1 month from current 
date  
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
09/17/2001 
   
10:40 AM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Can someone tell me how to subtract 1 month from the current date?  Also,
where can I find answers and examples to this type of coding question?

Thanks!
Ron Smith
Database Administrator
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Renaming GLOBAL_NAME

[Prasada . Gunda1]

Hi All,

I am trying to rename the global_name from SIMSNT7B.WORLD to SIMSNT7B.

I issued the following command to change the global_name.

ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B;

Still it is showing SIMSNT7B.WORLD when I query the global_name view.
SQL> select * from global_name;

GLOBAL_NAME
--
SIMSNT7B.WORLD

Values for the following parameters in v$parameter view,
GLOBAL_NAMES  parameter value is FALSE and DB_DOMAIN parameter value is
NULL.
We are not using Oracle Names server.  I renamed SQLNET.ORA file in
network\admin location.
Init.ora file has global_names set to false.

How do I change to SIMSNT7B?  This database is on Windows NT and it is
8.1.6.

Thanks in advance for your help.

Best regards
Prasad


-- 
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: Select question

[Steve Smith]

The "distinct" can't be in the middle of the expression.  "Distinct" must be
at the beginning..

Try

Select distinct 'Testing ' || (to_char(mydate, 'MON')) from mytable;

Steve

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 2:35 AM


> Hi all,
>
>
> Why I can't do this ?
>
>
> Select 'Testing ' || distinct(to_char(mydate, 'MON')) from mytable;
>
>*
> ERROR at line 1
> ora-00936: missing expression
>
>
> it is work if I do
>
> Select distinct(to_char(mydate, 'mon')) || ' testing' from mytable;
>
> WHY ??
>
>
>
>
> Best Regards
>
> Sinardy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sinardy
>   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: Steve Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Subtract 1 month from current date

[Scott Canaan]

select add_months(sysdate,-1) from dual;

Check the sql and pl/sql manuals.  You should have a cd with them on that you
can load onto your pc.

"Smith, Ron L." wrote:

> Can someone tell me how to subtract 1 month from the current date?  Also,
> where can I find answers and examples to this type of coding question?
>
> Thanks!
> Ron Smith
> Database Administrator
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   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).

--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  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: Subtract 1 month from current date

[Brian McGraw]

SELECT ADD_MONTHS(SYSDATE,-1) FROM DUAL;

Brian

"Smith, Ron L." wrote:

> Can someone tell me how to subtract 1 month from the current date?  Also,
> where can I find answers and examples to this type of coding question?
>
> Thanks!
> Ron Smith
> Database Administrator
> [EMAIL PROTECTED]
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Smith, Ron L.
>   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).

--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]  |
| http://bmcgraw.home.mindspring.com |
--


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brian McGraw
  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: migration from RBO to CBO

[Christopher Spence]

ALL_ROWS is not always good for OLTP, is this an OLTP environment?  Perhaps
FIRST_ROWS is better, perhaps not.

I would recommend sticking with CBO, properly tuned, it is generally faster
in all cases, although you sometimes have to use hints to make up for an
incorrect plan choice.  Like you said, a lot of the new features truly
benefit from Cost based optimization.

Plan stability and outlines are a good idea if you feel you have good plans
and you do not want them to change, but a lot of times you may want them to
chance as data grows, especially when it is unexpected.

Make sure you look at the INDEX_ parameters which drastically increase the
effectiveness of the CBO.  Also be concerned with parameters like
DB_FILE_MULTIBLOCK_READ_COUNT which also affect which path CBO takes.

I would recommend using DBMS_STATS instead of Analyze table due to parallel
use and bugs.  You may want to also consider 'monitor' feature of tables to
assist in determining stale statistics with DBMS_STATS and get a good idea
of usage.  When and how often plays a big factor in how you do statistics.
In a smaller environment, you have more lead way, in the larger environments
your decisions become more difficult.

I generally try to use hints as a last resort only, although they are needed
in times, not always.  One interesting trick is to force the database into
RBO and capture outlines, then switch to CBO and use statistics, then you
have certain plans saved so you have the effect of using RBO for them.


"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence 
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-Original Message-
Sent: Saturday, September 15, 2001 3:00 PM
To: Multiple recipients of list ORACLE-L

Hi List,

I'm going to change my job and I'll have to inherite one DB which doesn't
seem to be very good
designated. I haven't known much about the application yet and I can't post
many details to you but
I would appreciate your general advices.

Despite of the optimizer_mode set to RULE at instance level, they use many
new features
(partitioning, bitmap indexes, function-based indexes, etc). It seems the
system is overloaded with
indexes and optimizer hints. They collect statistics regularly. Molotov's
cocktail! So I expect some
hybrid behaviour of the optimizer. The sql statements don't seem to be
especially optimized for RBO
and give real trouble for system (my first feeling).

Before we could start any sql tuning we have to decide which road to choose.
My current
understanding is that we need to fix existing execution plans with 'Plan
Stability' option and set
optimizer_mode = all_rows. Then ask the developers to use CBO in new
development and gradually test
and rewrite existing code. What would be your advice? Any experience?

Also I would like to know if anybody use the 'plan stability' feature. Is it
stable itself ? :) The
system is 8.1.7.0.1 on Red Hat

Thanks,
Ed
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  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: Christopher Spence
  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: ORA-04030 error

[Big Planet]

Title: Message



Doesn't affect .
 

  - Original Message - 
  From: 
  Walthour, 
  Jon (GEAE, Compaq) 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Saturday, September 15, 2001 7:00 
  AM
  Subject: RE: ORA-04030 error
  
  Big:
   
  Try 
  increasing the buffer_size parameter on the import to 1 
mb.
   
  Jon 
Walthour
  

-Original Message-From: Big Planet 
[mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 
9:40 PMTo: Multiple recipients of list 
ORACLE-LSubject: ORA-04030 error
Hi All 
,
I am getting this error 
ORA-04030  out of memory when importing 
in 8.1.7 Solaris 8 .  There is no data in import it is just empty 
tables and stored procs .The error comes with one stored proc 
.
Any Idea how this can be solved 
.
 
TIA ,
-BigP