RE: Urgent PDF to TXT Convert
It might be irrelevant but Ghostgum can read pdf and convert to prn and maybe to txt and it is free. -Original Message- Sent: Friday, January 10, 2003 11:59 To: Multiple recipients of list ORACLE-L Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle locale builder.
Dear All, I am trying to create a new character set using the Oracle locale builder tool. When i use as a basis character set EL8ISO8859P7 then the new character set is created as expected to be. However when I use as basis the AL32UTF8 it is not created giving me an error : NLB access for this character set is not supported in this release. Is there a patch that must be applied? Current version 9.2.0.1 > Kind Regards, > > > Hatzistavrou Yannis > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hatzistavrou Giannis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: protocol.ora
I believe that this functionality is now (i.e. 8.1.7 )encapsulated into CMAN -Original Message- Sent: Monday, April 15, 2002 11:58 To: Multiple recipients of list ORACLE-L Hi I tried this however I get the same result as in it doesn't allow any connections at all..even IP addresses which are included in the .protocol.ora file. Regards Saj Iqbal On Fri, 12 Apr 2002, Jeremiah Wilton wrote: > If you trace the listener you will see that it is looking for > .protocol.ora with a leading period. This is a documented bug. Just > copy protocol.ora to .protocol.ora. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Fri, 12 Apr 2002, Sajid Iqbal wrote: > > > We used to use the protocol.ora file to restrict access to the database, > > on oracle 8.0.5 > > > > However since moving to Oracle 8.1.6.3 this doesn't work. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > 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: Sajid Iqbal 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: subtract minute from date/time
I know that if you have a date field then you can get the hour using the formula /60/60/24 thus to get the minutes will be /60/60 -Original Message- Sent: Thursday, April 11, 2002 14:08 To: Multiple recipients of list ORACLE-L I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: EXPORT FAST?
Look at http://www.oriole.com for PDQOUT. It might be what you need at a low cost. -Original Message- Sent: Tuesday, March 26, 2002 21:29 To: Multiple recipients of list ORACLE-L Also look into the option BUFFER in export. Srini -Original Message- Sent: Tuesday, March 26, 2002 10:59 AM To: Multiple recipients of list ORACLE-L I think you can use direct=y option. Are you taking this export to a file (over disk) or directly to tape? Greeting Diego Cutrone - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 3:13 PM > Hi > one of export for 35GB database is taking 12 hours.How to reduce this export > time. > Thx > Seema > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone 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). -- 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: ORACLE TUNING
hi Srini, Why don;t you use stored outlines. -Original Message- Sent: Tuesday, March 19, 2002 20:18 To: Multiple recipients of list ORACLE-L Hello: I have an identical query that has similar explain plan on both Prod and Dev environment, only difference being that certain indexes are performing unique scan on Prod and Range scan on Dev. Can you cast some light on how this can be matched and under what conditions this discrepancy might occur. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
testing -- NO MESSAGE
> Kind Regards, > > > Hatzistavrou Yannis > > > -- 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: SAME, WAFL and RAID
May I please have a copy of this paper? Thanks -Original Message- Sent: Wednesday, January 16, 2002 00:38 To: Multiple recipients of list ORACLE-L Hi, WAFL is Write Anywhere File Layout... Its the file lay out used by snapshot supported storege Devices(NetApp Storege Etc), This is completely different from a RAID. A RAID is a system which may or maynot be h/w controlled. But WAFL is the Low level file layout of the Storege system. In any one wants i hv the paper or Hutchinston with me on WAFL which i can give u Regards OraEtM!! _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eswar the MAD 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: Database block changes
I believe the best way to go about it , is using the logminer! -Original Message- Sent: Friday, January 11, 2002 12:10 To: Multiple recipients of list ORACLE-L Hi all, Can anybody help me with how to know that the data blocks in a particular database have changed since a particular time ?? Thanks, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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: temporary tablespace estimation.
FYI. as far as temporary tablespace estimation is concerned I have found 28365.1 in Metalink. -Original Message- Sent: Wednesday, December 19, 2001 13:16 To: Multiple recipients of list ORACLE-L Hatzistavrou Giannis wrote: > > Dear All, > > I have the following questions to make: > > a) In a select statement where there is no order by or group by clause but > parallel query servers are used, do these servers use temporary tablespace > segments? Quite likely, if the volume requires it. 'Temporary space', as the name indicates, holds data in the course of processing, before Oracle is able to reach the final result. With parallel query servers, each one fetches a partial result set, which has to be stored somewhere before everything is merged. Even if you have no 'sort', you have a 'merge' phase. If that's you were thinking of, I do not believe that you get results on the fly from each of the parallel query servers, it would make communications much too complicated between the client and the server side. When you issue a 'fetch' call, you expect it from a single source and everything needs to be streamlined somewhere. > b) how can someone estimate the temporary space used having only the select > statement? I wonder! -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
temporary tablespace estimation.
Dear All, I have the following questions to make: a) In a select statement where there is no order by or group by clause but parallel query servers are used, do these servers use temporary tablespace segments? b) how can someone estimate the temporary space used having only the select statement? > Kind Regards, > > > Hatzistavrou Yannis > > > -- 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).
select and rollback
Dear All, I have a select statement that when runs it complains about limited rollback segment extents. Do selects use rollback? Regards -- 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).
stored outlines + remote db access
Dear All, We have an application that was performing very bad when we migrated a remote database from 7.3.4.40 to 8.1.6.3.0. SInce we do not have time to tune all queries issued by the application we thought that stored outlines is the way to go. The application connect tos the remote side throught database links. We have created a trigger upon login of a specific user on remote site that actually alters the session to use the outlines. However nothing happens (i.e the trigger executes correctly but stored outlines are not used). Your insight views will be greatly appreciated. Thanks, Hatzistavrou Yannis Telco Analyst -- 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: Perl code example
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 " <http://parietal.corpdc.epocrates.com/cgi-bin/staging/productionDater_dev0
> 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 " <http://parietal.corpdc.epocrates.com/cgi-bin/staging/productionDater_dev0
> 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
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: 9i NT
Old behavior especially in W2K with Oracle 8.1.6.0 (solved by 8.1.7.0). Regards, Hatzistavrou Yannis > -Original Message- > From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 30, 2001 16:56 > To: Multiple recipients of list ORACLE-L > Subject: 9i NT > > Just thought I would mention this interesting little feature. Now I don't > know if I am an idiot or if something went wrong (probably both), but > apparently NT services will not start the instance. I had to manually > start > it to get it to go? I guess in a way that's good, move little nt people > like me away from the GUI tools:) > > Sincerely, > Kevin Kostyszyn > DBA > Dulcian, Inc > www.dulcian.com > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kevin Kostyszyn > 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: !! *Very* important Oracle-L message !!
its, at least I will have known I did my best to make > it > succeed, and I did so without having to reneg on committments I had > made in the past. > > I am being open and honest with everyone because I believe that this is > the > best way to succeed. I believe you appreciate this kind of approach, and > I > want you to know that regardless of what happens, I certainly appreciate > every consideration you give this request. Whether or not this succeeds, > I > know that you are a great group of people and I wish this list the best > luck > in this life, or the next. :-) > > Remember, time is of the essence. The sooner I hear from people who > can help, the sooner I can nail down a line of approach. If you have any > questions or concerns, please E-mail me. > > Thanks everyone! > > Bruce Bergman > President, Fat City Network Services > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Migration of simple snapshots
In your case, i would have used offline instantiation. Have a look at the replication manual! Cheers > -Original Message- > From: Mike J Kurth [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, August 28, 2001 18:51 > To: Multiple recipients of list ORACLE-L > Subject: Migration of simple snapshots > > I use simple snapshots, and have some questions regarding migration from > 7.3.4.5 > to 8.1.6.2: > 1) Can a 8.1.6.2 master site co-exist with a 7.3.4.5 snapshot site? > 2) After I migrate master site I need to drop triggers on the mlogs, > because > 8I does not use database triggers to populate the mlogs? > 3) Do I need to do a complete refresh of each snapshot after the master >migration? Any way around this? > 4) Do I need to convert my rowid snapshots to primary key snapshots? > 5) Any other issues I need to be aware of? > > Thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mike J Kurth > 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: Intermedia Questions, Any Gurus on This Subject?
There is a wealth of docs regarding this issue in OTN also check http://www.oracle.com/products/intermedia > -Original Message- > From: Oracle DBA [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 19, 2001 15:11 > To: Multiple recipients of list ORACLE-L > Subject: Intermedia Questions, Any Gurus on This Subject? > > Help anybody, version 8.1.6.3 on UNIX > > 1. Storage clause of an intermedia index build. How > to specify the buffer pool to KEEP or CACHE the index? > > 2. How to specify the tablespace for such a DOMAIN > index. When put in tablespace clause, says its invalid > option for domain index. > > > Thanx > > > = > Vicky D. Foster, > Oracle DBA > email: [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Spot the hottest trends in music, movies, and more. > http://buzz.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Oracle DBA > 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: Rebuilding indexes
Dear Jeremiah, I don;t quite understand you quoting "Once the indexes have all been rebuilt nologging into the original tablespace, all that's left is to refresh the datafiles for that tablespace onto the primary. " Is primary a typo error (i.e. standby)? Thanks, Hatzistavrou Yannis > -Original Message- > From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 31, 2001 22:15 > To: Multiple recipients of list ORACLE-L > Subject: RE: Rebuilding indexes > > No need to copy the whole file to the standby when adding a datafile! > Just wait > for recovery to fail on the new file (ORA-01670), then type on the standby > (in > 'mount standby database' mode): > > SQL> alter database create datafile '' as ''; > > As long as you are using identical paths on both primary and standby, both > filenames are the same. Our standby log applier does this automatically, > so no > manual intervention is required. > > If you use logical volumes or raw, just make sure the volume is where the > system > expects it to be on the standby. > > If the original poster wants to create a scratch tablespace where the > indexes > will be initially rebuilt, then move the indexes back into the "real" > tablespace, he can probably just 'offline drop' the datafiles for the > scratch > space on the standby when recovery encounters them. Once the indexes have > all > been rebuilt nologging into the original tablespace, all that's left is to > refresh the datafiles for that tablespace onto the primary. When the > scratch > tablespace is dropped on the primary, the offline dropped datafile records > in > the standby's controlfile will also disappear. > > With regard to logging/nologging, with index rebuilds, I would rebuild the > indexes NOLOGGING, and when you are all done, refresh the datafiles for > the > newly reorganized tablespace onto the standby. That saves on space, > operations, > time and reduces the logs you have to back up. > > Nologging operations are not harmful to the standby - you just have to > keep > track of nologging operations and refresh datafiles on the standby > accordingly. > > -- > Jeremiah Wilton > http://www.speakeasy.net/~jwilton > > On Thu, 31 May 2001, Rachel Carmichael wrote: > > > It adds the datafile NAME only, not the file itself. And if the physical > > file has not been moved before the archived log that has that redo in it > is > > applied, the recovery dies. > > > > >From: Hatzistavrou Giannis <[EMAIL PROTECTED]> > > > > > >You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and > > >Recovery) , chapter 16 -- Managing a standby database --- Adding > Datafiles > > >states the following: > > > > > >"Adding a datafile to your primary database generates redo data that, > when > > >applied at your standby, automatically adds the datafile name to the > > >standby > > >control file." > > >There is also a detailed example on how to do it > > > > > > > -Original Message- > > > > From: Richard Huntley [SMTP:[EMAIL PROTECTED]] > > > > > > > > For those of you that have implemented a standby database, what > method > > >do > > > > you use to rebuild your indexes tablespace. > > > > My plan was to create a new tablespace and rebuild the indexes into > the > > > > new > > > > tablespace and then reverse the process to move > > > > back to the original tablespace after I drop and recreate it in > order to > > > > get > > > > rid of fragmentation in the originally indexes tablespace. > > > > However, creating the new datafile associated with the new > tablespace, > > > > cancels media recovery associated with the standby database...just > > > > wondered > > > > if anyone has a better method of defragging an index tablespace when > > >there > > > > is a standby database catching the redo it generates. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeremiah Wilton > 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 &
RE: Rebuilding indexes
You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and Recovery) , chapter 16 -- Managing a standby database --- Adding Datafiles states the following: "Adding a datafile to your primary database generates redo data that, when applied at your standby, automatically adds the datafile name to the standby control file." There is also a detailed example on how to do it > -Original Message- > From: Richard Huntley [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 31, 2001 16:01 > To: Multiple recipients of list ORACLE-L > Subject: Rebuilding indexes > > For those of you that have implemented a standby database, what method do > you use to rebuild your indexes tablespace. > My plan was to create a new tablespace and rebuild the indexes into the > new > tablespace and then reverse the process to move > back to the original tablespace after I drop and recreate it in order to > get > rid of fragmentation in the originally indexes tablespace. > However, creating the new datafile associated with the new tablespace, > cancels media recovery associated with the standby database...just > wondered > if anyone has a better method of defragging an index tablespace when there > is a standby database catching the redo it generates. > > TIA, > Richard Huntley > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Richard Huntley > 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).
How to interpret an errorstack
Hi all, I am trying to run a procedure and it always return a 1861 oracle error. In order to check where the problem exists I have added an event in the init.ora parameter (event="1861 trace name errorstack level 10"). The trace file was produced ok but I don't have a clue what to look for. May some one of you help me find my way through! <> THANKS Hatzistavrou Yannis ora_60183.zip
RE: Script to remove redundant rows in a table?
there is also the case of trying to enable a unique constraint on the underlying table using the exeption option and creating an exception table(utlexcpt.sql). The unique constraint will of caurse fail but inside the exeption table the duplicate rowids will be written . Using this input you can delete from table the duplicates. > -Original Message- > From: Haskins, Ed [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, May 17, 2001 04:10 > To: Multiple recipients of list ORACLE-L > Subject: Script to remove redundant rows in a table? > > A few months ago I remember seeing a script that enabled the removal of > redundant rows in a table. Can someone please forward or point me to such > a > script. > > I have an Oracle Names server that stores the database connect descriptors > in a table within the Region Database. I've loaded these connect > descriptors > from many SQLNET.ora files throughout the enterprise. My problem is that > there exists duplicates from the multiple SQLNET.ora files. I really want > to > clean this up so that only one entry per connect descriptor exists. I > think > that a generic script for any table will work in this situation. > > Thanks, > Ed Haskins > Oracle DBA > Verizon Wireless > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Haskins, Ed > 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: restrict login with known IP address
What about the old protocol.ora? > -Original Message- > From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 08, 2001 20:17 > To: Multiple recipients of list ORACLE-L > Subject: RE: restrict login with known IP address > > Hello, Joseph > Try something like this > > CREATE OR REPLACE TRIGGER IP_CATCH AFTER LOGON ON DATABASE > BEGIN > if ora_client_ip_address = '172.16.0.175' then > raise_application_error(-20001, 'No way from > '||ora_client_ip_address); > end if; > END; > / > > HTH > Vadim Gorbounov > Oracle DBA > > > -Original Message- > Sent: Tuesday, May 08, 2001 1:26 PM > To: Multiple recipients of list ORACLE-L > > > In UNIX, > Knowing the IP address can I restrict any login > to the ORACLE db given this info? > > any help is appreciated ... > > Joe > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Leyden, Joseph > 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: Vadim Gorbounov > 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: looking job
check www.jobserve.com > -Original Message- > From: Lazy DBA [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 26, 2001 13:35 > To: Multiple recipients of list ORACLE-L > Subject: looking job > > Hi everyone ; > > i want to work in US or Europe. I am not living there > now. I work as a Computer Engineer (Database Admin > on Oracle). I have nearly 6 years experience for this. > If you help me about this subject you will make me > happy. if you interest i will send my CV document. > > > Best Regards > Dennis > > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Lazy DBA > 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).
