QUERRY DOUBT..

[Saurabh Sharma]

hi all,
 
i've a querry that is to find out 
what all columns have constraints applied on them. giving the 
table_name,column_name,constraint name and constraint type.
 
the querry goes like..
 
select 
a.table_name,b.constraint_name,b.constraint_type,c.column_namefrom 
user_tables a,user_constraints b,user_cons_columns cwhere 
a.table_name=b.table_name 
andb.constraint_name=c.constraint_name/
 
now i need to make a report which 
gives out in the same result all the tables' columns which have constraints and 
which have not, both.
leaving the constraint_type and 
constraint name columns null in the same querry.
is it possible, or do we have other 
alternative to do that.
 
pls suggest.
thanks
 
saurabh
 
 

Re: How to send email from pl/sql in 806?

[Saurabh Sharma]

HI,
 i tried creating this procedure. but it results into compilation errors.
says..
utl_tcp.connection must be declared, and so does for
utl_tcp.get_line and
utl_tcp.write_line

how do we fefine them. where is this package utl_tcp

pls explore.

thanks.
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 23, 2001 11:05 AM


>
> try this procedure it works  just replace the IP address in the line
> c := utl_tcp.open_connection('192.168.1.1', 25);
> with the IP address of u'r mail server
>
> regards
> __
> Omar Khalid
> Software Engineer
> LMKResources
> A LANDMARK AFFILIATE
> (Formerly Mathtech Pakistan Pvt. Ltd)
> 18, F-8/3, Main Margalla Road,
> Islamabad, Pakistan
> Voice: 111-101-101*780
> Fax: 92-051-2255989
> Email: [EMAIL PROTECTED]
> Web: www.lmkr.com
>
>
>
>
rem ---
> rem Filename:   smtp.sql
> rem Purpose:Send e-mail messages from PL/SQL
> rem Notes:  From Oracle8i release 8.1.6 one can send e-mail messages
> rem   directly from PL/SQL using either the UTL_TCP or UTL_SMTP
> rem   packages. No pipes or external procedures required.
> rem Date:   27-Mar-2000
> rem Author: Frank Naude ([EMAIL PROTECTED])
>
rem ---
>
> CREATE OR REPLACE PROCEDURE SEND_MAIL (
>   msg_fromvarchar2 := 'oracle',
>   msg_to  varchar2,
>   msg_subject varchar2 := 'E-Mail message from your database',
>   msg_textvarchar2 := '' )
> IS
>   c  utl_tcp.connection;
>   rc integer;
> BEGIN
>   c := utl_tcp.open_connection('192.168.1.1', 25);   -- open the SMTP
> port 25 on local machine
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   rc := utl_tcp.write_line(c, 'HELO 192.168.1.1');
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from);
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to);
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   rc := utl_tcp.write_line(c, 'DATA'); -- Start message
> body
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   rc := utl_tcp.write_line(c, 'Subject: '||msg_subject);
>   rc := utl_tcp.write_line(c, '');
>   rc := utl_tcp.write_line(c, msg_text);
>   rc := utl_tcp.write_line(c, '.');-- End of message
> body
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   rc := utl_tcp.write_line(c, 'QUIT');
>   dbms_output.put_line(utl_tcp.get_line(c, TRUE));
>   utl_tcp.close_connection(c); -- Close the
> connection
> EXCEPTION
>   when others then
>raise_application_error(-2,'Unable to send e-mail message from
> pl/sql');
> END;
> /
> show errors
>
> --  Examples:
> set serveroutput on
>
> exec send_mail(msg_to  =>'Omar Khalid/IT/LotusCert/Pk');
> exec send_mail(msg_to  =>'[EMAIL PROTECTED]');
>
> exec send_mail(msg_to  =>'[EMAIL PROTECTED]',
> msg_text=>'Look Ma I can send mail from plsql');
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

> Oracle DBA
> 
> o.com>   cc:
> Sent by: Subject: How to send email
from pl/sql in 806?
> [EMAIL PROTECTED]
> om
>
>
> 05/23/2001
> 11:35 AM
> Please respond
> to ORACLE-L
>
>
>
>
>
> Hi,
>
> I am aware that 817 supports UTL_SMTP for this same
> functionality.  But how can one send email from pl/sql
> in 806?
>
>
> thanx
>
> =
> Vicky D. Foster,
> Senior Oracle DBA:
> email:  [EMAIL PROTECTED]
>
> __
> 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: 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:
>   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 mailin

Re: Exporting and Importing table statistics

[Jared Still]

It sounds like you want to ensure that an external database has
the same execution plan for a query as the one you are developing
and/or testing on.

There's a little more to it than that.  You must make sure you have
the proper init.ora params set, create outlines, and export the
outlines for use in another database.

Take a look at Chapter 10 'Using Plan Stability' in the 'Designing 
and Tuning for Performance' manual.

Jared


On Thursday 24 May 2001 15:18, [EMAIL PROTECTED] wrote:
> Hi all,
> According to the 8i utilities manual I should be able to export a tables'
> statistics
> from one database, then import those statistics into another database.
> I have tried various combinations of export and import scripts but nothing
> seems to
> work. My table has none of the restrictions described in the utilities
> manual that
> would prevent the statistics from being exported and then imported.
> Can this export/import of statistics be done at a single table level or
> does it have
> to be a full database export? If not at the table level can it be done at
> the schema
> level?
>
> Thanks everyone,
> Gary Bonner
> [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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: MS access

[rupali belsare]

As far as my knowledge is 2GB.  And I dont think u can cross this limit.

Rups

"Li, Xiangli" wrote:

>
>
> Hi, List
> Is there anyone happen to know what's the database size limitation for
> MS access97? I heard it's 1 gigabytes, how to overcome it if that's
> true?
>
> thanks
> Li

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: rupali belsare
  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: File created by failed Add Datafile command

[rupali belsare]

Whatever Jim has said is exactly right procedure... as I have experianced this
type of problem before and cured it in the same way Jim said..

Rupali

Hawkins Family wrote:

> I would take a look at my controlfile first.  Issue a "alter database backup
> controlfile to trace;".
>
> Take a look at two things:
> 1.  What is your maxdatafiles set to?
> 2.  Does this new datafile appear in the datafile list?
>
> If it doesn't, I would not delete this datafile, but just rename it so you
> could always go back to it.  Reissue your add datafile command and see what
> happens.  If anything gets screwed up, you can always rename your renamed
> datafile back.
>
> HTH,
> Jim
>
> ^
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 501 Pearl Drive
> St. Louis, MO  63376
> (636) 474-7832
> [EMAIL PROTECTED] (work)
> [EMAIL PROTECTED] (personal)
> ^
>
> -Original Message-
> Sent: Thursday, May 24, 2001 9:15 AM
> To: Multiple recipients of list ORACLE-L
>
> Yesterday I went to add a new datafile and the command failed because I
> already had datafiles = db_files value.  No problem, I increased the
> parameter and waited until this morning since this database is shut down
> every night.
> I ran the command this morning and discovered that the file was in in fact
> created on the OS even though it didn't appear in dba_data_files.  The time
> stamp on the file was the time I created it yesterday (all other files have
> a timestamp of this morning).
> I assume I can just either delete this file and reissue the command or issue
> the command with the REUSE option?  I was about to do that and decided to
> double check with the experts :) since I've never encountered the specific
> situation before and I still have a week before I really have to worry about
> space on this tablespace.
>
> Thanks in advance,
> Jay Miller
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   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: Hawkins Family
>   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: rupali belsare
  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 Development Tool

[Christopher Spence]

 I have used SQL Nav, Toad, PL/SQL Developer, SQL PLus, WinSQL, SQL
Worksheet. 

I use PL/SQL Developer religiously now. (As for 3 years now as I put alot of
bug fixes and change requests into the product and over 30 of my requests
have been implemented, they are a great company when it comes to support).


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/24/01 10:55 PM

I nver use PL/SQL Developer  ? How good did it compare with TOAD ?
My company only use TOAD ,But I have intention to recommend some tools
if
found which is more easly ,powerfull to use ?




-Original Message-
Sent: Thursday, May 24, 2001 10:57 PM
To: Multiple recipients of list ORACLE-L


I think PL/SQL Developer blows away Toad especially since it is only
$150-$50 depending on how many you buy compared to $750 buying toad.
AllAround Automations sells it.  Anyone I have shown it to (SQL Nav
users,
Toad) and they have "seen the light".


"Walking on water and developing software from a specification are easy
if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 24, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


Hi Deepak,

I'd go with TOAD, why? well I have been using it since it was a freeware
(we
bought it finally) and am very comfortable with what it does and how
easy it
makes things.

Hats off to TOADMAN !

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

*4

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.

*4

-- 
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).
-- 
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: Raymond Lee Meng Hong
  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: Steve Adam's Removal

[Rahul]

i hope this thread is still alive and my reply makes it to the list...

by removing Steve from the list , we all will miss the insight into oracle
internals, 
which he provided , thru his answers and the links (plugs ? ) to his
website.. 

many threads would end when Steve provides his explanation/answer, this show

the respect posters have for his knowledge or Oracle. 

please reconsider

Regards
Rahul


> --
> From: Suhen Pather[SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 6:36 AM
> To:   LazyDBA.com Discussion
> Subject:  RE: Steve Adam's Removal
> 
> Henry,  List
> 
> I second you on this one.
> I respect Henry being the list owner, having authority to do as he
> pleases.
> 
> ORACLE -L is possibly the best Oracle list out there,and has brought so
> many
> 
> Oracle professionals together, but lets not lose our experts. 
>  
> Please reconsider the removal of Steve Adams from the list.
> 
> He takes up lots of his time to answer performance related questions
> posted by list members with precise actions to be taken and great
> explanations.
> 
> He is an invaluable member to the Oracle world and his expertise,
> generosity
> will
> surely be missed if he removed.
> 
> Kind Regards and pls reconsider
> Suhen
> 
> 
> 
> 
> List,
> 
> While I respect Henry's authority as list owner to remove people from the
> list, and the need to do so when people are breaking the rules, I would
> like
> to protest the removal of Steve Adams.  He is one of the top experts in
> Oracle internals in the world, and he was gracious enough to take time to
> answer people's questions on the list.
> 
> I am not sure what he ever did that was thought to be spamming, except
> answer people's questions.  He has a link to his website in his signature,
> and often his answers were links to a place on his site where he had
> already
> answered that question.  I don't see what's wrong with that, none of it
> seems to violate the rules of the list.
> 
> If it was a matter of one or two people complaining about Steve's posts,
> perhaps the list should have been asked.  I can only hope that the
> overwhelming majority understood Steve's method of answering questions and
> were not annoyed with it.
> 
> The show now knows a lot less about Oracle Internal Services.
> 
> Reed Sutton
> 
>   
> 
> -Original Message-
> From: Henry O'Keeffe [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 8:58 AM
> To: LazyDBA.com Discussion
> Subject: Re: Spamming the list
> 
> 
> I'm afraid, you'll actually have to leave the list Steve. Picking lines
> from
> private emails sent between us, and presenting them out of context isn't
> something that most people would have expected from you. I'm sorry that
> it's
> had to come to this.
> 
> Indeed, the show will go on.
> 
> Goodbye.
> Henry.
> 
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to [EMAIL PROTECTED]
> To subscribe:   send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to [EMAIL PROTECTED]
> To subscribe:   send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> 
> 
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to [EMAIL PROTECTED]
> To subscribe:   send a blank email to [EMAIL PROTECTED]
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  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: Ok two databases..two machines..one database name

[Paul Drake]

Rachel Carmichael wrote:
> 
> short answer:   yes you can
> 
> >From: "Steve McClure" <[EMAIL PROTECTED]>
> >
> > My question is can I have databases with the same name
> >running simultaneously on two different machines if I make sure the
> >tnsnames
> >for each database points to it's own server?  The database is 7.3.4.  As
> >soon as I send this off I am going to create a small DB just to test this
> >out, but your input, as usual, is appreciated.
> >
> >Thanks,
> >Steve McClure
> >

Well, on 7.3.4 I guess that there wasn't a service_name, so this isn't
that helpful:

Use the service_name : schema in your sql prompt

 - and - more importantly -

use unique passwords on each database.

Very helpful when you're brain dead to prevent you from having to test
your recovery skills in an unscheduled setting.

Sorry Rachel. :)

Paul
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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: NT Scheduled Restart

[Weaver, Walt]

Title: Database Down



You 
can't. You're a member for life.
 
It's 
like that old Kingston Trio song: "Well, he never returned, no, he never 
returned, and his fate is still unlearned (poor old Andy)".
 
I hope 
you said goodby to your family.
 
--Walt 
Weaver
  
The lesser half of Walt Weaver/Steve Orr Associates
  Bozeman, Montana

  -Original Message-From: Andy 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 10:00 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  NT Scheduled Restart
  how 
  to unsubscribe from this list ?

Re: OFF TOPIC: My Unix mail file is too huge to access

[Jenny Jacobson]

Thanks to all who replied.  I received some very helpful ideas and
new knowledge.  Charlie Mengler came up with the solution I used:

1. Use vi on this huge file to find a place to split the file.

2. Then issue the command:

cat jenny | head -153498 | > jenny153498

3. Place the new jenny153498 file in the directory of PINE folders.

4. Use PINE and view the messages in the jenny153498 folder.

Thanks.

Jenny



On Thu, 24 May 2001, PD Miller wrote:

> At 13:49 -0800 24/5/01, Jenny Jacobson wrote:
> >How do I get into my old mail so I can 1) delete old messages and
> >2) access a VERY important email that I need to use.
> 
> Eudora uses the exact format used for unix mail files, so I recommend that.
> 
> >I don't think my unix account has a pop3 server.  Someone suggested I ftp
> >the file to my PC and read it there.  When I did a file command, it said
> >the mail file was ASCII text, but my important email has an attached Excel
> >spreadsheet.  Do I ftp in ASCII or binary mode?
> 
> Binary for certain. Eudora can sort out the attachment format as long 
> as the file has not been translated. Not just email, but with 
> everything, use binary only. Even if you need the line terminators 
> translated, ftp is the worst way on earth to do it.
> 
> >I don't have any mail
> >software on my PC (I use a shell account and Yahoo).  I don't want to use
> >my Yahoo account to process this huge file via pop3.
> 
> http://www.eudora.com/ and it is free.
> 
> Regards
> 
> Paul Miller
> 
> -- 
> -
> Carib Data Limited
> 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: PD Miller
>   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: Jenny Jacobson
  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: NT Scheduled Restart

[Peter McLarty]

Title: Database Down



Shutdown.exe.is part of the NT resource Kit. So I probably wouldn't class 
it as freeware. 
Bill 
would have a fit. :-)
 
Peter

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of AndySent: Friday, 25 
  May 2001 2:00 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: NT Scheduled Restart
  how 
  to unsubscribe from this list ?
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Rajesh DayalSent: 23 
Mei 2001 15:46To: Multiple recipients of list 
ORACLE-LSubject: RE: NT Scheduled Restart
That's the best thing I like about this 
list...
You ask for something and you get it, with no delay 
at all
Thanks list and Thanks 
Suhen...
 
Rajesh

  -Original Message-From: Suhen Pather 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 
  2001 11:11 AMTo: Rajesh DayalSubject: RE: NT 
  Scheduled Restart
  Rajesh, 
   
  We use a exe called 
  shutdown.exe.
  It works quite 
  well.  I think it is a 
  freeware.
   
  I have attached a copy of 
  shutdown.exe.
  Copy this file to C:/winnt.
  We pass it arguments 
   
  shutdown.exe /L /R /T:25 /C 
/Y
   
  HTHSuhen
   
   
   
   
  

  Hi all,
      I am looking for a utility 
  (preferably freeware), which can perform a scheduled shutdown of NT 
  4.0 server. This I need because of inconsistent behavior of NT for 
  Oracle Services. I want to do a scheduled restart after every night 
  backup(scheduled).
      Appreciate your inputs and 
  suggestions.
   
  TIA,
  Rajesh

RE: NT Scheduled Restart

[Andy]

Title: Database Down



how to 
unsubscribe from this list ?

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Rajesh DayalSent: 23 
  Mei 2001 15:46To: Multiple recipients of list 
  ORACLE-LSubject: RE: NT Scheduled Restart
  That's the best thing I like about this 
  list...
  You ask for something and you get it, with no delay 
  at all
  Thanks list and Thanks 
  Suhen...
   
  Rajesh
  
-Original Message-From: Suhen Pather 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 
2001 11:11 AMTo: Rajesh DayalSubject: RE: NT Scheduled 
Restart
Rajesh, 
 
We use a exe called 
shutdown.exe.
It works quite well.  I 
think it is a freeware.
 
I have attached a copy of 
shutdown.exe.
Copy this file to C:/winnt.
We 
pass it arguments 
 
shutdown.exe /L /R /T:25 /C /Y
 
HTHSuhen
 
 
 
 

  
Hi all,
    I am looking for a utility 
(preferably freeware), which can perform a scheduled shutdown of NT 4.0 
server. This I need because of inconsistent behavior of NT for Oracle 
Services. I want to do a scheduled restart after every night 
backup(scheduled).
    Appreciate your inputs and 
suggestions.
 
TIA,
Rajesh

RE: Listener.log....writing to renamed file

[Reardon, Bruce (CALBBAY)]

On NT, if you don't want to lose any listener.log entries and you want to
keep using the same logfile name then you will need to use set log_file
twice.

Also, under NT (at least with 815 and 817) don't specify an extension for
the log file - it automatically gets ".log" appended.

For example (something like the following untested code):

lsnrctl set log_file temp1
ren listener.log listener_tmp.log
lsnrctl set log_file listener
copy /b listener_tmp.log + temp1.log  listener-date.log
del listener_tmp.log
del temp1.log

You could put the date into the archived listener log using the for command
to process output of date/t and time/t.
Note that using set log_file requires the listener password to be entered.
This can be automated under NT by using something like:

rem create the temp file
   echo set password %lnrpwd% >  %lnrstart_file%
   echo stop %1 >> %lnrstart_file%
   echo exit   >> %lnrstart_file%
   echo.>> %lnrstart_file%

rem feed it into lsnrctl
   lsnrctl < %lnrstart_file%




Regards,
Bruce



-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 25 May 2001 5:53 
To: Multiple recipients of list ORACLE-L


Issue the SET LOG_FILE command using lsnrctl, then move/delete/whatever 
the old file.

-Original Message-
Sent: Thursday, May 24, 2001 1:58 PM
To: ORACLE-L; Xiangli.Li



May I know how to clear the content of listener.log without restart 
listener on NT platform ? 

thanks. 
Li 

-Original Message- 
From:   Brian MacLean [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, May 24, 2001 1:42 PM 
To: Multiple recipients of list ORACLE-L 
Subject:    RE: Listener.logwriting to renamed file 

Reload doesn't close/reopen the file.  Here is a couple 
solutions   

How's about a fast cat/clear solution: 

#!/bin/ksh
cat listener.log >>listener.log.hist
ex listener.log As a regular maintainance work,I have moved the listener.log file to
->listener.log.old
->and 'touch'ed the listener.log, expecting the logging into this new 
file.
->But I am observing the logging being done to listener.log.old, 
instead.
->I could not recall any such previous experience.
->FYI, I cannot do any 'experiments' as far as this system is concerned 
as I
->have to deal with
->desupported HP-UX(10.01), Oracle (7.2.2.3).
->I have my logging being done to default 
path($ORACLE_HOME/network/log), as
->no parameter settings in listener.ora.
->Has anybody experienced this?
->
->TIA,
->
->Suren
->Oracle DBA
->Sony Electronics Ltd.
->
->
The file handle listener is using is still pointed at the old file.  To 
fix this you need to stop and start the listener.  This will not affect 
anybody who is already connected.  I'm not sure if a reload will do the 
same thing.

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.    [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates. 

--
Please see the official ORACLE-L FAQ: < http://www.orafaq.com>
--
Author: Thater, William
  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: Reardon, Bruce (CALBBAY)
  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).

MLOG$_ ?

[Joseph Raj]

hi,

when one creates a snapshot log ( with rowid ) the following table structure
is created

 Name  Null?Type
   -  --
--
1. M_ROW$$VARCHAR2(255)
2. SNAPTIME$$ DATE
3. DMLTYPE$$  VARCHAR2(1)
4.  OLD_NEW$$  VARCHAR2(1)
5. CHANGE_VECTOR$$RAW(255)

the first column holds the rowid,  the 3rd the type of dml.
 any idea what the others contail ?

the second column contains a fixed date '01-Jan-4000 00:00' ?  In earlier
versions ( 7.0.x ) it used to contain a null for a similar snapshot log.

what is the significance of  logging/nologging  in snapshot creation.  in
case of a recovery as and when the data is recovered from the logs the
triggers would anyway fire and populate the mlog$_ tables ?

regards,
joseph raj kumar


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joseph Raj
  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: large pool

[Christopher Spence]

 Mainly for MTS, RMAN, and Parallel query.

It basically is a seperate area of memory without a LRU list.
Although you really can put thing there, Oracle handles this by it's self.


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 5/24/01 4:18 PM

Hi there,

What exactly is the large pool used for?

>From Metalink:

"The two main uses of the large pool in Oracle 8 are:

a. For the User Global Area (UGA) of sessions
connected using MTS (multi-threaded server)

b. Buffering for sequential file IO (Eg: as used by
server managed recovery when there are multiple IO
slaves)"

I'm not using MTS, so I'm not worried about "a".

What do they mean by "Buffering for sequential file
IO"? Full table scans? 


Thanks,

J






__
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: Jake MacGruder
  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: Oracle Development Tool

[Raymond Lee Meng Hong]

I nver use PL/SQL Developer  ? How good did it compare with TOAD ?
My company only use TOAD ,But I have intention to recommend some tools if
found which is more easly ,powerfull to use ?




-Original Message-
Sent: Thursday, May 24, 2001 10:57 PM
To: Multiple recipients of list ORACLE-L


I think PL/SQL Developer blows away Toad especially since it is only
$150-$50 depending on how many you buy compared to $750 buying toad.
AllAround Automations sells it.  Anyone I have shown it to (SQL Nav users,
Toad) and they have "seen the light".


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 24, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


Hi Deepak,

I'd go with TOAD, why? well I have been using it since it was a freeware (we
bought it finally) and am very comfortable with what it does and how easy it
makes things.

Hats off to TOADMAN !

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

*4

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.

*4

-- 
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).
-- 
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: Raymond Lee Meng Hong
  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: BUNYAMIN POSTS HAVE A VIRUS

[Jared Still]

Well, I sent him an email about this last night, and no
reply yet.

Or was it this morning?  Anyway, it was dark.  :)

I guess he gets unsubscribed now.  :(

Jared


On Thursday 24 May 2001 08:16, Mohan, Ross wrote:
> "This individual", BUNYAMIN, appears
> to be squirting virus code...yes...
>
> || -Original Message-
> || From: [EMAIL PROTECTED]
> || [mailto:[EMAIL PROTECTED]]
> || Sent: Thursday, May 24, 2001 10:27 AM
> || To: Multiple recipients of list ORACLE-L
> || Subject: FW: RE: MICROSOFTDTPROPERTIES
> ||
> ||
> || If anyone receives mail from this individual, please scan
> || any attatchments
> || as it contains the W32/BadTrans@MM vi*us...
> ||
> || Scott Shafer
> || San Antonio, TX
> || 210-581-6217
> ||
> || "And no amount of training or preparedness can eliminate the almost
> || certainty that in the middle of your Angry Crane stance, as
> || you transition
> || to your Combative Monkey to administer the Coup de Grâce via
> || your Ninja
> || Death Touch, you step on a beer bottle and fall backwards
> || into the juke box
> || and get your head stove in by a drunk with a pool cue."  --Jay Trigg
> ||
> || > -Original Message-
> || > From:Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]]
> || > Sent:None
> || > To:  [EMAIL PROTECTED]
> || > Subject: Re: RE: MICROSOFTDTPROPERTIES
> || >
> || > '[EMAIL PROTECTED]' wrote:
> || > 
> || > - The developer created the table and now doesn't know
> ||
> || what is does???
> ||
> || > - As penance, said developer(s) must write "I will
> ||
> || document all changes
> ||
> || > fully"
> || > - and "RTFM" in their own blood, 10,000 times on the floor
> ||
> || without using
> ||
> || > their
> || > - hands.
> || > -
> || > - Then:
> || > - 1)  export tables=MICROSOFTDTPROPERTIES ...
> || > - 2)  DROP TABLE MICROSOFTDTPROPERTIES;
> || > - 3)  see who/what/if anything breaks, whines, or snivels...
> || > -
> || > - All assuming this is a developm ...'
> || >
> || > > Take a look to the attachment.
> || >
> || >  <>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  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: Ok two databases..two machines..one database name

[Rachel Carmichael]

short answer:   yes you can


>From: "Steve McClure" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Ok two databases..two machines..one database name
>Date: Thu, 24 May 2001 16:40:50 -0800
>
>I have been tasked with moving a production database to a 'backup' machine.
>I ran my plan past you a week or so ago.  Essentially I will put the DB in
>backup mode, copy the datafiles, shutdown, copy redo and control files, 
>then
>recover on the second machine.  So far plain vanilla.  I understand the
>above procedure enough to have actually thought of it.
>
>My problem now is this.  I need to test this instance on the 'backup'
>machine before we actually do the move.  This is Just to make sure the
>application is completely in order.  One of the developers is telling me
>that having the two databases up and running with the same SID, even on
>separate machines MAY cause trouble for the production instance.  I believe
>that if I make sure the tnsnames.ora file for both servers points to their
>own local instances, that I will not have a problem.  The clients will only
>access the database pointed to in their tnsnames files, so I am confident 
>we
>are ok there.  My question is can I have databases with the same name
>running simultaneously on two different machines if I make sure the 
>tnsnames
>for each database points to it's own server?  The database is 7.3.4.  As
>soon as I send this off I am going to create a small DB just to test this
>out, but your input, as usual, is appreciated.
>
>Thanks,
>Steve McClure
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steve McClure
>   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

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

OT: Winnie quote

[Campbell, James]

"If you live to be a hundred, I want to live to be a hundred minus one
day,so I never have to live without you. -- Winnie the Pooh"

Dear me, Bill, where on earth did you get that from?  I think I can hear
A.A. Milne revolving in his grave.

That 'quote' isn't from Pooh at all, it's probably from Walt @#$$^^@!
Disney.  The REAL Pooh is much wiser than that cheap greetings-card stuff!

Regards,
James Campbell
(Oracle DBA when all the real ones have left; Duhveloper; Pooh fan of 45
years standing)
It's Friday in Australia...
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Campbell, James
  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: Moving a database to a different machine

[Steve McClure]

Jared,

I remember YOU doing this.  If you explained the process to me at the time.
I probably just nodded my head and said 'yes' a lot.

-Original Message-
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jared Still
Sent:   Thursday, May 17, 2001 7:25 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Moving a database to a different machine


Steve,

Do you recall doing this about 5 years ago?

I recall doing this same procedure there, but without
benefit of standby database.

Total downtime was less than 2 hours, and we did
it during a slow period.  ( probably Saturday night :(

Jared


On Thursday 17 May 2001 13:48, Steve McClure wrote:
> Koivu, Lisa said
> "A word of warning, and you probably already know this: you can't have
both
> databases open at the same time or you will end up with incompatible
> archive logs and control files. Good luck !"
> 
> hehe I did know, but upon reading your warning it still frightened me for
a
> moment. Because I was planning to do this one time prior to the move to
> allow for testing. Therefore having both databases up and running at the
> same time on the two different machines. I know I will have to do the
> migration again when we actually move, so that the database(s) will
recover
> properly. Oh and thanks for the tip about just moving the arc/redo/control
> files back to the production machine to resynch the DBs. That will save me
> from some tedium on moving day.
> Steve McClure
> -Original Message-
> Sent: Thursday, May 17, 2001 11:47 AM
> To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
>
> Hi Steve,
> I used this same strategy with a migration last month. It minimized our
> database related downtime to 30 minutes (and then they unplugged the
> symmetrix and the app server was down for 12 hours. Oh well)
> This plan will work. Once your production machine is physically moved and
> set up, you can do the reverse to apply changes to the prod database
> without copying over the entire database from dev:
> Starting with production database down, the following steps will bring
prod
> up to date:
> 1. Shutdown dev
> 2. Copy over control files/redo logs/arc logs
> 3. Start up prod
> 4. Initiate recovery
> Voila. Slick.
> A word of warning, and you probably already know this: you can't have both
> databases open at the same time or you will end up with incompatible
> archive logs and control files. Good luck !
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Certified Self-Important Database Deity
> Slayer of Unix Administrators
> Wanton Kickboxing Goddess
> [EMAIL PROTECTED]
>
> NeoMedia
>
> 2201 Second St., Suite 600
> Fort Myers, FL 33901, USA
> Phone: 941-337-3434
> Fax: 941-337-3668
> www.neom.com 
> www.paperclick.com 
> www.qode.com 
>
> P a p e r C l i c k . c o m 
> Enter Your PaperClick Code Here!
>
> -Original Message-
> Sent: Thursday, May 17, 2001 2:26 PM
> To: Multiple recipients of list ORACLE-L
> Allright,
> We are physically moving our office, and have an OLTP application that
> needs to be up and running with minimal downtime. The current plan is to
> use the development computer as the production platform while the Primary
> computer is physically moved to the new location. The development system
> was the production system about 6 months ago, so it will not be under too
> much strain.
> I have completely duplicated the filesystems of the Primary machine on the
> development box.
> This is my plan. Please comment if there is an obviously better way. Oh
> the database is version 7.3.4
> 1.Put the tablespaces of the production database in backup mode.
> 2.Copy datafiles across the network to the "development" machine. Approx 3
> GB
> 3.Take the production tablespaces out of backup mode.
> 4.Force a log switch.(Habit I guess)
> 5.wait until the production system is brought down.
> 6.move the control files and redo logs to the development system
> 7.move the initSID.ora and configSID.ora files.
> 8.edit configSID.ora to change the host associated to Listener.
> 9.fire up svrmgrl, and recover the database.
> 10.change the tnsnames on the client systems to point to the development
> machine.
> Of course. This needs to be tested to some degree first. And we(well
> management at least) don't want to bring the production machine down to
> roll the databases forward together just for a test. I can use make a
> backup control file for use during recovery, and move the curently offline
> redo logs. I am not sure what to do about the most current redo log in
this
> case. I have played with backup and recovery, but not this scenario. I
> don't currently have my copy of the Velpuri backup and recovery handbook
at
> hand(Loaned it to a colleague). So I am bouncing this off of you folks
> while I ponder this until I retrieve my backup and recovery bible. Any
> Comments are appreciated.
> Thanks,

Ok two databases..two machines..one database name

[Steve McClure]

I have been tasked with moving a production database to a 'backup' machine.
I ran my plan past you a week or so ago.  Essentially I will put the DB in
backup mode, copy the datafiles, shutdown, copy redo and control files, then
recover on the second machine.  So far plain vanilla.  I understand the
above procedure enough to have actually thought of it.

My problem now is this.  I need to test this instance on the 'backup'
machine before we actually do the move.  This is Just to make sure the
application is completely in order.  One of the developers is telling me
that having the two databases up and running with the same SID, even on
separate machines MAY cause trouble for the production instance.  I believe
that if I make sure the tnsnames.ora file for both servers points to their
own local instances, that I will not have a problem.  The clients will only
access the database pointed to in their tnsnames files, so I am confident we
are ok there.  My question is can I have databases with the same name
running simultaneously on two different machines if I make sure the tnsnames
for each database points to it's own server?  The database is 7.3.4.  As
soon as I send this off I am going to create a small DB just to test this
out, but your input, as usual, is appreciated.

Thanks,
Steve McClure

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  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: Virus Warning

[Suhen Pather]

Title: Virus Warning



me 
too

  I received an email from Bunyamin K. Karadeniz in 
  response to an earlier 'Database Down' message that I had sent to the 
  list.  The email from him had an attachment to it.  I opened it (I 
  know this was not wise) and our virus scan had deleted the file and left a 
  message stating the file had a virus called '???'.  
  Just wanted to alert everyone.  I have had 3 
  emails from him so far, all with the virus attached. 
  Laura 

Script to compare two schemas

[Helmut Daiminger]

Hi!

Does anybody out there have a script to compare to database schemas and list
the differences?

I know this has been posted a few times, but I don't have the emails anymore
and can't find anything in the archives... Sorry.

This is 8.1.6 on Win2k.

Thanks,
Helmut

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

Sessions are waiting on buffer busy wait with P3 value 130 in v$s

[Srikannan Gopalsamy]

We've lot buffer busy waits in data block with P3 value 130 in V$session. 

I've read about this in few notes, but still I do not understand few things.


P3=130 means: 
- 
Block is being read by another session and no other 
suitable block image was found, so we wait until the read 
is completed. This may also occur after a buffer cache 
assumed deadlock. The kernel can't get a buffer in a 
certain amount of time and assumes a deadlock. 
Therefore it will read the CR version of the block. 

Does it mean that the block is being held in an incompatible mode by the
first session or set of sessions reading it in shared mode, and current
session is trying to lock it exclusively for a DML and waiting for the same.


What are steps we can take to avoid this types of buffer busy waits? 

Thanks for your help. 
Sri
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Srikannan Gopalsamy
  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: OFF TOPIC: My Unix mail file is too huge to access

[PD Miller]

At 13:49 -0800 24/5/01, Jenny Jacobson wrote:
>How do I get into my old mail so I can 1) delete old messages and
>2) access a VERY important email that I need to use.

Eudora uses the exact format used for unix mail files, so I recommend that.

>I don't think my unix account has a pop3 server.  Someone suggested I ftp
>the file to my PC and read it there.  When I did a file command, it said
>the mail file was ASCII text, but my important email has an attached Excel
>spreadsheet.  Do I ftp in ASCII or binary mode?

Binary for certain. Eudora can sort out the attachment format as long 
as the file has not been translated. Not just email, but with 
everything, use binary only. Even if you need the line terminators 
translated, ftp is the worst way on earth to do it.

>I don't have any mail
>software on my PC (I use a shell account and Yahoo).  I don't want to use
>my Yahoo account to process this huge file via pop3.

http://www.eudora.com/ and it is free.

Regards

Paul Miller

-- 
-
Carib Data Limited



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: PD Miller
  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: OFF TOPIC: My Unix mail file is too huge to access

[Eric D. Pierce]

On 24 May 2001, at 13:49, Jenny Jacobson wrote:


sorry I can't help with the problems relating to the
old unix stuff, but see www.pmail.com for a good 
(free) windows email program.


...
> I don't think my unix account has a pop3 server.  

you can't be serious? 

does that mean that there is *no* pop3 there at all?

if there is a pop3, i'd highly recommend moving from 
unix/yahoo to using something like Pegasus Mail and
pop3.

the only problem is that if your SAs won't support
running Pegasus in server mode (see "Mercury" at 
www.pmail.com), then you will end up with everything 
(mail folders) on a windows "C:" drive, which 
obviously is a precarious backup environment.

regards,
ep

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

Exporting and Importing table statistics

[bonnergj]

Hi all,
According to the 8i utilities manual I should be able to export a tables'
statistics
from one database, then import those statistics into another database.
I have tried various combinations of export and import scripts but nothing
seems to
work. My table has none of the restrictions described in the utilities
manual that
would prevent the statistics from being exported and then imported.
Can this export/import of statistics be done at a single table level or
does it have
to be a full database export? If not at the table level can it be done at
the schema
level?

Thanks everyone,
Gary Bonner
[EMAIL PROTECTED]

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

OFF TOPIC: My Unix mail file is too huge to access

[Jenny Jacobson]

Last fall I stayed away from the computer for a long time -- nice
vacation.  When I went to read my email, I had over 6,000 messages.  I
started reading and deleting away.  Got knocked off the net without
exiting.  This happened several times until I was no longer able to bring
up my email in PINE on Unix. 

I saved the mail file and let the system continue in a new file.
The old mail file is 30 MB.  Now I have a stable environment.
How do I get into my old mail so I can 1) delete old messages and
2) access a VERY important email that I need to use.

I don't think my unix account has a pop3 server.  Someone suggested I ftp
the file to my PC and read it there.  When I did a file command, it said
the mail file was ASCII text, but my important email has an attached Excel
spreadsheet.  Do I ftp in ASCII or binary mode?  I don't have any mail
software on my PC (I use a shell account and Yahoo).  I don't want to use
my Yahoo account to process this huge file via pop3. 

How do I access my important email in this old mail file?

Thanks.

Jenny Jacobson


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jenny Jacobson
  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: RE-ENGINEERING OF TABLESPACES

[Thater, William]

On Thu, 24 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:

->wanna bet?  goddesses know much
->
->but yea, any time I post something that someone else can fix or if I post
->something wrong, just go ahead and post the corrections to the list. Unlike
->you guys, *I* don't believe I'm a goddess :)

Hey, I'm working on it.;-)  But she's tough to convince.;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: RE-ENGINEERING OF TABLESPACES

[Scott . Shafer]

Kneel mortals!  The Goddess hath spoken!!!

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 3:37 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: RE-ENGINEERING OF TABLESPACES
> 
> wanna bet?  goddesses know much
> 
> but yea, any time I post something that someone else can fix or if I post 
> something wrong, just go ahead and post the corrections to the list.
> Unlike 
> you guys, *I* don't believe I'm a goddess :)
> 
> 
> >From: "Sakthi , Raj" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >Subject: RE-ENGINEERING OF TABLESPACES
> >Date: Thu, 24 May 2001 11:57:53 -0800
> >
> >Hi Listers ,
> >I saw some posts about re-engineering of tablespace
> >creation script . This is Rachel's script which I
> >Modified to include LMT's . If anybody is wondering ,
> >I am posting this with her permission ..;) Any
> >'stirring' living being in ORACLE universe dare not
> >risk the wrath of 'Goddess'...( Alright Rachel...Am I
> >glad you don't know where I live ...! )

--
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: (Fwd) Wilber/Shambala interview ("transideological" social trends)

[Jake]

Man, I could spend all day at that site:

We envision to authoritatively provide access to seven-habits-conforming
products so that we may quickly supply enterprise-wide paradigms to set us
apart from the competition

:)

-J
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 2:57 PM
trends)


> wait, where are my boots ?
>
> Dilbert's "Mission Statement" generator:
>
> http://www.dilbert.com/comics/dilbert/career/bin/ms2.cgi
>
>  "The customer can count on us
>   to completely maintain
>   market-driven meta-services
>   in order to competently
>   engineer inexpensive data
>   because that is what the
>   customer expects "
>
> regards,
> ep
>
>
> On 23 May 2001, at 19:10, Rachel Carmichael wrote:
>
> 
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric D. Pierce
>   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).


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jake
  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 Applications Suite CDs.

[Ron Rogers]

Patrice,
 Check the OTN and select the software you would like to download. Most of the time 
they give you the option to receive it on CD. OR you could purchase almost anything 
you want at thr Oracle store for $39.95US.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 05/24/01 02:51PM >>>
I would like to know how to obtain a trial or developer version of the
Oracle Applications Suite...

: )

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: 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).

My Website

[Christopher Spence]

Looks like someone is going to be walking around with a VampireD.Net Oracle
Den t-shirt! 

:)   First one produced happened today.  2 days in market and already
cornered the nitch market!  Woohoo.  Heh, yeah right.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence  OCP  MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 


-- 
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: Sort of OT but sort of not....

[Eric D. Pierce]

Ok, now I see that Dick's answer was correct.

We had Netware3 running on a 66mhz? 486EISA box for years, it worked 
ok. It was replaced by a 200 mhz p1 HP Netserver E 45 around 1997 or 
1998, and that is pretty fast for a "workgroup" setting.

Presumably your main concern besides performance will be reliability.

Anyway, if it turns out your 233 box is reliable enough, but slow as 
a shared file server, that's ok, just tell the users to complain so 
management buys you something better. :) If that doesn't work, think 
about cpu upgrade, adding RAM, faster ethernet card, etc.

regards,
ep


On 24 May 2001, at 12:18, Kevin Kostyszyn wrote:


> Eric,
>   I didn't re-read what I wrote but apparently it was pretty pathetic, no one
> understood it, my aplogies.  It's a file server, it's just a box holding a
> big 40 gig IDE drive with templates and such for all of the users and
> developers.
> Currently it is in a PIII 600, and I could use that box as a developement
> box if I add some scsi's and another processor.
>   So, I figured I would use this little PI 233 as it's replacement to house
> the shared drive.  Just wondering what everyone thought of that.  Thanks for
> the help!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: Odd core dump - possibly listener related

[Ron Rogers]

Lisa,
 I have missed your input lately.. The BEST of luck on your new job.
ROR mª¿ªm



--
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: MS access

[Christopher Spence]

Title: RE: MS access



Yup, 
that's what I said :)
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: Li, Xiangli 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 3:20 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  MS access
  it seems only access 2000 supports 
  2gb files. 
  thanks. Li 
  
-Original Message- From:   Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent:   Thursday, May 24, 2001 2:12 PM To: Multiple recipients of list ORACLE-L Subject:    RE: MS access 
I believe it is 2gb. 
    
"Walking on water and developing software 
from a specification are easy if both are frozen." 

Christopher R. SpenceOracle 
DBAFuelspot 

  -Original Message-From: Li, Xiangli 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 
  11:57 AMTo: Multiple recipients of list 
  ORACLE-LSubject: MS access
  Hi, ListIs there anyone happen to 
  know what's the database size limitation for MS access97? I heard it's 1 
  gigabytes, how to overcome it if that's true?
  thanksLi 

Re: Uwin question ???

[Diana_Duncan]

You probably don't have "." in your path (which is good security).  Preface
the call to your script with "./"

./test.sh

On the other hand, you may not have the "magic" comment at the top of the
script, like this:

#!/bin/ksh

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   

Leslie Lu  

   
yahoo.com>   cc:   

Sent by: Fax to:   

root@fatcity.Subject: Uwin question ???

com

   

   

05/24/2001 

03:20 PM   

Please 

respond to 

ORACLE-L   

   

   





Hi all,

A while ago, I asked about running unix script on NT.
I run into a problem in UWin that I got file not found
message even if the file is there and is executable.
I run a ksh file with and without sh, I kept getting
"not found".  Then I wrote a test1 script, if run
without sh, I still got "not found", but if run with
sh like sh test1, it works.  All the scripts work find
in Unix.  Attached is upgrade_wm.ksh I'm trying to run
and following shows the details from UWin:

$ ls (ls shows upgrade_wm.ksh is in the current
directory)
...
upgrade_wfm_RefData.sql
upgrade_wfm_RefData_401.ksh
upgrade_wm.README
upgrade_wm.ksh

$ upgrade_wm.ksh (run it in the same directory, got
not found message)
-ksh: upgrade_wm.ksh: not found [No such file or
directory]
$ sh upgrade_wm.ksh (the same as above)
upgrade_wm.ksh[9]: exec: upgrade_wm.ksh: not found

In the same directory, I wrote a tiny script which
echos "here".  That's all it does.  Run it after chomd
+x.

$ test1 (still got cannot found message)
-ksh: test1: not found [No such file or directory]
$ sh test1 (Runs! but use sh still doesn't work for
the upgrade_wm.ksh)
here

Thank you for any information!


Leslie

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/(See attached file: upgrade_wm.ksh)


 upgrade_wm.ksh

Re: RE-ENGINEERING OF TABLESPACES

[Rachel Carmichael]

wanna bet?  goddesses know much

but yea, any time I post something that someone else can fix or if I post 
something wrong, just go ahead and post the corrections to the list. Unlike 
you guys, *I* don't believe I'm a goddess :)


>From: "Sakthi , Raj" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE-ENGINEERING OF TABLESPACES
>Date: Thu, 24 May 2001 11:57:53 -0800
>
>Hi Listers ,
>I saw some posts about re-engineering of tablespace
>creation script . This is Rachel's script which I
>Modified to include LMT's . If anybody is wondering ,
>I am posting this with her permission ..;) Any
>'stirring' living being in ORACLE universe dare not
>risk the wrath of 'Goddess'...( Alright Rachel...Am I
>glad you don't know where I live ...! )
>
>SCRIPT STARTS HERE .
>*
>set echo off term on verify off feedback off pagesize
>0
>select 'GENERATING TABLESPACE BUILD SCRIPTS...' from
>DUAL;
>select 'TEMPORARY LMTs NOT GENERATED ' From dual ;
>
>set term off
>DROP TABLE TSPACE_TEMP ;
>create global temporary table TSPACE_TEMP (
> Lineno  NUMBER,
> Tspace_Name VARCHAR2(30),
> TextVARCHAR2(500))
>ON COMMIT delete rows
>/
>
>declare
>cursor TSPACE_CURSOR is
>  select Tablespace_Name,
> Initial_Extent,
> Next_Extent,
> Min_Extents,
> Max_Extents,
> Pct_Increase,
> Min_Extlen,
> Status,
> Contents,
>   extent_management,
>   allocation_type ,
> Logging
>from DBA_TABLESPACES
>   where Tablespace_Name !='SYSTEM' and
>   max_extents is not null ;
>
>cursor DFILE_CURSOR (C_Tablespace_Name VARCHAR2) is
>  select Maxbytes,
> Increment_By,
> File_Name,
> Bytes,
> Status,
> Autoextensible
>from DBA_DATA_FILES
>   where Tablespace_Name = C_Tablespace_Name
>   order by File_ID;
>
>
>Lv_TS_Tablespace_Name
>DBA_TABLESPACES.Tablespace_Name%TYPE;
>Lv_TS_Initial_Extent
>DBA_TABLESPACES.Initial_Extent%TYPE;
>Lv_TS_Next_Extent
>DBA_TABLESPACES.Next_Extent%TYPE;
>Lv_TS_Min_Extents
>DBA_TABLESPACES.Min_Extents%TYPE;
>Lv_TS_Max_Extents
>DBA_TABLESPACES.Max_Extents%TYPE;
>Lv_TS_Pct_Increase
>DBA_TABLESPACES.Pct_Increase%TYPE;
>Lv_TS_Min_Extlen
>DBA_TABLESPACES.Min_Extlen%TYPE;
>Lv_TS_Status
>DBA_TABLESPACES.Status%TYPE;
>Lv_TS_Contents
>DBA_TABLESPACES.Contents%TYPE;
>Lv_Ts_extent_manage
>DBA_TABLESPACES.extent_management%TYPE;
>Lv_Ts_allocation_type
>DBA_TABLESPACES.allocation_type%TYPE;
>Lv_TS_Logging
>DBA_TABLESPACES.Logging%TYPE;
>
>Lv_DF_Maxbytes
>DBA_DATA_FILES.Maxbytes%TYPE;
>Lv_DF_Increment_By
>DBA_DATA_FILES.Increment_By%TYPE;
>Lv_DF_File_Name
>DBA_DATA_FILES.File_Name%TYPE;
>Lv_DF_Bytes
>DBA_DATA_FILES.Bytes%TYPE;
>Lv_DF_Status
>DBA_DATA_FILES.Status%TYPE;
>Lv_DF_Autoextensible
>DBA_DATA_FILES.Autoextensible%TYPE;
>
>Lv_String  VARCHAR2(800);
>Lv_Lineno  NUMBER  := 0;
>Lv_DF_CountNUMBER;
>Lv_Block_Size  NUMBER;
>
>procedure WRITE_OUT(P_Line INTEGER,  P_Tablespace
>VARCHAR2,
>P_String VARCHAR2)
>is
>begin
>   insert into TSPACE_TEMP (Lineno, Tspace_name,
>Text)
>  values (P_Line,P_Tablespace,P_String);
>end;
>
>begin
>
>select Value
>  into Lv_Block_size
>  from SYS.V_$PARAMETER
> where upper(name) = 'DB_BLOCK_SIZE';
>
>open TSPACE_CURSOR;
>loop
>   fetch TSPACE_CURSOR into Lv_TS_Tablespace_Name,
>Lv_TS_Initial_Extent,
>Lv_TS_Next_Extent,
>Lv_TS_Min_Extents,
>Lv_TS_Max_Extents,
>Lv_TS_Pct_Increase,
>Lv_TS_Min_Extlen,
>Lv_TS_Status,
>Lv_TS_Contents,
>Lv_Ts_extent_manage,
>Lv_Ts_allocation_type,
>Lv_TS_Logging;
>   exit when TSPACE_CURSOR%NOTFOUND;
>
>   Lv_Lineno := 1;
>   Lv_DF_Count := 0;
>
>   Lv_String := 'CREATE TABLESPACE ' ||
>LOWER(Lv_TS_Tablespace_Name);
>   WRITE_OUT(Lv_Lineno, Lv_TS_Tablespace_Name,
>Lv_String);
>   Lv_Lineno := Lv_Lineno + 1;
>
>   open DFILE_CURSOR (Lv_TS_Tablespace_Name);
>
>   loop
>  fetch DFILE_CURSOR intoLv_DF_Maxbytes,
>
>Lv_DF_Increment_By,
> Lv_DF_File_Name,
> Lv_DF_Bytes,
> Lv_DF

test, please ignore

[Naik, Sandesh S]

test

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Naik, Sandesh S
  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: [OT] Jobs in UK

[Boivin, Patrice J]

Yeah, good question.

There is never enough info on how to move around, see the sights... earn
money.

: )

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]  

-Original Message-
From:   [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 3:58 PM
To: Multiple recipients of list ORACLE-L
Subject:[OT] Jobs in UK


Hi fellows,

Sorry for the offtopic  but I had been in UK last week and my
friends from
there told me that there is a shortage of IT professionals and ,
that if
you really got the skills , is very easy to migrate and find a job.
But
none of my friends are IT professionals and I don´t know how much
they know
from this market.

So I wish to know , if possible , from the IT professionals working
in UK
if it is really easy to find a job and migrate ? What are the
governamental
restrictions ? How much we can earn in a year of work ? Where I can
find
more information about immigration to UK ?

TIA,
Antonio Belloni

-- 
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: 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: Uwin question ???

[Scott . Shafer]

Did you try th "./" syntax?  i.e.:

$ ./test1

Sorry, I'm not more familiar with Uwin.  If the above syntax works, you can
set your unix $PATH variable to include "." (dot - no quotes)  to specify
the current working directory, i.e.:

export PATH=$PATH:.

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Leslie Lu [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 2:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Uwin question ???
> 
> Hi all,
> 
> A while ago, I asked about running unix script on NT.
> I run into a problem in UWin that I got file not found
> message even if the file is there and is executable. 
> I run a ksh file with and without sh, I kept getting
> "not found".  Then I wrote a test1 script, if run
> without sh, I still got "not found", but if run with
> sh like sh test1, it works.  All the scripts work find
> in Unix.  Attached is upgrade_wm.ksh I'm trying to run
> and following shows the details from UWin:
> 
> $ ls (ls shows upgrade_wm.ksh is in the current
> directory)
> ...
> upgrade_wfm_RefData.sql
> upgrade_wfm_RefData_401.ksh
> upgrade_wm.README
> upgrade_wm.ksh   
> 
> $ upgrade_wm.ksh (run it in the same directory, got
> not found message)
> -ksh: upgrade_wm.ksh: not found [No such file or
> directory]
> $ sh upgrade_wm.ksh (the same as above)
> upgrade_wm.ksh[9]: exec: upgrade_wm.ksh: not found
> 
> In the same directory, I wrote a tiny script which
> echos "here".  That's all it does.  Run it after chomd
> +x.
> 
> $ test1 (still got cannot found message)
> -ksh: test1: not found [No such file or directory]
> $ sh test1 (Runs! but use sh still doesn't work for
> the upgrade_wm.ksh)
> here  
> 
> Thank you for any information!
> 
> 
> Leslie
> 
> __
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/ << File: upgrade_wm.ksh >> 
--
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: Sort of OT but sort of not....

[Kevin Kostyszyn]

Eric,
I didn't re-read what I wrote but apparently it was pretty pathetic, no one
understood it, my aplogies.  It's a file server, it's just a box holding a
big 40 gig IDE drive with templates and such for all of the users and
developers.
Currently it is in a PIII 600, and I could use that box as a developement
box if I add some scsi's and another processor.
So, I figured I would use this little PI 233 as it's replacement to house
the shared drive.  Just wondering what everyone thought of that.  Thanks for
the help!
Kev
-Original Message-
Pierce
Sent: Thursday, May 24, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L


Kevin,

I'm confused, are you talkin' file server or db server,
or both on one machine? is this NT or Win2K?

If db server, what are you using it for? prod, dev, test...?
(& what backup/restore hardware is going to be used?)

regards,
ep


On 24 May 2001, at 7:56, Kevin Kostyszyn wrote:

>   This is more of a network admin question, but I figured I would toss it
out
> there and see what everyone thought.  I currently have a Dell Precision
410
> PIII 600 being used as a sort of file server.  It basically houses a
shared
> drive (IDE) and some other IDE drives used for DB backup.  I need another
DB
> server and it dawned on me that I might be waisting this machine.  Do I
> really need a PIII 600mhz monster to house a shared drive that maybe 10
> users are accessing at once.  Couldn't I just throw these drives into a
> 233mhz Pentium and expect to get the same performace?  Not that it's even
> really doing much...I don't know, any advice would be appreciated.


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

Re: SQL PROBLEM

[Diana_Duncan]

Harvinder,

I think, if I understand the problem, that the following will work:

select ord_id, count(*)
from (select nvl(a.ord_id, b.ord_id) ord_id
 from TableA a, TableB b
 where b.line_id = a.line_id
 union all
 select ord_id
 from TableA
 where line_id is null
)
group by ord_id
/

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   

Harvinder Singh

   
aTech.com>   cc:   

Sent by: Fax to:   

[EMAIL PROTECTED] Subject: SQL PROBLEM  

   

   

05/24/2001 02:46 PM

Please respond to  

ORACLE-L   

   

   





Hi,

Favour me in suggest a hint in writing a sql for following scenaio:

Table A has 2 columns ord_id and line_id

example rows are:

ord_id line_id
17null
null  42

Table  B has columns ord_id and line_id

ord_id line_id
1742
1743
1744

I have to write a sql to count(*) from table A where ord_id=17 ..
as u see from table B line 42 is row of ord_id=17 ..so i want
count(*) should show =2 from tabel A
but if i do count(*) from table A where ord_id=17..it shows 1..
i need to put another condition which will check line id with
TABLE B and if it is  for this particular order ...add that also in
count(*).
I know scenario is little fuzzy sorry for it..but if u got my point
kindly respond.

Thanks
Harvinder



-- 
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: OT RE: BUNYAMIN POSTS HAVE A VIRUS

[Dasko, Dan]

Are you an idiot?

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 4:24 PM
To: Multiple recipients of list ORACLE-L


Thanks to Patrice B. for that...  

I am not worthy - I am pig fundament...

HELP

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 2:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT RE: BUNYAMIN POSTS HAVE A VIRUS
> 
> I love the fact that you corrected the
> spelling in your sig. 
> 
> There is hope! 
> 
> :)
> 
> || -Original Message-
> || From: [EMAIL PROTECTED]
> || [mailto:[EMAIL PROTECTED]]
> || Sent: Thursday, May 24, 2001 12:56 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: BUNYAMIN POSTS HAVE A VIRUS
> || 
> || 
> || Selectively, to individual email addresses.  Or is everyone 
> || getting hit?
> || 
> || Scott Shafer
> || San Antonio, TX
> || 210-581-6217
> || 
> || "And no amount of training or preparedness can eliminate the almost
> || certainty that in the middle of your Angry Crane stance, as 
> || you transition
> || to your Combative Monkey to administer the Coup de Grâce via 
> || your Ninja
> || Death Touch, you step on a beer bottle and fall backwards 
> || into the juke box
> || and get your head stove in by a drunk with a pool cue."  --Jay Trigg
> || 
> || > -Original Message-
> || > From:Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> || > Sent:Thursday, May 24, 2001 10:17 AM
> || > To:  Multiple recipients of list ORACLE-L
> || > Subject: BUNYAMIN POSTS HAVE A VIRUS
> || > 
> || > "This individual", BUNYAMIN, appears
> || > to be squirting virus code...yes...
> || > 
> || > || -Original Message-
> || > || From: [EMAIL PROTECTED]
> || > || [mailto:[EMAIL PROTECTED]]
> || > || Sent: Thursday, May 24, 2001 10:27 AM
> || > || To: Multiple recipients of list ORACLE-L
> || > || Subject: FW: RE: MICROSOFTDTPROPERTIES 
> || > || 
> || > || 
> || > || If anyone receives mail from this individual, please scan 
> || > || any attatchments
> || > || as it contains the W32/BadTrans@MM vi*us...
> || > || 
> || > || Scott Shafer
> || > || San Antonio, TX
> || > || 210-581-6217
> || > || 
> || > || "And no amount of training or preparedness can 
> || eliminate the almost
> || > || certainty that in the middle of your Angry Crane stance, as 
> || > || you transition
> || > || to your Combative Monkey to administer the Coup de Grâce via 
> || > || your Ninja
> || > || Death Touch, you step on a beer bottle and fall backwards 
> || > || into the juke box
> || > || and get your head stove in by a drunk with a pool cue." 
> ||  --Jay Trigg
> || > || 
> || > || > -Original Message-
> || > || > From:   Bunyamin K. Karadeniz
> [SMTP:[EMAIL PROTECTED]]
> || > || > Sent:   None
> || > || > To: [EMAIL PROTECTED]
> || > || > Subject:Re: RE: MICROSOFTDTPROPERTIES  
> || > || > 
> || > || > '[EMAIL PROTECTED]' wrote:
> || > || > 
> || > || > - The developer created the table and now doesn't know 
> || > || what is does???  
> || > || > - As penance, said developer(s) must write "I will 
> || > || document all changes
> || > || > fully"
> || > || > - and "RTFM" in their own blood, 10,000 times on the floor 
> || > || without using
> || > || > their
> || > || > - hands.
> || > || > - 
> || > || > - Then:
> || > || > - 1)  export tables=MICROSOFTDTPROPERTIES ... || options here>
> || > || > - 2)  DROP TABLE MICROSOFTDTPROPERTIES;
> || > || > - 3)  see who/what/if anything breaks, whines, or snivels...
> || > || > - 
> || > || > - All assuming this is a developm ...'
> || > || > 
> || > || > 
> || > || > > Take a look to the attachment. 
> || > || > 
> || > || >  <> 
> || > || 
> || > 
> || -- 
> || 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: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat 

RE: Oracle Applications Suite CDs.

[Sherman, Edward]

Get ready for some "mystery meat" web page navigation.

Go to http://www.oracle.com
Click on the "Oracle Store" Button
You should see a row of tabs near the top of the page.
Click on the "Applications" tab.
After the "Applications" tab is selected click on the "CD Packs" link
(just under and to the left of the "Applications" tab).

Now you should see a list of Financial Applications products.
They are $39.95 each.

I'm gussing you want Oracle Applications 11i (You choose the OS).
You'll get a box of about 40 CDs. 

HTH
Ed



-Original Message-
Sent: Thursday, May 24, 2001 2:52 PM
To: Multiple recipients of list ORACLE-L


I would like to know how to obtain a trial or developer version of the
Oracle Applications Suite...

: )

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


* * * * * Freedom of Information Act Notice * * * * * 
The information in this email is subject to the record protection mandated
by 5 United States Code 552(b)(4) and relevant judicial opinions. 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sherman, Edward
  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).

large pool

[Jake MacGruder]

Hi there,

What exactly is the large pool used for?

>From Metalink:

"The two main uses of the large pool in Oracle 8 are:

a. For the User Global Area (UGA) of sessions
connected using MTS (multi-threaded server)

b. Buffering for sequential file IO (Eg: as used by
server managed recovery when there are multiple IO
slaves)"

I'm not using MTS, so I'm not worried about "a".

What do they mean by "Buffering for sequential file
IO"? Full table scans? 


Thanks,

J






__
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: Jake MacGruder
  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 Development Tool - EasySQL?

[Mohan, Ross]

Aye, that I do, laddie!

|| -Original Message-
|| From: Hillman, Alex [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 24, 2001 3:33 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Oracle Development Tool - EasySQL?
|| 
|| 
|| You mean EZSQL I think.
|| 
|| Alex Hillman
|| 
|| -Original Message-
|| Sent: Thursday, May 24, 2001 11:23 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| how might you compare PL/SQL Developer and EasySQL?
|| 
|| || -Original Message-
|| || From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| || Sent: Thursday, May 24, 2001 10:57 AM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: Oracle Development Tool
|| || 
|| || 
|| || I think PL/SQL Developer blows away Toad especially since 
|| it is only
|| || $150-$50 depending on how many you buy compared to $750 
|| buying toad.
|| || AllAround Automations sells it.  Anyone I have shown it to 
|| || (SQL Nav users,
|| || Toad) and they have "seen the light".
|| || 
|| || 
|| || "Walking on water and developing software from a 
|| || specification are easy if
|| || both are frozen."
|| || 
|| || Christopher R. Spence
|| || Oracle DBA
|| || Fuelspot 
|| || 
|| || 
|| || 
|| || -Original Message-
|| || Sent: Thursday, May 24, 2001 9:26 AM
|| || To: Multiple recipients of list ORACLE-L
|| || 
|| || 
|| || Hi Deepak,
|| || 
|| || I'd go with TOAD, why? well I have been using it since it 
|| || was a freeware (we
|| || bought it finally) and am very comfortable with what it does 
|| || and how easy it
|| || makes things.
|| || 
|| || Hats off to TOADMAN !
|| || 
|| || HTH
|| || Raj
|| || __
|| || Rajendra JamadagniMIS, 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 !
|| || 
|| || *
|| || 4
|| || 
|| || 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.
|| || 
|| || *
|| || 4
|| || 
|| || -- 
|| || 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).
|| || -- 
|| || 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: Mohan, Ross
||   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: Hillman, Alex
||   INET: [EMA

Re: Uwin question ???

[Thater, William]

On Thu, 24 May 2001,Leslie Lu scribbled on the wall in glitter crayon:

->$ test1 (still got cannot found message)
->-ksh: test1: not found [No such file or directory]
->$ sh test1 (Runs! but use sh still doesn't work for
->the upgrade_wm.ksh)
->here
->
->Thank you for any information!
->
->
->Leslie

try running it under ksh as:
$./upgrade_Wm.ksh
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates.

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

[Bowes, Chris]

Title: RE: Maximo




  
  Hi 
  James,
   
   No we didn't use MTS.  
  We were on an NT server and it seemed to do a lot better when we analyzed 
  everything using compute stats and analyzing all indexed columns and setting 
  up histograms for it.  Also check all the indexes and their columns, we 
  ran into a lot of them that were just crazy.  On several tables the 
  change number field was indexed.  It's not used in any queries, but it 
  was indexed.  There were indexes on change dates.  Then there 
  were things like the workorder number not being indexed in some of the tables 
  for the workorder module.  It was absurd.  I hope the newer versions 
  are better as I'll be going back to them soon.  If I can think of 
  anything else, I'll let you know.   HTH.
  --Chris [EMAIL PROTECTED] 
   
  
-Original Message-From: James Xing 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 
1:37 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Maximo
Thanks Chris, 
Did you turn on MTS on your production server? Is that 
recommended?
In 
our environment, the system was fine on dev server which is not using 
MTS, another DBA who is in charge of production server turned MTS 
on and found the performance is 4 times 
slower.  
 
James

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: 
  Wednesday, May 23, 2001 8:28 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Maximo
  ON all the maximo installations I have done, the biggest 
  problems have been with maxencrypt a table that holds the encrypted key 
  that allows everyone in the base.  There is a script that will reset 
  this if the users cannot get into the system.   Make sure that 
  the character set in the client is set to the same as the base.  If 
  users cannot get into the base due to bad password and you *know* the 
  user/password are correct, then something happened to the maxencrypt 
  and/or the character sets are not the same.  I am hoping that 4i 
  eliminates that table, but since I haven't seen it, I don't know if it 
  does.
  I don't know about the current version, but when I worked 
  with it about a year ago, the indexes were terrible.  We dropped and 
  created a number of indexes to improve things.  We used cost base 
  optimization (oracle v7 at the time) and and a job that analyzed every 
  couple weeks on the big tables and every month on the others.
  If you have to do an import of the base, you will need to 
  run the maxora??.sql script that creates a couple views under sys.  I 
  am sorry that I cannot remember the script at this moment.   
  I'll check with some of my old comrades and see if they can remember 
  it.  
  If you're moving to production, you probably have all the 
  columns defined and sized.  If not, sometimes the column changes do 
  not get registered in the maxsyscols table and you'll need to update 
  it.
  Otherwise, the system really does quite well once it is 
  running.  If I can think of anything else I'll re-reply. 
  --Chris [EMAIL PROTECTED] 
  -Original Message- From: 
  James Xing [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, May 22, 2001 6:15 PM To: Multiple recipients of list ORACLE-L Subject: Maximo 
  Hi Group, 
  I have a Maximo system moving into production, using 
  Oracle 816/Sun solaris If anyone has experience, 
  from DBA point of view, what I should be care of? anything to change/check? any particular table? 
  Thanks James 
  -- Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com -- 
  Author: James Xing   
  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: OT RE: BUNYAMIN POSTS HAVE A VIRUS

[Scott . Shafer]

Thanks to Patrice B. for that...  

I am not worthy - I am pig fundament...

HELP

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 2:20 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  OT RE: BUNYAMIN POSTS HAVE A VIRUS
> 
> I love the fact that you corrected the
> spelling in your sig. 
> 
> There is hope! 
> 
> :)
> 
> || -Original Message-
> || From: [EMAIL PROTECTED]
> || [mailto:[EMAIL PROTECTED]]
> || Sent: Thursday, May 24, 2001 12:56 PM
> || To: Multiple recipients of list ORACLE-L
> || Subject: RE: BUNYAMIN POSTS HAVE A VIRUS
> || 
> || 
> || Selectively, to individual email addresses.  Or is everyone 
> || getting hit?
> || 
> || Scott Shafer
> || San Antonio, TX
> || 210-581-6217
> || 
> || "And no amount of training or preparedness can eliminate the almost
> || certainty that in the middle of your Angry Crane stance, as 
> || you transition
> || to your Combative Monkey to administer the Coup de Grâce via 
> || your Ninja
> || Death Touch, you step on a beer bottle and fall backwards 
> || into the juke box
> || and get your head stove in by a drunk with a pool cue."  --Jay Trigg
> || 
> || > -Original Message-
> || > From:Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> || > Sent:Thursday, May 24, 2001 10:17 AM
> || > To:  Multiple recipients of list ORACLE-L
> || > Subject: BUNYAMIN POSTS HAVE A VIRUS
> || > 
> || > "This individual", BUNYAMIN, appears
> || > to be squirting virus code...yes...
> || > 
> || > || -Original Message-
> || > || From: [EMAIL PROTECTED]
> || > || [mailto:[EMAIL PROTECTED]]
> || > || Sent: Thursday, May 24, 2001 10:27 AM
> || > || To: Multiple recipients of list ORACLE-L
> || > || Subject: FW: RE: MICROSOFTDTPROPERTIES 
> || > || 
> || > || 
> || > || If anyone receives mail from this individual, please scan 
> || > || any attatchments
> || > || as it contains the W32/BadTrans@MM vi*us...
> || > || 
> || > || Scott Shafer
> || > || San Antonio, TX
> || > || 210-581-6217
> || > || 
> || > || "And no amount of training or preparedness can 
> || eliminate the almost
> || > || certainty that in the middle of your Angry Crane stance, as 
> || > || you transition
> || > || to your Combative Monkey to administer the Coup de Grâce via 
> || > || your Ninja
> || > || Death Touch, you step on a beer bottle and fall backwards 
> || > || into the juke box
> || > || and get your head stove in by a drunk with a pool cue." 
> ||  --Jay Trigg
> || > || 
> || > || > -Original Message-
> || > || > From:   Bunyamin K. Karadeniz
> [SMTP:[EMAIL PROTECTED]]
> || > || > Sent:   None
> || > || > To: [EMAIL PROTECTED]
> || > || > Subject:Re: RE: MICROSOFTDTPROPERTIES  
> || > || > 
> || > || > '[EMAIL PROTECTED]' wrote:
> || > || > 
> || > || > - The developer created the table and now doesn't know 
> || > || what is does???  
> || > || > - As penance, said developer(s) must write "I will 
> || > || document all changes
> || > || > fully"
> || > || > - and "RTFM" in their own blood, 10,000 times on the floor 
> || > || without using
> || > || > their
> || > || > - hands.
> || > || > - 
> || > || > - Then:
> || > || > - 1)  export tables=MICROSOFTDTPROPERTIES ... || options here>
> || > || > - 2)  DROP TABLE MICROSOFTDTPROPERTIES;
> || > || > - 3)  see who/what/if anything breaks, whines, or snivels...
> || > || > - 
> || > || > - All assuming this is a developm ...'
> || > || > 
> || > || > 
> || > || > > Take a look to the attachment. 
> || > || > 
> || > || >  <> 
> || > || 
> || > 
> || -- 
> || 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: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --

Re: [OT] Jobs in UK

[Diana_Duncan]

My husband is Scottish, and he heard from a Scottish pal of his that top
Oracle consultants can earn up to ?1000 a day in Edinburgh!  Made me want
to up and go, I'll tell you...then again, having a husband with a British
passport means I can work without too many problems.

Regards,

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   
  
antonio.belloni@hst
  
ern.com.br To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>   
Sent by:   cc: 
  
[EMAIL PROTECTED]   Fax to: 
  
   Subject: [OT] Jobs in UK
  
   
  
05/24/2001 02:57 PM
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  





Hi fellows,

Sorry for the offtopic  but I had been in UK last week and my friends from
there told me that there is a shortage of IT professionals and , that if
you really got the skills , is very easy to migrate and find a job. But
none of my friends are IT professionals and I don´t know how much they know
from this market.

So I wish to know , if possible , from the IT professionals working in UK
if it is really easy to find a job and migrate ? What are the governamental
restrictions ? How much we can earn in a year of work ? Where I can find
more information about immigration to UK ?

TIA,
Antonio Belloni

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

[Charlie Mengler]

In my experience MTS was (I've stopped using it) 4 - 6 TIMES
slower than using a dedicated connection. This was consistently
measured during our "nightwork batch processing" over multiple
nights over multiple weeks. Using MTS, one stream was taking
4 - 6 hours to complete. Whenever we ran it via a dedicated
connection the run times shrunk to right around 1 HOUR!

At the time I had 32 servers and only 1 - 4 single threaded
job streams running against the instance.

FWIW - Solaris V2.6 & Oracle V7.3.4.5

[EMAIL PROTECTED] wrote:
> 
> James,
> 
> In general I notice that MTS can slow things down IF there are not enough
> shared servers running so that at least one server is constantly idle.
> 
> Dick Goulet
> 
> Reply Separator
> Author: "James Xing" <[EMAIL PROTECTED]>
> Date:   5/24/2001 9:36 AM
> 
> RE: MaximoThanks Chris,
> Did you turn on MTS on your production server? Is that recommended?
> In our environment, the system was fine on dev server which is not using
> MTS, another DBA who is in charge of production server turned MTS on and
> found the performance is 4 times slower.
> 
> James
>   -Original Message-
>   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, Chris
>   Sent: Wednesday, May 23, 2001 8:28 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: RE: Maximo
> 
>   ON all the maximo installations I have done, the biggest problems have
> been with maxencrypt a table that holds the encrypted key that allows
> everyone in the base.  There is a script that will reset this if the users
> cannot get into the system.   Make sure that the character set in the client
> is set to the same as the base.  If users cannot get into the base due to
> bad password and you *know* the user/password are correct, then something
> happened to the maxencrypt and/or the character sets are not the same.  I am
> hoping that 4i eliminates that table, but since I haven't seen it, I don't
> know if it does.
> 
>   I don't know about the current version, but when I worked with it about a
> year ago, the indexes were terrible.  We dropped and created a number of
> indexes to improve things.  We used cost base optimization (oracle v7 at the
> time) and and a job that analyzed every couple weeks on the big tables and
> every month on the others.
> 
>   If you have to do an import of the base, you will need to run the
> maxora??.sql script that creates a couple views under sys.  I am sorry that
> I cannot remember the script at this moment.   I'll check with some of my
> old comrades and see if they can remember it.
> 
>   If you're moving to production, you probably have all the columns defined
> and sized.  If not, sometimes the column changes do not get registered in
> the maxsyscols table and you'll need to update it.
> 
>   Otherwise, the system really does quite well once it is running.  If I can
> think of anything else I'll re-reply.
> 
>   --Chris
>   [EMAIL PROTECTED]
> 
>   -Original Message-
>   From: James Xing [mailto:[EMAIL PROTECTED]]
>   Sent: Tuesday, May 22, 2001 6:15 PM
>   To: Multiple recipients of list ORACLE-L
>   Subject: Maximo
> 
>   Hi Group,
> 
>   I have a Maximo system moving into production, using Oracle 816/Sun
> solaris
>   If anyone has experience, from DBA point of view, what I should be care
> of?
>   anything to change/check? any particular table?
> 
>   Thanks
>   James
> 
>   --
>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
>   --
>   Author: James Xing
> 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: Maximo
> 
> 
> 
> Thanks
> 
> Chris, 
> Did
> you turn on MTS on your production server? Is that
> recommended?
> In our
> 
> environment, the system was fine on dev server which is not using
> MTS, another DBA who is in charge of production server turned MTS on
> and found the performance is 4 times slower.  
>  size=2> 
>  size=2>James
> 
>  size=2>-Original Message-From: [EMAIL PROTECTED]
>   [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent:
>   Wednesday, May 23, 2001 8:28 AMTo: Multiple recipients of list
>   ORACLE-LSubject: RE: Maximo
>   ON all the maximo installations I have done, the biggest
>   problems have been with maxencrypt a table that holds the encrypted key that
>   allows everyone in the base.  There is a script that will reset this if
>   the users cannot get into the system.   Make sur

RE: Database Trigger Confusion

[Jamadagni, Rajendra]

Brian is right,

why not compare old and new values and handle this programmatically?

HTH
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).

RE-ENGINEERING OF TABLESPACES

[Sakthi , Raj]

Hi Listers ,
I saw some posts about re-engineering of tablespace
creation script . This is Rachel's script which I
Modified to include LMT's . If anybody is wondering ,
I am posting this with her permission ..;) Any
'stirring' living being in ORACLE universe dare not
risk the wrath of 'Goddess'...( Alright Rachel...Am I
glad you don't know where I live ...! )

SCRIPT STARTS HERE .
*
set echo off term on verify off feedback off pagesize
0 
select 'GENERATING TABLESPACE BUILD SCRIPTS...' from
DUAL;
select 'TEMPORARY LMTs NOT GENERATED ' From dual ;

set term off
DROP TABLE TSPACE_TEMP ;
create global temporary table TSPACE_TEMP (
Lineno  NUMBER,
Tspace_Name VARCHAR2(30),
TextVARCHAR2(500))
ON COMMIT delete rows 
/

declare
   cursor TSPACE_CURSOR is
 select Tablespace_Name,
Initial_Extent,
Next_Extent,
Min_Extents,
Max_Extents,
Pct_Increase,
Min_Extlen,
Status,
Contents,
extent_management,
allocation_type ,
Logging
   from DBA_TABLESPACES
  where Tablespace_Name !='SYSTEM' and 
max_extents is not null ;

   cursor DFILE_CURSOR (C_Tablespace_Name VARCHAR2) is
 select Maxbytes,
Increment_By,
File_Name,
Bytes,
Status,
Autoextensible
   from DBA_DATA_FILES 
  where Tablespace_Name = C_Tablespace_Name
  order by File_ID;


   Lv_TS_Tablespace_Name 
DBA_TABLESPACES.Tablespace_Name%TYPE;
   Lv_TS_Initial_Extent  
DBA_TABLESPACES.Initial_Extent%TYPE;
   Lv_TS_Next_Extent 
DBA_TABLESPACES.Next_Extent%TYPE;
   Lv_TS_Min_Extents 
DBA_TABLESPACES.Min_Extents%TYPE;
   Lv_TS_Max_Extents 
DBA_TABLESPACES.Max_Extents%TYPE;
   Lv_TS_Pct_Increase
DBA_TABLESPACES.Pct_Increase%TYPE;
   Lv_TS_Min_Extlen  
DBA_TABLESPACES.Min_Extlen%TYPE;
   Lv_TS_Status  
DBA_TABLESPACES.Status%TYPE;
   Lv_TS_Contents
DBA_TABLESPACES.Contents%TYPE;
   Lv_Ts_extent_manage  
DBA_TABLESPACES.extent_management%TYPE;
   Lv_Ts_allocation_type
DBA_TABLESPACES.allocation_type%TYPE;
   Lv_TS_Logging 
DBA_TABLESPACES.Logging%TYPE;

   Lv_DF_Maxbytes
DBA_DATA_FILES.Maxbytes%TYPE;
   Lv_DF_Increment_By
DBA_DATA_FILES.Increment_By%TYPE;
   Lv_DF_File_Name   
DBA_DATA_FILES.File_Name%TYPE;
   Lv_DF_Bytes   
DBA_DATA_FILES.Bytes%TYPE;
   Lv_DF_Status  
DBA_DATA_FILES.Status%TYPE;
   Lv_DF_Autoextensible  
DBA_DATA_FILES.Autoextensible%TYPE;

   Lv_String  VARCHAR2(800);
   Lv_Lineno  NUMBER  := 0;
   Lv_DF_CountNUMBER;
   Lv_Block_Size  NUMBER;

   procedure WRITE_OUT(P_Line INTEGER,  P_Tablespace
VARCHAR2, 
   P_String VARCHAR2)
   is
   begin
  insert into TSPACE_TEMP (Lineno, Tspace_name,
Text)
 values (P_Line,P_Tablespace,P_String);
   end;

begin
 
   select Value
 into Lv_Block_size
 from SYS.V_$PARAMETER
where upper(name) = 'DB_BLOCK_SIZE';

   open TSPACE_CURSOR;
   loop
  fetch TSPACE_CURSOR into Lv_TS_Tablespace_Name,
   Lv_TS_Initial_Extent,
   Lv_TS_Next_Extent,
   Lv_TS_Min_Extents,
   Lv_TS_Max_Extents,
   Lv_TS_Pct_Increase,
   Lv_TS_Min_Extlen,
   Lv_TS_Status,
 Lv_TS_Contents,
 Lv_Ts_extent_manage,
 Lv_Ts_allocation_type,
   Lv_TS_Logging;
  exit when TSPACE_CURSOR%NOTFOUND;
   
  Lv_Lineno := 1;
  Lv_DF_Count := 0;

Lv_String := 'CREATE TABLESPACE ' ||
LOWER(Lv_TS_Tablespace_Name);
  WRITE_OUT(Lv_Lineno, Lv_TS_Tablespace_Name,
Lv_String);
  Lv_Lineno := Lv_Lineno + 1;

  open DFILE_CURSOR (Lv_TS_Tablespace_Name);

  loop
 fetch DFILE_CURSOR intoLv_DF_Maxbytes,
   
Lv_DF_Increment_By,
Lv_DF_File_Name,
Lv_DF_Bytes,
Lv_DF_Status,
   
Lv_DF_Autoextensible;
 exit when DFILE_CURSOR%NOTFOUND;
 Lv_DF_Count := Lv_DF_Count + 1;

 if (Lv_DF_Count > 1)
 then
  Lv_String := ',''';
 else
Lv_String := 'DATAFILE ''';
 end if;

 Lv_String := Lv_String || Lv_DF_File_Name
|| ''' SIZE '
 

Re: Database Trigger Confusion

[Chaim . Katz]

I think your trigger is fine; the problem might be that some front-end tools
(forms by default?) generate an UPDATE statement that affects all the columns of
the table - even if only a one field was  changed. Think of it this way, UPDATE
table SET col1=col1 doesn't change any values but it does update the column and
it does fire the trigger.
hth
Chaim




"Yexley Robert D SSgt AFIT/SCA" <[EMAIL PROTECTED]> on 05/24/2001 01:51:16
PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)




I have created a trigger on a table to write information to a history table,
and I've run into some behavior that's confusing me...some clarification
would be greatly appreciated.

My trigger code is as follows:

CREATE OR REPLACE TRIGGER endb.budget_total_amt_hist_trg
 BEFORE UPDATE of total_amt_auth, expiration on endb.budget
 FOR EACH ROW
 BEGIN
  
 END;

Now my confusion lies in the fact that the trigger is supposed to fire ONLY
when either the total_amt_auth column OR the expiration column gets updated.
Now, of course it works fine when we update either of those columns.  But
the problem/confusion is why is it also firing when we update other fields
in the table also??  If we update any column other than those two the
trigger still fires.  What am I doing wrong or missing/forgetting???

-::YEX::-

Robert D. Yexley, SSgt
Air Force Institute of Technology
Applications Services Division (SCA)
Oracle DBA & Programmer
<)))><

[EMAIL PROTECTED]
DSN - 785-6565 x-4268
Commercial - (937) 255-6565 x-4268
_
"God who gave us life gave us liberty.
Can the liberties of a nation be secure
when we have removed a conviction
that these liberties are a gift of God?
Indeed I tremble for my country when
I reflect that God is just, that his
justice cannot sleep forever."
   - Thomas Jefferson, 3rd US President
__


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D SSgt AFIT/SCA
  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: Listener.log....writing to renamed file

[gregory . t . norris]

Issue the SET LOG_FILE command using lsnrctl, then move/delete/whatever 
the old file.

-Original Message-
Sent: Thursday, May 24, 2001 1:58 PM
To: ORACLE-L; Xiangli.Li



May I know how to clear the content of listener.log without restart 
listener on NT platform ? 

thanks. 
Li 

-Original Message- 
From:   Brian MacLean [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, May 24, 2001 1:42 PM 
To: Multiple recipients of list ORACLE-L 
Subject:    RE: Listener.logwriting to renamed file 

Reload doesn't close/reopen the file.  Here is a couple 
solutions   

How's about a fast cat/clear solution: 

#!/bin/ksh
cat listener.log >>listener.log.hist
ex listener.log As a regular maintainance work,I have moved the listener.log file to
->listener.log.old
->and 'touch'ed the listener.log, expecting the logging into this new 
file.
->But I am observing the logging being done to listener.log.old, 
instead.
->I could not recall any such previous experience.
->FYI, I cannot do any 'experiments' as far as this system is concerned 
as I
->have to deal with
->desupported HP-UX(10.01), Oracle (7.2.2.3).
->I have my logging being done to default 
path($ORACLE_HOME/network/log), as
->no parameter settings in listener.ora.
->Has anybody experienced this?
->
->TIA,
->
->Suren
->Oracle DBA
->Sony Electronics Ltd.
->
->
The file handle listener is using is still pointed at the old file.  To 
fix this you need to stop and start the listener.  This will not affect 
anybody who is already connected.  I'm not sure if a reload will do the 
same thing.

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.    [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates. 

--
Please see the official ORACLE-L FAQ: < http://www.orafaq.com>
--
Author: Thater, William
  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: Odd core dump - possibly listener related

[Deshpande, Kirti]

Hi Lisa, 
Yes, we have seen this occasional core dump in the ?/dbs dir. Tried to chase
it down, gave up on OWS and TAR got closed. The last time it happened was a
month or so ago on HP-UX 11.0 and 8.1.6.2.  As you said, there are many
other things to worry about. 
 If your 'mini-me' chases this down, I would like to know. BTW... How does
he like Oracle's new music selection?

 Congratulations for getting another job !!
 Going further South or back to North? 

 Regards,

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

> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 10:57 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Odd core dump - possibly listener related
> 
> Hello all, 
>  
> My mini-me (aka Junior DBA) noticed a core dump this morning.  Good,
> attention to detail.  However, there's no unusual errors in the alert log
> for either databases on this host and there's no errors in the listener
> log at all.  The core dump says something about pseudo cursor and
> references a port that isn't dedicated to the listener.  
>  
> Here's my take on it:  The database is fine.  The listener is fine.  The
> app is fine.  With nothing in the logs I have no idea where to look.  I
> don't even know how this core dump ended up in $ORACLE_HOME/dbs (the
> default), my core_dump_dest is set to a different directory.  Searching on
> metalink returns nothing.
>  
> Mini-me (mini?  6'4") wants to chase this down.  I think it works, don't
> fix it.  The occasional core dump is normal and there are a ton of other
> things to attend to.  Does anyone disagree?
>  
> So my question is, has anyone seen this before?  we are hp/ux 11.0,
> 8.1.6.2
>  
> Thanks everyone, and au revoir.  I start a new job on Tuesday.
>  
> Lisa Rutland Koivu
> Oracle Database Administrator "urn:schemas-microsoft-com:office:office" />
> 
> Certified Self-Important Database Deity
> 
> Slayer of Unix Administrators
> 
> Wanton Kickboxing Goddess
> 
> 
> 
>  
> 
> 
> 
> 
> 
>  
> 
>  
> 
>  
> 
>  
-- 
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: Odd core dump - possibly listener related

[Koivu, Lisa]

Title: RE: Odd core dump - possibly listener related





Hi Kirti, 


Thanks very much for your response.  I"m glad someone else has seen this.  I agree, there's other things to worry about.

I'm going North - 4 miles north of here... Darn.  Still in FL.


New music?  what?  


Have a great day!


Lisa 


-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 2:28 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Odd core dump - possibly listener related



Hi Lisa, 
Yes, we have seen this occasional core dump in the ?/dbs dir. Tried to chase
it down, gave up on OWS and TAR got closed. The last time it happened was a
month or so ago on HP-UX 11.0 and 8.1.6.2.  As you said, there are many
other things to worry about. 
 If your 'mini-me' chases this down, I would like to know. BTW... How does
he like Oracle's new music selection?


 Congratulations for getting another job !!
 Going further South or back to North? 


 Regards,


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


> -Original Message-
> From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 10:57 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Odd core dump - possibly listener related
> 
> Hello all, 
>  
> My mini-me (aka Junior DBA) noticed a core dump this morning.  Good,
> attention to detail.  However, there's no unusual errors in the alert log
> for either databases on this host and there's no errors in the listener
> log at all.  The core dump says something about pseudo cursor and
> references a port that isn't dedicated to the listener.  
>  
> Here's my take on it:  The database is fine.  The listener is fine.  The
> app is fine.  With nothing in the logs I have no idea where to look.  I
> don't even know how this core dump ended up in $ORACLE_HOME/dbs (the
> default), my core_dump_dest is set to a different directory.  Searching on
> metalink returns nothing.
>  
> Mini-me (mini?  6'4") wants to chase this down.  I think it works, don't
> fix it.  The occasional core dump is normal and there are a ton of other
> things to attend to.  Does anyone disagree?
>  
> So my question is, has anyone seen this before?  we are hp/ux 11.0,
> 8.1.6.2
>  
> Thanks everyone, and au revoir.  I start a new job on Tuesday.
>  
> Lisa Rutland Koivu
> Oracle Database Administrator
> "urn:schemas-microsoft-com:office:office" />
> 
> Certified Self-Important Database Deity
> 
> Slayer of Unix Administrators
> 
> Wanton Kickboxing Goddess
> 
> 
> 
>  
> 
> 
> 
> 
> 
>  
> 
>  
> 
>  
> 
>  

Uwin question ???

[Leslie Lu]

Hi all,

A while ago, I asked about running unix script on NT.
I run into a problem in UWin that I got file not found
message even if the file is there and is executable. 
I run a ksh file with and without sh, I kept getting
"not found".  Then I wrote a test1 script, if run
without sh, I still got "not found", but if run with
sh like sh test1, it works.  All the scripts work find
in Unix.  Attached is upgrade_wm.ksh I'm trying to run
and following shows the details from UWin:

$ ls (ls shows upgrade_wm.ksh is in the current
directory)
...
upgrade_wfm_RefData.sql
upgrade_wfm_RefData_401.ksh
upgrade_wm.README
upgrade_wm.ksh   

$ upgrade_wm.ksh (run it in the same directory, got
not found message)
-ksh: upgrade_wm.ksh: not found [No such file or
directory]
$ sh upgrade_wm.ksh (the same as above)
upgrade_wm.ksh[9]: exec: upgrade_wm.ksh: not found

In the same directory, I wrote a tiny script which
echos "here".  That's all it does.  Run it after chomd
+x.

$ test1 (still got cannot found message)
-ksh: test1: not found [No such file or directory]
$ sh test1 (Runs! but use sh still doesn't work for
the upgrade_wm.ksh)
here  

Thank you for any information!


Leslie

__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
 upgrade_wm.ksh

RE: 8.1.7. and OAS / iAS versions confusion (update -- feedback f

[Seley, Linda]

At least on Solaris, when you install 9iAS it installs the whole kit and
kaboodle, based on 3 fairly generic options (HTTP server only, Standard
Edition, and Enterprise Edition, there is no custom option :-p ).  The only
choice you have is whether or not you want to configure now or later.  If
you want forms/reports, you have to install Enterprise.  Theoretically
you're supposed to be able to go through the installer and select products
you want to remove (I assume that it will let you reinstall them), but since
forms/reports is based on 806 and the old installer it just shows them to
you and won't let you select them for deinstall.  

The recommendation for quite awhile has been to put developer in it's own
oracle home, away from the database.  Seems to me I remember one combination
where if you installed them to the same home svrmgrl wouldn't work.  

I'm still mucking around with this.  Because I had to remove (renamed
actually) the oraInventory in order to be able to reinstall I've lost the
inventory info for the database.  But at this point I've installed 9iAS
first, then the db and separately had the db exist and installed 9iAS.
Again, it's Solaris, not NT.  Given the registry entries for NT I would
hazard a bet that installing 9iAS et al first might be a very good idea.
Oh, this reminds me, it will install a database for you (for database
caching I believe), based off of the 9iAS oracle home.

My next project is to search through the mailing list archives for
oraInventory emails.  There's gotta be a better way to deal with this beast!
(although removing it does give me an iota of satisfaction).

Linda

-Original Message-
Sent: Thursday, May 24, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
f


Oracle responded as follows, when I asked them about that statement re. the
Oracle home:

If you are going to install 9iAS-Enerprise edition  on Unix then there is no
problem but if you are going to install it on windows then it should be in a
separate Oracle_home as documented in the release note.  9iAS-Enterprise
edition has oracle developer server 6i and as you know that 6i-production
should be installed to the default oracle home.

I think I read somewhere that the Forms 6I home is compatible with 8.0.6,
that would explain why it should not go in the same oracle_home as iAS or as
the database... if the database is not 8.0.6..

I guess that means - install iAS as best you can, in a separate Oracle_home.
Then, install Forms and Reports Server separately later if you can, if you
couldn't exclude it using the Custom installation option.

I am preparing an SOP for installing 8.1.7 on NT now, building the one for
iAS will prove interesting... it almost sounds as if I should install Forms
and Reports 6i before I install the database!

Thanks for the reply.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Seley, Linda [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: 8.1.7. and OAS / iAS versions confusion (update
-- feedback f

9iAS is a royal pain in the keister.  Course I just spent 2 16 hour
days
trying to uninstall the Forms and Reports piece and reinstall it
from the
9iAS CDs (can't be done from what I can see, have to uninstall all
of 9iAS),
so it's not my favorite thing.  We have it installed on Solaris.  I
didn't
install 9iAS in what I would consider my 'default' oracle home but
it worked
none-the-less.  My take on it is that they want 9iAS to be your main
oracle
home but any databases you have need to be in a different directory
structure.  Seems odd to me since 'home' is where you are at the
moment
but  Under the 9iAS oracle home it creates the 6iserver oracle
home for
forms/reports.  And yes, forms/reports do use the old installer.
The
orainst and orainst.cm files under 6iserver are not executable, if
you want
to run them you have to change them but they'll work then.  9iAS
itself uses
oraInventory, which I've come to have a strong dislike for.

HTH

Linda


-Original Message-
Sent: Thursday, May 24, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L
feedback
f rom


FYI,

Oracle Support responded as follows:
23-MAY-01 15:16:30

It looks to me that there are some misunderstanding regarding Oracle
product
and components. Let me try to explain it to you.

- We don't have ideal pairs for any products from the usage point of
view.
Forms and reports product managers trying to set certain dates for
the new
releases that may match with certain RDBMS but it doesn't mean that
it only
works with this certain release. Care managers try to ship a bundle
of new
products together for c

RE: Oracle Development Tool - EasySQL?

[Hillman, Alex]

You mean EZSQL I think.

Alex Hillman

-Original Message-
Sent: Thursday, May 24, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L


how might you compare PL/SQL Developer and EasySQL?

|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 24, 2001 10:57 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Oracle Development Tool
|| 
|| 
|| I think PL/SQL Developer blows away Toad especially since it is only
|| $150-$50 depending on how many you buy compared to $750 buying toad.
|| AllAround Automations sells it.  Anyone I have shown it to 
|| (SQL Nav users,
|| Toad) and they have "seen the light".
|| 
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| Sent: Thursday, May 24, 2001 9:26 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Hi Deepak,
|| 
|| I'd go with TOAD, why? well I have been using it since it 
|| was a freeware (we
|| bought it finally) and am very comfortable with what it does 
|| and how easy it
|| makes things.
|| 
|| Hats off to TOADMAN !
|| 
|| HTH
|| 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 !
|| 
|| *
|| 4
|| 
|| 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.
|| 
|| *
|| 4
|| 
|| -- 
|| 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).
|| -- 
|| 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: Mohan, Ross
  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: Hillman, Alex
  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: MS access

[Li, Xiangli]

Title: RE: MS access





it seems only access 2000 supports 2gb files.


thanks.
Li


-Original Message-
From:   Christopher Spence [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 2:12 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: MS access


I believe it is 2gb.
 
 


"Walking on water and developing software from a specification are easy if both are frozen." 


Christopher R. Spence
Oracle DBA
Fuelspot 


-Original Message-
From: Li, Xiangli [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L
Subject: MS access




Hi, List
Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true?

thanks
Li 

Re:RE: Oracle Development Tool - EasySQL?

[dgoulet]

Chris,

Love that saying, aint it the truth!!

Dick Goulet

Reply Separator
Author: Christopher Spence <[EMAIL PROTECTED]>
Date:   5/24/2001 10:25 AM

Never used EasySQL unfortunately.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 24, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L


how might you compare PL/SQL Developer and EasySQL?

|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 24, 2001 10:57 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Oracle Development Tool
|| 
|| 
|| I think PL/SQL Developer blows away Toad especially since it is only
|| $150-$50 depending on how many you buy compared to $750 buying toad.
|| AllAround Automations sells it.  Anyone I have shown it to 
|| (SQL Nav users,
|| Toad) and they have "seen the light".
|| 
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| Sent: Thursday, May 24, 2001 9:26 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Hi Deepak,
|| 
|| I'd go with TOAD, why? well I have been using it since it 
|| was a freeware (we
|| bought it finally) and am very comfortable with what it does 
|| and how easy it
|| makes things.
|| 
|| Hats off to TOADMAN !
|| 
|| HTH
|| 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 !
|| 
|| *
|| 4
|| 
|| 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.
|| 
|| *
|| 4
|| 
|| -- 
|| 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).
|| -- 
|| 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: Mohan, Ross
  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')

[OT] Jobs in UK

[antonio . belloni]

Hi fellows,

Sorry for the offtopic  but I had been in UK last week and my friends from
there told me that there is a shortage of IT professionals and , that if
you really got the skills , is very easy to migrate and find a job. But
none of my friends are IT professionals and I don´t know how much they know
from this market.

So I wish to know , if possible , from the IT professionals working in UK
if it is really easy to find a job and migrate ? What are the governamental
restrictions ? How much we can earn in a year of work ? Where I can find
more information about immigration to UK ?

TIA,
Antonio Belloni

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

Portal Problem

[Nancy McCormick]

We recently installed the 9iAS and the Portal products on 2 Sun Solaris
boxes (1 for the front end, 1 for the back end).  For the first couple of
weeks the Portal product was working smoothly.  However last week the
developers started encountering some errors.  To my knowledge nothing has
changed on the servers or the Oracle products.  But I cannot guarantee that
since once I installed the product and got the word they were functioning, I
went on to other things.  What follows is the information I received from
the developers about the problems.  Can anyone give me a clue as to where to
start looking?  I have checked for invalid objects on the database and
everything appears valid.I also looked in Metalink and go no hits for
any of these error messages.  I'm not sure what the next step should be in
troubleshooting this problem.

Thanks in advance,
Nancy


= Starting Developer's message  =
We can RUN pages and portlets, we cannot EDIT or CREATE new portlets.  If we
try to create a new portlet we get what appears to be help text, but no
wizard pages.  If we try to edit an existing portlet, we get errors similar
to the errors below, which are related to packages owned by Portal30.
However we get the same errors when we sign on as Portal30 and try to edit a
portlet, so it appears to be related to permissions on some other schema's
tables that are referenced in the Portal30 package.  The packages are in the
database and are marked as valid, however since they are wrapped, we cannot
determine what table(s) are missing the appropriate permissions.

*
***  This error occurs when signed on as a non-Portal30 user.
*
Box Background Color
COMBOBOX LOV ERROR:
LOV: "SYSTEM_COLORS"
Parse Message: Query not found, unable to parse.
Find Message: Security Violation for LOV SYSTEM_COLORS
wwv_security.check_comp_privilege: Insufficient privileges.



*
***  These errors occur when signed on as the Portal30 user.
*
Thu, 24 May 2001 14:37:07 GMT

ORA-00942: table or view does not exist
ORA-06512: at "PORTAL30.WWV_DESCRIBE", line 194
ORA-06512: at "PORTAL30.WWV_UIFORM_BUILD", line 5814
ORA-06512: at line 8

  DAD name: portal30
  PROCEDURE  : PORTAL30.wwv_uiform_build.show_right_frame
  URL:
http://server_ip_address:/pls/portal30/PORTAL30.wwv_uiform_build.show_ri
ght_frame?p_wizard_mode=TABLE&p_module_id=1570228603&p_version=2&p_section=5
&p_save_version=3&p_mode=EDIT&p_step=&p_total_steps=3&p_last_reqstep=3&p_for
mlayout_type=STRUCTURED_LAYOUT&p_type=form&p_owner=MY_HLW&p_table_name=HLW_C
USTOMERS&p_orig_field_names=INSERT_TOP*!UPDATE_TOP*!DELETE_TOP*!QUERY_TOP*!R
ESET_TOP*!*TOP_SECTION**!ID*!NAME*!PHONE_NUMBER*!EMAIL_ADDRESS*!ADDRESS_LINE
1*!CITY*!STATE*!POSTAL_CODE*!COUNTRY*!REGION_ID*!*BOTTOM_SECTION**!PREVIOUS*
!NEXT&p_redirect_url=http%3A%2F%2F172.29.102.180%3A%2Fservlet%2Fpage%3F_
pageid%3D3%2C22%26_dad%3Dportal30%26_schema%3DPORTAL30%26_mode%3D3%26p_rende
r%3DLIST%26p_otype%3DAPP%26p_octx%3DMY_HLW.CASEBOOK30_APPLICATION%26p_action
%3D%26p_caller%3DPORTLET%26p_domain%3Dwwc%26p_sub_domain%3Dappexp%26p_rpth%3
D49_APPLICATIONEXPLORER_652602%26p_orderby%3D%26p_request%3D%26p_min_row%3D1
%26p_max_rows%3D49%26p_page_number%3D1


=

Thu, 24 May 2001 14:33:12 GMT

ORA-00942: table or view does not exist
ORA-06512: at "PORTAL30.WWV_DESCRIBE", line 194
ORA-06512: at "PORTAL30.WWV_UIFORM_BUILD", line 2778
ORA-06512: at "PORTAL30.WWV_UIFORM_BUILD", line 5647
ORA-06512: at line 8

  DAD name: portal30
  PROCEDURE  : PORTAL30.wwv_uiform_build.show_header
  URL:
http://server_ip_address:/pls/portal30/PORTAL30.wwv_uiform_build.show_he
ader?p_wizard_mode=TABLE&p_module_id=1564981795&p_version=2&p_section=5&p_sa
ve_version=2&p_mode=EDIT&p_step=&p_total_steps=3&p_last_reqstep=3&p_redirect
_url=http%3A%2F%2F172.29.102.180%3A%2Fservlet%2Fpage%3F_pageid%3D3%2C22%
26_dad%3Dportal30%26_schema%3DPORTAL30%26_mode%3D3%26p_render%3DLIST%26p_oty
pe%3DAPP%26p_octx%3DMY_HLW.CASEBOOK30_APPLICATION%26p_action%3D%26p_caller%3
DPORTLET%26p_domain%3Dwwc%26p_sub_domain%3Dappexp%26p_rpth%3D49_APPLICATIONE
XPLORER_652602%26p_orderby%3D%26p_request%3D%26p_min_row%3D1%26p_max_rows%3D
49%26p_page_number%3D1



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nancy McCormick
  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:RE: MS access

[dgoulet]

LI,

Great idea, wonder where that came from!  Just DON'T push the table
definitions from Access into Oracle via Access. else you'll have objects that
are a nightmare to access forever.

Dick Goulet

Reply Separator
Author: "Li; Xiangli" <[EMAIL PROTECTED]>
Date:   5/24/2001 10:51 AM

Hi , DBAs
Thank you veyr much  for all replies. I think I have to go for oracle.

rgds,
Li

> -Original Message-
> From: Haskins, Ed [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 2:26 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: MS access
> 
> Li,
>  
> 1GB for Access would be huge...and cause very poor performance.  The only
> way to overcome the size limitation is to upgrade to a real
> database...preferably Oracle, but that SQL Server thing would work as well
> for a DB that size.
>  
> Ed Haskins
> Oracle DBA
> Verizon Wireless
>  
> 
>   -Original Message-
>   From: Li, Xiangli [mailto:[EMAIL PROTECTED]]
>   Sent: Thursday, May 24, 2001 11:57 AM
>   To: Multiple recipients of list ORACLE-L
>   Subject: MS access
>   
>   
> 
>   Hi, List 
>   Is there anyone happen to know what's the database size limitation
> for MS access97? I heard it's 1 gigabytes, how to overcome it if that's
> true?
> 
>   thanks 
>   Li 
> 






RE: MS access



Hi , DBAs
Thank you veyr much  for all
replies. I think I have to go for oracle.


rgds,
Li


-Original Message-
From:   Haskins, Ed [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: MS access


Li,
 
1GB for Access would be huge...and
cause very poor performance.  The only way to overcome the size limitation is to
upgrade to a real database...preferably Oracle, but that SQL Server thing would
work as well for a DB that size.

 
Ed Haskins
Oracle DBA
Verizon Wireless
 


-Original Message-
From:
Li, Xiangli [mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]]
Sent:
Thursday, May 24, 2001 11:57 AM
To:
Multiple recipients of list ORACLE-L
Subject: MS access




Hi, List
Is there anyone happen to know what's the
database size limitation for MS access97? I heard it's 1 gigabytes, how to
overcome it if that's true?

thanks
Li 





--
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: Listener.log....writing to renamed file

[Tirumala, Surendra]

Brain, thank you very much , your scripts worked well.
Also thanks to all who responded/responding to my question.
 
Suren

-Original Message-
Sent: Thursday, May 24, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L



Reload doesn't close/reopen the file.  Here is a couple solutions   

How's about a fast cat/clear solution: 

#!/bin/ksh 
cat listener.log >>listener.log.hist 
ex listener.log  ] 
Sent: Thursday, May 24, 2001 7:15 AM 
To: Multiple recipients of list ORACLE-L 


On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter
crayon: 

->Hi List, 
->As a regular maintainance work,I have moved the listener.log file to 
->listener.log.old 
->and 'touch'ed the listener.log, expecting the logging into this new file. 
->But I am observing the logging being done to listener.log.old, instead. 
->I could not recall any such previous experience. 
->FYI, I cannot do any 'experiments' as far as this system is concerned as I

->have to deal with 
->desupported HP-UX(10.01), Oracle (7.2.2.3). 
->I have my logging being done to default path($ORACLE_HOME/network/log), as

->no parameter settings in listener.ora. 
->Has anybody experienced this? 
-> 
->TIA, 
-> 
->Suren 
->Oracle DBA 
->Sony Electronics Ltd. 
-> 
-> 
The file handle listener is using is still pointed at the old file.  To fix
this you need to stop and start the listener.  This will not affect anybody
who is already connected.  I'm not sure if a reload will do the same thing.

-- 
Bill Thater Certifiable ORACLE DBA 
Telergy, Inc.[EMAIL PROTECTED] 
~~ 
You gotta program like you don't need the money, 
You gotta compile like you'll never get hurt, 
You gotta run like there's nobody watching, 
It's gotta come from the heart if you want it to work. 
~~ 
No program done by an undergrad will work after she graduates. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Thater, William 
  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: Tirumala, Surendra
  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: Sort of OT but sort of not....

[Eric D. Pierce]

Kevin,

I'm confused, are you talkin' file server or db server,
or both on one machine? is this NT or Win2K?

If db server, what are you using it for? prod, dev, test...?
(& what backup/restore hardware is going to be used?)

regards,
ep


On 24 May 2001, at 7:56, Kevin Kostyszyn wrote:

>   This is more of a network admin question, but I figured I would toss it out
> there and see what everyone thought.  I currently have a Dell Precision 410
> PIII 600 being used as a sort of file server.  It basically houses a shared
> drive (IDE) and some other IDE drives used for DB backup.  I need another DB
> server and it dawned on me that I might be waisting this machine.  Do I
> really need a PIII 600mhz monster to house a shared drive that maybe 10
> users are accessing at once.  Couldn't I just throw these drives into a
> 233mhz Pentium and expect to get the same performace?  Not that it's even
> really doing much...I don't know, any advice would be appreciated.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: Listener.log....writing to renamed file

[Li, Xiangli]

Title: RE: Listener.logwriting to renamed file





May I know how to clear the content of listener.log without restart listener on NT platform ? 


thanks.
Li


-Original Message-
From:   Brian MacLean [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 1:42 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: Listener.logwriting to renamed file


Reload doesn't close/reopen the file.  Here is a couple solutions   


How's about a fast cat/clear solution: 


#!/bin/ksh
cat listener.log >>listener.log.hist
ex listener.log <
1,\$d
wq
EOF 


Or if you wish to purge 90% of the file: 


#!/bin/ksh
wc -l listener.log | read v_lines junk
v_keep=$(($((${v_lines} * 10)) / 100))
v_purge=$((${v_lines} - ${v_keep}))
ex listener.log <
1,${v_purge}d
wq
EOF 



-Original Message-
From: Thater, William [ ]
Sent: Thursday, May 24, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Listener.logwriting to renamed file 



On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon: 


->Hi List,
->As a regular maintainance work,I have moved the listener.log file to
->listener.log.old
->and 'touch'ed the listener.log, expecting the logging into this new file.
->But I am observing the logging being done to listener.log.old, instead.
->I could not recall any such previous experience.
->FYI, I cannot do any 'experiments' as far as this system is concerned as I
->have to deal with
->desupported HP-UX(10.01), Oracle (7.2.2.3).
->I have my logging being done to default path($ORACLE_HOME/network/log), as
->no parameter settings in listener.ora.
->Has anybody experienced this?
->
->TIA,
->
->Suren
->Oracle DBA
->Sony Electronics Ltd.
->
->
The file handle listener is using is still pointed at the old file.  To fix this you need to stop and start the listener.  This will not affect anybody who is already connected.  I'm not sure if a reload will do the same thing.

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.    [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates. 


--
Please see the official ORACLE-L FAQ: 
--
Author: Thater, William
  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:RE: Maximo

[dgoulet]

James,

In general I notice that MTS can slow things down IF there are not enough
shared servers running so that at least one server is constantly idle.

Dick Goulet

Reply Separator
Author: "James Xing" <[EMAIL PROTECTED]>
Date:   5/24/2001 9:36 AM

RE: MaximoThanks Chris,
Did you turn on MTS on your production server? Is that recommended?
In our environment, the system was fine on dev server which is not using
MTS, another DBA who is in charge of production server turned MTS on and
found the performance is 4 times slower.

James
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, Chris
  Sent: Wednesday, May 23, 2001 8:28 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Maximo


  ON all the maximo installations I have done, the biggest problems have
been with maxencrypt a table that holds the encrypted key that allows
everyone in the base.  There is a script that will reset this if the users
cannot get into the system.   Make sure that the character set in the client
is set to the same as the base.  If users cannot get into the base due to
bad password and you *know* the user/password are correct, then something
happened to the maxencrypt and/or the character sets are not the same.  I am
hoping that 4i eliminates that table, but since I haven't seen it, I don't
know if it does.

  I don't know about the current version, but when I worked with it about a
year ago, the indexes were terrible.  We dropped and created a number of
indexes to improve things.  We used cost base optimization (oracle v7 at the
time) and and a job that analyzed every couple weeks on the big tables and
every month on the others.

  If you have to do an import of the base, you will need to run the
maxora??.sql script that creates a couple views under sys.  I am sorry that
I cannot remember the script at this moment.   I'll check with some of my
old comrades and see if they can remember it.

  If you're moving to production, you probably have all the columns defined
and sized.  If not, sometimes the column changes do not get registered in
the maxsyscols table and you'll need to update it.

  Otherwise, the system really does quite well once it is running.  If I can
think of anything else I'll re-reply.

  --Chris
  [EMAIL PROTECTED]



  -Original Message-
  From: James Xing [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, May 22, 2001 6:15 PM
  To: Multiple recipients of list ORACLE-L
  Subject: Maximo



  Hi Group,

  I have a Maximo system moving into production, using Oracle 816/Sun
solaris
  If anyone has experience, from DBA point of view, what I should be care
of?
  anything to change/check? any particular table?

  Thanks
  James

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: James Xing
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: Maximo



Thanks

Chris, 
Did 
you turn on MTS on your production server? Is that 
recommended?
In our

environment, the system was fine on dev server which is not using 
MTS, another DBA who is in charge of production server turned MTS on 
and found the performance is 4 times slower.  
 
James

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: 
  Wednesday, May 23, 2001 8:28 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Maximo
  ON all the maximo installations I have done, the biggest 
  problems have been with maxencrypt a table that holds the encrypted key that 
  allows everyone in the base.  There is a script that will reset this if 
  the users cannot get into the system.   Make sure that the character

  set in the client is set to the same as the base.  If users cannot get 
  into the base due to bad password and you *know* the user/password are 
  correct, then something happened to the maxencrypt and/or the character sets 
  are not the same.  I am hoping that 4i eliminates that table, but since I

  haven't seen it, I don't know if it does.
  I don't know about the current version, but when I worked with

  it about a year ago, the indexes were terrible.  We dropped and created a

  number of indexes to improve things.  We used cost base optimization 
  (oracle v7 at the time) and and a job that analyzed every couple weeks on the 
  big tables and every month on the others.
  If you have to do an import of the base, you will need to run

Re: Odd core dump - possibly listener related

[Ruth Gramolini]

Lisa,
I would at least do a stack trace to find out what is causing the core
dumps. Then you will be able to see if they are really benign.  We have core
dumps that happened in 8.0.6  that OWS said would go away with 8.0.6.3.
This was the reason I needed to apply the patch.  The developers didn't like
them happening with their application...and I had other reasons to apply the
patch that they didn't care about..so

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 11:56 AM


> Hello all,
>
> My mini-me (aka Junior DBA) noticed a core dump this morning.  Good,
> attention to detail.  However, there's no unusual errors in the alert log
> for either databases on this host and there's no errors in the listener
log
> at all.  The core dump says something about pseudo cursor and references a
> port that isn't dedicated to the listener.
>
> Here's my take on it:  The database is fine.  The listener is fine.  The
app
> is fine.  With nothing in the logs I have no idea where to look.  I don't
> even know how this core dump ended up in $ORACLE_HOME/dbs (the default),
my
> core_dump_dest is set to a different directory.  Searching on metalink
> returns nothing.
>
> Mini-me (mini?  6'4") wants to chase this down.  I think it works, don't
fix
> it.  The occasional core dump is normal and there are a ton of other
things
> to attend to.  Does anyone disagree?
>
> So my question is, has anyone seen this before?  we are hp/ux 11.0,
8.1.6.2
>
> Thanks everyone, and au revoir.  I start a new job on Tuesday.
>
>
> Lisa Rutland Koivu
> Oracle Database Administrator "urn:schemas-microsoft-com:office:office" />
>
> Certified Self-Important Database Deity
>
> Slayer of Unix Administrators
>
> Wanton Kickboxing Goddess
>
>
> [EMAIL PROTECTED]
>   
>  NeoMedia 
> 4850 N.State Road 7, G104
>
> Ft. Lauderdale, FL  33319
> Phone: 954-484-3191 x 174
> Fax: 954-484-2933
> www.neom.com 
> www.paperclick.com 
> www.qode.com 
>
>
>   
>
>
>   P a p e r C l i c k . c o m
>
>
>
>
>
>
>
>
>  Enter Your PaperClick Code Here!
>
>
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  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: (Fwd) Wilber/Shambala interview ("transideological" social trends)

[Eric D. Pierce]

wait, where are my boots ?

Dilbert's "Mission Statement" generator:

http://www.dilbert.com/comics/dilbert/career/bin/ms2.cgi

 "The customer can count on us
  to completely maintain
  market-driven meta-services
  in order to competently
  engineer inexpensive data
  because that is what the
  customer expects "

regards,
ep


On 23 May 2001, at 19:10, Rachel Carmichael wrote:



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  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: MS access

[Norrell, Brian]

Officially there is no max, but realistically, as you 
get close to a gig you start having serious issues.  MAJOR performance 
problems, increased crashes, a nightmare.  Time to consider something more 
robust, and honestly  SQLServer is probably the way to go 
<_BLASPHEMY>.  The syntax matches up better so there are fewer 
(almost no) issues porting code that runs against Access to SQLServer, where 
there can be some issues moving to Oracle.
 
Brian 
Norrell Manager, MPI Development 
QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 

-Original Message-From: Luis DeUrioste 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 1:32 
PMTo: Multiple recipients of list ORACLE-LSubject: Re: MS 
accessMigrate to ORACLE ! 
< sorry could not resist t> 
"Li, Xiangli" wrote: 
  
  Hi, List Is there anyone happen to know what's the database 
  size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it 
  if that's true? 
  thanks Li

Re:memory question again ???

[dgoulet]

Janet,

I'll try to show you with one of our larger Hp's:

VMSTAT takes a number of parameters, my favorite are:

Report memory status every 5 minutes for 5 reports.  The AVM column gives
available real memory.  The FREE column indicates the amount of real and virtual
memory that us available.

nbrahms:/ora1:02:vmstat 5 5  
 procs   memory   page  
faults   cpu
r b w  avmfree   re   atpi   pofr   desr in 
sycs  us sy id
1   170 021179  43407151 00 00 0  0 
  1197   966  20  4 75
1   172 022951  43404171 00 00 0   1423 
  2848   607  15  2 83
0   173 024727  43404110 00 00 0    
  2168   408  16  1 84
1   172 022622  43404100 00 00 0   1051 
  2091   306   5  1 94
0   173 023773  43404100 00 00 0951 
  1486   226  11  1 88

VMSTAT -s (lower case) provides a dump of the internal registers that recods
memory usage.  In this case the MOST important parameter is "revolutions of the
clock hand".  For each revolution of the 'clock hand' you've gone through your
entire swap file.  Having a value > 0 is not necessarily bad depending on how
long the server has been running.  In this case the server has been running for
25 days.

nbrahms:/ora1:02:vmstat -s
0 swap ins
0 swap outs
0 pages swapped in
0 pages swapped out
48058981 total address trans. faults taken
13914835 page ins
0 page outs
20587 pages paged in
0 pages paged out
10013365 reclaims from free list
13911293 total page reclaims
44 intransit blocking page faults
36560237 zero fill pages created
23993691 zero fill page faults
6415045 executable fill pages created
20587 executable fill page faults
0 swap text pages found in free list
3607270 inode text pages found in free list
0 revolutions of the clock hand  <-
4750 pages scanned for page out
0 pages freed by the clock daemon
2146931554 cpu context switches
366656955 device interrupts
416856006 traps
2659952744 system calls

Reply Separator
Author: Janet Linsy <[EMAIL PROTECTED]>
Date:   5/24/2001 9:26 AM

Hi, 

Thank you all for showing me how to check the Unix
memory.  Is there a way to show how much is used and
how much is free?

Thank you!

Janet

__
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: Janet Linsy
  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).

#test#

[Jake]

Oracle Applications Suite CDs.

[Boivin, Patrice J]

I would like to know how to obtain a trial or developer version of the
Oracle Applications Suite...

: )

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: forms 4.5 error against oracle 8i db...

[Marc Perkowitz]

Yes, this is exactly the error that occurs when you run a version of 4.5
that has not been patched to work with 8i.  This is because of the rowid
format change in 8i -- the rowid is used for locking in forms.

You need to upgrade your version of 4.5 or convert to 6i.  I believe there
is also a way to run an 8i database in Oracle 7 compatibility mode where the
rowids are formatted the old way, but I'm not familiar with that.  Patching
4.5 or upgrading to 6i is the better approach.

Marc Perkowitz
Senior Consultant
TWJ Consulting, LLP

847-256-8866 x15
www.twjconsulting.com

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 6:50 AM


> Hi,
> has anyone encounted errors for the post built-in when the form is run
> against 8i db?
> I have a situation here, wherein, if I run forms 4.5 generated .fmx
against
> oracle 7.3 db, it works fine. But when I run the same form against 8i db,
> the post built-in is generating the error "frm 40501: oracle error: unable
> to reserve record for update or delete".
>
> Note, the first time the post is executed in the session, no error is
> generated, but from the second time onwards, the above error is
encountered.
>
> Thanks
> Amar Kumar Padhi.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Amar Kumar Padhi
>   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: Marc Perkowitz
  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: MS access

[Li, Xiangli]

Title: RE: MS access





Hi , DBAs
Thank you veyr much  for all replies. I think I have to go for oracle.


rgds,
Li


-Original Message-
From:   Haskins, Ed [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, May 24, 2001 2:26 PM
To: Multiple recipients of list ORACLE-L
Subject:    RE: MS access


Li,
 
1GB for Access would be huge...and cause very poor performance.  The only way to overcome the size limitation is to upgrade to a real database...preferably Oracle, but that SQL Server thing would work as well for a DB that size.

 
Ed Haskins
Oracle DBA
Verizon Wireless
 


-Original Message-
From: Li, Xiangli [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L
Subject: MS access




Hi, List
Is there anyone happen to know what's the database size limitation for MS access97? I heard it's 1 gigabytes, how to overcome it if that's true?

thanks
Li 

OT RE: BUNYAMIN POSTS HAVE A VIRUS

[Mohan, Ross]

I love the fact that you corrected the
spelling in your sig. 

There is hope! 

:)

|| -Original Message-
|| From: [EMAIL PROTECTED]
|| [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 24, 2001 12:56 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: BUNYAMIN POSTS HAVE A VIRUS
|| 
|| 
|| Selectively, to individual email addresses.  Or is everyone 
|| getting hit?
|| 
|| Scott Shafer
|| San Antonio, TX
|| 210-581-6217
|| 
|| "And no amount of training or preparedness can eliminate the almost
|| certainty that in the middle of your Angry Crane stance, as 
|| you transition
|| to your Combative Monkey to administer the Coup de Grâce via 
|| your Ninja
|| Death Touch, you step on a beer bottle and fall backwards 
|| into the juke box
|| and get your head stove in by a drunk with a pool cue."  --Jay Trigg
|| 
|| > -Original Message-
|| > From:  Mohan, Ross [SMTP:[EMAIL PROTECTED]]
|| > Sent:  Thursday, May 24, 2001 10:17 AM
|| > To:Multiple recipients of list ORACLE-L
|| > Subject:   BUNYAMIN POSTS HAVE A VIRUS
|| > 
|| > "This individual", BUNYAMIN, appears
|| > to be squirting virus code...yes...
|| > 
|| > || -Original Message-
|| > || From: [EMAIL PROTECTED]
|| > || [mailto:[EMAIL PROTECTED]]
|| > || Sent: Thursday, May 24, 2001 10:27 AM
|| > || To: Multiple recipients of list ORACLE-L
|| > || Subject: FW: RE: MICROSOFTDTPROPERTIES 
|| > || 
|| > || 
|| > || If anyone receives mail from this individual, please scan 
|| > || any attatchments
|| > || as it contains the W32/BadTrans@MM vi*us...
|| > || 
|| > || Scott Shafer
|| > || San Antonio, TX
|| > || 210-581-6217
|| > || 
|| > || "And no amount of training or preparedness can 
|| eliminate the almost
|| > || certainty that in the middle of your Angry Crane stance, as 
|| > || you transition
|| > || to your Combative Monkey to administer the Coup de Grâce via 
|| > || your Ninja
|| > || Death Touch, you step on a beer bottle and fall backwards 
|| > || into the juke box
|| > || and get your head stove in by a drunk with a pool cue." 
||  --Jay Trigg
|| > || 
|| > || > -Original Message-
|| > || > From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]]
|| > || > Sent: None
|| > || > To:   [EMAIL PROTECTED]
|| > || > Subject:  Re: RE: MICROSOFTDTPROPERTIES  
|| > || > 
|| > || > '[EMAIL PROTECTED]' wrote:
|| > || > 
|| > || > - The developer created the table and now doesn't know 
|| > || what is does???  
|| > || > - As penance, said developer(s) must write "I will 
|| > || document all changes
|| > || > fully"
|| > || > - and "RTFM" in their own blood, 10,000 times on the floor 
|| > || without using
|| > || > their
|| > || > - hands.
|| > || > - 
|| > || > - Then:
|| > || > - 1)  export tables=MICROSOFTDTPROPERTIES ...
|| > || > - 2)  DROP TABLE MICROSOFTDTPROPERTIES;
|| > || > - 3)  see who/what/if anything breaks, whines, or snivels...
|| > || > - 
|| > || > - All assuming this is a developm ...'
|| > || > 
|| > || > 
|| > || > > Take a look to the attachment. 
|| > || > 
|| > || >  <> 
|| > || 
|| > 
|| -- 
|| 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: Mohan, Ross
  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: FTP process exceeds ulimit as oracle user

[John Kanagaraj]

Hi Gene,

>However, when FTP'ing using the oracle user id, it aborts at 
>1gb.  I guessed the ftp daemon used some other user id for 
>this.  Wrong ( well maybe).  I changed the default limits to 
>unlimited for all users (i.e. default) and deleted the oracle 
>user id from /etc/security/limits file.  Same problem, ftp 
>process dies at 1gb.  Now, I am trying to get the file rather 
>than putting it.  Lets see if this works?  

Your workaround is correct. The reason why this errored out before is this :
Root on the remote server receives a signal via inetd and starts up an
'ftpd' daemon under it's own account to serve you when you 'put' a file.
This is configured in the /etc/inetd.conf file (diff path in AIX) by the
following line:

ftp tli tcp nowait  root/usr/etc/ftpd   ftpd

$ ps -ef | grep ftpd
 root 28825   923   0  07:07:08 ?   0:00 ftpd <--- this does the
job on the remote server
   oracle 28917   686   0  07:07:44 ttyAF/AFFL  0:00 grep ftpd 

When 'root' started out, the inetd process which triggers the start of the
ftpd inherits the previous limit of 1gb and hence you had this problem. To
solve this permanently, you will need to run the command 'refresh -s inetd'
as 'root' on AIX which restarts the inetd daemon.

Hth, (Hope this helps!)

John Kanagaraj
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: My Website

[Christopher Spence]

Yes it is very much so.  I am redoing a new interface, unfortuntely although
I am stupid, I have no creativity.  I think too logically.
I have a few friends of mine that will help, I have left the color scheme
for now until I get some better idea.

Been playing with Photoshop and ImageReady trying to come up with something,
haven't impressed anyone yet.  Although I haven't had much chance to work on
it.
Also note the simple logo for just this reason.


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 24, 2001 10:46 AM
To: Multiple recipients of list ORACLE-L


Chris,

It's just my opinion, but that regular blue font on blue background is a
little hard to focus.

Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline

> -Original Message-
> From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, May 19, 2001 4:00 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  My Website
> 
> Some of you already know me from Lazyda list, some of your don't (prob
> glad).  Well I have been working on putting up yet! another dba portal
> site.
> I have articles, scripts, and forums.  I been really busy lately fire
> fighting a huge new product of ours, so I haven't got as much content as I
> wanted to have by now, but i do have about 45 articles and 30 or so
> scripts.
> Most of the famous and popular (or ones I liked) articles are already up
> their as I always had them an arms reach away.  Feel free to contact me
> (please use email on site) for any additions one may feel appropriate.
> And
> unlike OTHER lists, none of the information on the site I claim as my own
> unless it is of course, my own.  Everyone who participates gets due credit
> and there are no royalties with the site either (go figure heh?).  
> 
> Now that everyone is asleep from me running on, here is the URL:
> 
> www.vampired.net Aka Vampire D's Oracle Den.
> 
> Christopher,
> -- 
> 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: Armstead, Michael A
  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: Re: Listener.log....writing to renamed file

[gregory . t . norris]

A coworker of mine discovered this a few weeks ago on a Sun box.  No 
difference there!

> -Original Message-
> From: Gsais [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 24, 2001 11:36 AM
> To: ORACLE-L
> Cc: Gsais
> Subject: Re: Listener.logwriting to renamed file
> 
> 
> I think it is only safe to restart the listener when using 
> dedicated not mts.  I know on OpenVMS, you have to restart 
> the db when restarting the listener using mts.  Never tested 
> on unix.  I prefer dedicated, never use mts, too many 
> problems.  Just buy more RAM :).

oracle-l@fatcity.com

[Jake MacGruder]

hey now

__
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: Jake MacGruder
  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: MS access

[Christopher Spence]

Title: MS access



I 
believe it is 2gb.
 
 
"Walking on water and developing software from a 
specification are easy if both are frozen." 
Christopher R. Spence Oracle DBA Fuelspot 

  -Original Message-From: Li, Xiangli 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57 
  AMTo: Multiple recipients of list ORACLE-LSubject: MS 
  access
  Hi, List Is 
  there anyone happen to know what's the database size limitation for MS 
  access97? I heard it's 1 gigabytes, how to overcome it if that's 
  true?
  thanks Li 
  

Re: SQLLDR Question

[Diana_Duncan]

In 8.1.6, you don't have to have the one column in the database.  Use
'FILLER' as the data type.

Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC  27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]


   
  
[EMAIL PROTECTED]
  
ardier.com To: Multiple recipients of 
list ORACLE-L <[EMAIL PROTECTED]>   
Sent by: [EMAIL PROTECTED]  cc: 
  
   Fax to: 
  
   Subject: Re: SQLLDR 
Question  
05/24/2001 11:31 AM
  
Please respond to ORACLE-L 
  
   
  
   
  






You can combine two data fields into one column with sqlldr, but  I think
both
fields have to be in the table.

Example:
SQL> desc x
 Name  Type
 - 
 TRANS_DATEDATE
 F1CHAR(8)


LOAD DATA
INFILE *
APPEND
INTO TABLE x
FIELDS TERMINATED BY ','
(f1,
 trans_date "to_date(:f1||' '||:trans_date,'mm/dd/yy hh24:mi')"
)
BEGINDATA
05/01/01,14:21
05/24/01,9:57

(After the load, you can ALTER TABLE table DROP COLUMN column to get rid of
the
f1 column,)






Jared Still <[EMAIL PROTECTED]> on 05/23/2001 11:16:00 PM

Please respond to [EMAIL PROTECTED]

To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Chaim Katz/Completions/Bombardier)





Instead of trying to do this in SQL Loader, why not just
try to clean up the data?

This can be done at least 2 methods:

1.  Get the sender to send it to you properly

2.  clean it up yourself.

The following Perl script will do it

Jared


#!/usr/bin/perl

my $file="data.txt";
open(DATA,$file) || die "cannot open $file - $!\n";

while(){
chomp;
my @data = split(/,/);
# append last field to penultimate field, remove last field
$data[ $#data -1] .= "-" . $data[ $#data ];
undef $data[ $#data ];

#print it all out
my $newData =  join(',',@data);
# remove trailing comma
chop $newData;
print "$newData\n";
}



On Wednesday 23 May 2001 14:41, Scott Canaan wrote:
> I am trying to load a file that has the fields comma-delimited,
> variable length.  A sample line from the file looks like this:
>
> 503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21
>
> The problem I am having is putting the date and time together.  The
> control file looks like this:
>
> load data
> infile 'cyber_real.dat'
> append
> into table rit_cyber_hist
> when order_id <> 'Order ID' and order_id <> ''
> fields terminated by ','
> (order_id,
>  trans_nbr,
>  cyber_status,
>  trans_type,
>  auth_code,
>  avs_code,
>  trans_amt,
>  cic_resp,
>  po_nbr,
>  ship_to_zip,
>  tax_amt,
>  trans_date date(14) "mm/dd/yy,hh:mi")
>
> It ignores the time portion of the file, I presume because it has a
> comma before it and it assumes that it is a different field.  I can't
> figure out any way to get this loaded with the trans_date field
> containing both the date and time.
>
> This is on Oracle 8.1.6.0 on Sun Solaris.
>
> Any suggestions?  Thank you.
>
> --
> 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: Jared Still
  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
--

RE: memory question again ???

[Brian MacLean]

Title: RE: memory question again ???





Here is a little C program that works on Solaris:


$ sysconf
Memory->total=5120M free=1596M pct=31 pagesize=8K CPU->total=6 online=6


$ cat sysconf.c
#include 
#include 


main()
{
  int wk1, wk2, wk3, wk4;
  long total_pages, free_pages, pagesize, total_cpus, total_cpus_online;


  total_pages   = sysconf(_SC_PHYS_PAGES);
  free_pages    = sysconf(_SC_AVPHYS_PAGES);
  pagesize  = sysconf(_SC_PAGESIZE);
  total_cpus    = sysconf(_SC_NPROCESSORS_CONF);
  total_cpus_online = sysconf(_SC_NPROCESSORS_ONLN);


  wk1 = (total_pages * (pagesize / 1024)) / 1024;
  wk2 = (free_pages * (pagesize / 1024)) / 1024;
  wk3 = (free_pages * 100) / total_pages;
  wk4 = (pagesize / 1024);


  printf("Memory->total=%dM free=%dM pct=%d pagesize=%dK CPU->total=%d online=%d\n",
 wk1, wk2, wk3, wk4, total_cpus, total_cpus_online );


}


-Original Message-
From: Janet Linsy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L
Subject: memory question again ???



Hi, 


Thank you all for showing me how to check the Unix
memory.  Is there a way to show how much is used and
how much is free?


Thank you!


Janet


__
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: Janet Linsy
  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:RE: MS access

[dgoulet]

Kevin!!!

Li,
In reality Access does have a file size limit, but I believe it is much
lower than 1GB.  Regrettably there is no way around it, except as Kevin stated
to use a pass through query to Oracle.  One should understand that Access is
designed as a single user system that gets bastardized into multi user
applications with a lot of resulting trouble.

Dick Goulet

Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Date:   5/24/2001 9:02 AM

MS accessIf it's true use an Oracle Database...hehehhhehhh...Just
kidding...sorry:(
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Li, Xiangli
  Sent: Thursday, May 24, 2001 11:57 AM
  To: Multiple recipients of list ORACLE-L
  Subject: MS access


  Hi, List
  Is there anyone happen to know what's the database size limitation for MS
access97? I heard it's 1 gigabytes, how to overcome it if that's true?

  thanks
  Li



MS access



If 
it's true use an Oracle Database...hehehhhehhh...Just 
kidding...sorry:(

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Li, XiangliSent: 
  Thursday, May 24, 2001 11:57 AMTo: Multiple recipients of list 
  ORACLE-LSubject: MS access
  Hi, List Is 
  there anyone happen to know what's the database size limitation for MS 
  access97? I heard it's 1 gigabytes, how to overcome it if that's 
  true?
  thanks Li

  

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

Snapshot drop

[Kishore]

Hello  Gurus

Please help me in dropping and recreating the
snapshots. what happened was.

I had connection down between we adn the destination,
when the connection came alive , I tried to do
following to refresh the snapshots.

 1- exec dbms_job.run(153)

This did not do any good so I tried.

 2- exec dbms_snapshot.refresh('snapshotname','?')

This worked on 8 out of 10. The two did not get
refreshed and they are not getting refreshed since two
days now.  I tried to drop them and recreste them.
They do not get drop.

Please help me as how to solve this problem.

Thank you very much



__
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: Kishore
  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: MS access

[Luis DeUrioste]

Migrate to ORACLE !
< sorry could not resist t>
"Li, Xiangli" wrote:
 
Hi, List
Is there anyone happen to know what's
the database size limitation for MS access97? I heard it's 1 gigabytes,
how to overcome it if that's true?
thanks
Li


begin:vcard 
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
email;internet:[EMAIL PROTECTED]
title:Systems Analyst
adr;quoted-printable:;;250 San Carlos Road=0D=0ABuilding 1853 - UNFO;Pensacola;Florida;32534;U.S.A.
fn:Luis Octavio de Urioste
end:vcard

Re: MS access

[Gene Gurevich]

Li,

I haven't worked with MS Access, but I did work on a
few projects converting MS Access application to
Oracle application exactly because MS Access can't
handle large amounts of data. The anser to you
question may very well be - move to Oracle (or any
other more powerful tool)

HTH

G
--- "Li, Xiangli" <[EMAIL PROTECTED]> wrote:
> Hi, List
> Is there anyone happen to know what's the database
> size limitation for MS
> access97? I heard it's 1 gigabytes, how to overcome
> it if that's true?
> 
> thanks
> Li
> 


=
!!! Please note my "new" old address !!!

__
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: Gene Gurevich
  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 Development Tool - EasySQL?

[Christopher Spence]

Never used EasySQL unfortunately.

"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 24, 2001 11:23 AM
To: Multiple recipients of list ORACLE-L


how might you compare PL/SQL Developer and EasySQL?

|| -Original Message-
|| From: Christopher Spence [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 24, 2001 10:57 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Oracle Development Tool
|| 
|| 
|| I think PL/SQL Developer blows away Toad especially since it is only
|| $150-$50 depending on how many you buy compared to $750 buying toad.
|| AllAround Automations sells it.  Anyone I have shown it to 
|| (SQL Nav users,
|| Toad) and they have "seen the light".
|| 
|| 
|| "Walking on water and developing software from a 
|| specification are easy if
|| both are frozen."
|| 
|| Christopher R. Spence
|| Oracle DBA
|| Fuelspot 
|| 
|| 
|| 
|| -Original Message-
|| Sent: Thursday, May 24, 2001 9:26 AM
|| To: Multiple recipients of list ORACLE-L
|| 
|| 
|| Hi Deepak,
|| 
|| I'd go with TOAD, why? well I have been using it since it 
|| was a freeware (we
|| bought it finally) and am very comfortable with what it does 
|| and how easy it
|| makes things.
|| 
|| Hats off to TOADMAN !
|| 
|| HTH
|| 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 !
|| 
|| *
|| 4
|| 
|| 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.
|| 
|| *
|| 4
|| 
|| -- 
|| 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).
|| -- 
|| 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: Mohan, Ross
  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 subscrib

SQL PROBLEM

[Harvinder Singh]

Title: MS access



Hi,
 
Favour 
me in suggest a hint in writing a sql for following 
scenaio:
 
Table 
A has 2 columns ord_id and line_id
 
example rows are:
 
ord_id 
line_id
17    
null
null  42
 
Table  B has columns ord_id and 
line_id
 
ord_id 
line_id
17    
42
17    
43
1744
 
I have 
to write a sql to count(*) from table A where ord_id=17 ..
as u 
see from table B line 42 is row of ord_id=17 ..so i want
count(*) should show =2 from tabel A 

but if 
i do count(*) from table A where ord_id=17..it shows 1..
i need 
to put another condition which will check line id with 
TABLE 
B and if it is  for this particular order ...add that also 
in
count(*).
I know 
scenario is little fuzzy sorry for it..but if u got my point 

kindly 
respond.
 
Thanks
Harvinder

RE: Listener.log....writing to renamed file

[Brian MacLean]

Title: RE: Listener.logwriting to renamed file





Reload doesn't close/reopen the file.  Here is a couple solutions   


How's about a fast cat/clear solution:


#!/bin/ksh
cat listener.log >>listener.log.hist
ex listener.log <
1,\$d
wq
EOF


Or if you wish to purge 90% of the file:


#!/bin/ksh
wc -l listener.log | read v_lines junk
v_keep=$(($((${v_lines} * 10)) / 100))
v_purge=$((${v_lines} - ${v_keep}))
ex listener.log <
1,${v_purge}d
wq
EOF



-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Listener.logwriting to renamed file



On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon:


->Hi List,
->As a regular maintainance work,I have moved the listener.log file to
->listener.log.old
->and 'touch'ed the listener.log, expecting the logging into this new file.
->But I am observing the logging being done to listener.log.old, instead.
->I could not recall any such previous experience.
->FYI, I cannot do any 'experiments' as far as this system is concerned as I
->have to deal with
->desupported HP-UX(10.01), Oracle (7.2.2.3).
->I have my logging being done to default path($ORACLE_HOME/network/log), as
->no parameter settings in listener.ora.
->Has anybody experienced this?
->
->TIA,
->
->Suren
->Oracle DBA
->Sony Electronics Ltd.
->
->
The file handle listener is using is still pointed at the old file.  To fix this you need to stop and start the listener.  This will not affect anybody who is already connected.  I'm not sure if a reload will do the same thing.

--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.    [EMAIL PROTECTED]
~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~
No program done by an undergrad will work after she graduates.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thater, William
  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: MS access

[Haskins, Ed]

Title: MS access



Li,
 
1GB 
for Access would be huge...and cause very poor performance.  The only way 
to overcome the size limitation is to upgrade to a real database...preferably 
Oracle, but that SQL Server thing would work as well for a DB that 
size.
 
Ed 
Haskins
Oracle 
DBA
Verizon Wireless
 

  -Original Message-From: Li, Xiangli 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 11:57 
  AMTo: Multiple recipients of list ORACLE-LSubject: MS 
  access
  Hi, List Is 
  there anyone happen to know what's the database size limitation for MS 
  access97? I heard it's 1 gigabytes, how to overcome it if that's 
  true?
  thanks Li 
  

I wonder ???

[Robertson Lee - lerobe]

How many people 
opened the apology from Bunyamin ??
 
:-)
 
Lee

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.

RE: Maximo

[James Xing]

Title: RE: Maximo



Thanks 
Chris, 
Did 
you turn on MTS on your production server? Is that 
recommended?
In our 
environment, the system was fine on dev server which is not using 
MTS, another DBA who is in charge of production server turned MTS on 
and found the performance is 4 times slower.  
 
James

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: 
  Wednesday, May 23, 2001 8:28 AMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Maximo
  ON all the maximo installations I have done, the biggest 
  problems have been with maxencrypt a table that holds the encrypted key that 
  allows everyone in the base.  There is a script that will reset this if 
  the users cannot get into the system.   Make sure that the character 
  set in the client is set to the same as the base.  If users cannot get 
  into the base due to bad password and you *know* the user/password are 
  correct, then something happened to the maxencrypt and/or the character sets 
  are not the same.  I am hoping that 4i eliminates that table, but since I 
  haven't seen it, I don't know if it does.
  I don't know about the current version, but when I worked with 
  it about a year ago, the indexes were terrible.  We dropped and created a 
  number of indexes to improve things.  We used cost base optimization 
  (oracle v7 at the time) and and a job that analyzed every couple weeks on the 
  big tables and every month on the others.
  If you have to do an import of the base, you will need to run 
  the maxora??.sql script that creates a couple views under sys.  I am 
  sorry that I cannot remember the script at this moment.   I'll check 
  with some of my old comrades and see if they can remember it.  

  If you're moving to production, you probably have all the 
  columns defined and sized.  If not, sometimes the column changes do not 
  get registered in the maxsyscols table and you'll need to update 
it.
  Otherwise, the system really does quite well once it is 
  running.  If I can think of anything else I'll re-reply. 
  --Chris [EMAIL PROTECTED] 
  
  -Original Message- From: James 
  Xing [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, May 22, 2001 6:15 PM To: Multiple recipients of list ORACLE-L Subject: Maximo 
  Hi Group, 
  I have a Maximo system moving into production, using Oracle 
  816/Sun solaris If anyone has experience, from DBA 
  point of view, what I should be care of? anything to 
  change/check? any particular table? 
  Thanks James 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- Author: James Xing   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: memory question again ???

[Magrogan Michael A]

sar -r reports available memory, averaged for today.  
You can add start/end times also.  
Or you can run it right now: sar -r 2 10, 
  tells sar to return memory information every 2 seconds, 
  and do that 10 times.
Sar also provides cpu utilization and disk activity data.  Take a look at
the sar man pages for additional info provided by sar.

Mike
-Original Message-
Sent: Thursday, May 24, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L


Hi, 

Thank you all for showing me how to check the Unix
memory.  Is there a way to show how much is used and
how much is free?

Thank you!

Janet

__
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: Janet Linsy
  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: Magrogan Michael A
  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: Listener.log....writing to renamed file

[Jeremiah Wilton]

MTS is quite stable from 8.0.5 up.  One persistent limitation is the fact that
SQL*Trace output for a session is scattered across the various shared server
processes.  Oracle's developers say that they eventually will provide a solution
for this limitation, but it is not forthcoming in 9.x.

As of 8.0.x, PMON will periodically attempt to re-register dispatchers with
listeners, so you don't have to restart the instance after restarting a
listener.  In 9.x, there is a "re-register right now" command (alter system ?)
so that you don't have to wait around for PMON to get around to it.

As for the listener log, you can just truncate it (after copying the contents if
you like) by catting the null device into the log file:

cat /dev/null > listener.log

This will result in a 0-byte file.  There is definitely no need to restart the
listener.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 24 May 2001, Gene Sais wrote:

> I think it is only safe to restart the listener when using dedicated not mts.  I 
>know on OpenVMS, you have to restart the db when restarting the listener using mts.  
>Never tested on unix.  I prefer dedicated, never use mts, too many problems.  Just 
>buy more RAM :).
>
> >>> [EMAIL PROTECTED] 05/24/01 10:15AM >>>
> On Thu, 24 May 2001,Tirumala, Surendra scribbled on the wall in glitter crayon:
>
> ->As a regular maintainance work,I have moved the listener.log file to
> ->listener.log.old
> ->and 'touch'ed the listener.log, expecting the logging into this new file.
> ->But I am observing the logging being done to listener.log.old, instead.
> ->I could not recall any such previous experience.
> ->FYI, I cannot do any 'experiments' as far as this system is concerned as I
> ->have to deal with
> ->desupported HP-UX(10.01), Oracle (7.2.2.3).
> ->I have my logging being done to default path($ORACLE_HOME/network/log), as
> ->no parameter settings in listener.ora.
> ->Has anybody experienced this?
> ->
> The file handle listener is using is still pointed at the old file.  To fix this you 
>need to stop and start the listener.  This will not affect anybody who is already 
>connected.  I'm not sure if a reload will do the same thing.

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

Re:Sort of OT but sort of not....

[dgoulet]

Kevin,

Should work just fine.  I've been using an old HP with a P11/100 for the
same purpose these last two years.

Dick Goulet

Reply Separator
Author: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
Date:   5/24/2001 7:56 AM

Hi All,
This is more of a network admin question, but I figured I would toss it
out
there and see what everyone thought.  I currently have a Dell Precision 410
PIII 600 being used as a sort of file server.  It basically houses a shared
drive (IDE) and some other IDE drives used for DB backup.  I need another DB
server and it dawned on me that I might be waisting this machine.  Do I
really need a PIII 600mhz monster to house a shared drive that maybe 10
users are accessing at once.  Couldn't I just throw these drives into a
233mhz Pentium and expect to get the same performace?  Not that it's even
really doing much...I don't know, any advice would be appreciated.

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: 
  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 Development Tool

[Christopher Spence]

http://www.allroundautomations.nl


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot 



-Original Message-
Sent: Thursday, May 24, 2001 12:16 PM
To: Multiple recipients of list ORACLE-L


What is this mythical PL/SQL Developer and who makes it.  We currently use
TOAD and sqlnav and LOVE'em, i would be interested in a comparison
Kev

-Original Message-
Spence
Sent: Thursday, May 24, 2001 10:57 AM
To: Multiple recipients of list ORACLE-L


I think PL/SQL Developer blows away Toad especially since it is only
$150-$50 depending on how many you buy compared to $750 buying toad.
AllAround Automations sells it.  Anyone I have shown it to (SQL Nav users,
Toad) and they have "seen the light".


"Walking on water and developing software from a specification are easy if
both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot



-Original Message-
Sent: Thursday, May 24, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L


Hi Deepak,

I'd go with TOAD, why? well I have been using it since it was a freeware (we
bought it finally) and am very comfortable with what it does and how easy it
makes things.

Hats off to TOADMAN !

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

*4

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.

*4

--
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).
--
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: 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: 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).