date:20020730


tell the user that he must ALSO scan his PC for viruses while you check
the database. Then wait for him to find it on his PC... and do nothing
because the problem is on his side, not the database.

you can also look up wormy-1 on the symantec site and send the user the
information about the virus and the worm.


--- Jackson Dumas [EMAIL PROTECTED] wrote:
 Hi everyone
 
 I might sound like I am a bit crazy or something, but here is my
 problem. There is a customer who is having a problem when he tries to
 open his report from application, which is running on ORACLE
 DATABASE.
 The message he gets is about a Wormy-1 virus, he wants me to check or
 scan the database. Well maybe I am missing something here, that
 virus,
 Wormy-1 is a word document virus, thus Microsft related and if there
 was anything on the database then it should have affected the
 datafiles on the O/S. I tried to explain this to this user, but hey
 he
 is very difficult. I tried to pass the request to Application guys to
 check, but they can't help either. Now, is it possible that the said
 virus is on a database, if so then where and how do I fix it. There
 is
 nothing with the database, it's up and running and no errors on the
 alert log. Where do I go from here, please help me this user is kinda
 not patient and doesn't want to understand ?
 
 ___
  http://www.webmail.co.za the South-African free email service
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Jackson Dumas
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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!?
Yahoo! Health - Feel better, live better
http://health.yahoo.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).

Re: how to change nls date format.

2002-07-30 Thread Yechiel Adar


Did you check the registry on the machine that you execute sqlplus on to see
if there is nls_date_format there?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:38 AM


 Hi,
 The default date format for an instance is  dd-mon-.
 Ex when issue the following statement Select to_char(sysdate) from dual;
 The output is 01-Jan-2002.

 I want to change this format to mm/dd/.
 According to Oracle documentation this can be changed @ sesion level by
the
 following :
 Alter session set nls_date_format='mm/dd/';  ( alter system does not
 work).

 To change it @ the instance level, the following needs to be added in the
 init.ora file :
 Nls_date_format=mm/dd/.

 After starting the instance, when we check v$parameter, this change  is
 reflected. But the same is not reflected while selecting data. Again when
 the sysdate select is issued the result does not change.

 The date format was not specified while installing Oracle or creating the
 instance, it was a default installation. Is there anyway to change this?

 Other Info on Database :
 Version Oracle 8.1.6
 OS - Windows NT
 NLS_TERRITORY - AMERICA
 NLS_LANGUAGE - AMERICAN
 Charset WE8ISO8851


 Thanks in advance
 Sunil Gompa





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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: CRAZY_WORMY_THANG_ON_ORACLE_DB ?

2002-07-30 Thread Radu Caulea


Hi,

On the DB side, i see only the possibility of having infected docs in
blob columns. I have once loaded such a document, and client (me,
fortunately) was alerted each time while retrieving that document via a
browser. As a matter of fact, I had no antivirus on the server, i
suppose it would have shouted danger while loading. I really have this
problem also when client uploads a binary file to be inserted in the DB
(but let us not digress). 

Radu Caulea, TAFORA
Senior Oracle Consultant
www.caulea.com
 

-Original Message-
Carmichael
Sent: mardi 30 juillet 2002 13:18
To: Multiple recipients of list ORACLE-L


tell the user that he must ALSO scan his PC for viruses while you check
the database. Then wait for him to find it on his PC... and do nothing
because the problem is on his side, not the database.

you can also look up wormy-1 on the symantec site and send the user the
information about the virus and the worm.


--- Jackson Dumas [EMAIL PROTECTED] wrote:
 Hi everyone
 
 I might sound like I am a bit crazy or something, but here is my 
 problem. There is a customer who is having a problem when he tries to 
 open his report from application, which is running on ORACLE DATABASE.
 The message he gets is about a Wormy-1 virus, he wants me to check or
 scan the database. Well maybe I am missing something here, that
 virus,
 Wormy-1 is a word document virus, thus Microsft related and if there
 was anything on the database then it should have affected the
 datafiles on the O/S. I tried to explain this to this user, but hey
 he
 is very difficult. I tried to pass the request to Application guys to
...



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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ... And another RMAN Q.

2002-07-30 Thread Mercadante, Thomas F


Ross,

when you say RMAN backups are initiated from BoxA to backup db in BoxB
what do you mean?  are they run on BoxA or BoxB?  If they are run on BoxA,
then the backup files will be created on BoxA.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, July 30, 2002 1:58 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Env.: 2 Solaris boxes both Oracle 8.1.7.3

BoxA has the RMAN catalog. BoxB is where the Prod db is.  RMAN backups are
initiated from BoxA to backup db in BoxB.  RMAN backupsets are created in
BoxB.  Is there a way to get RMAN to create the backupsets in BoxA instead?

Below is an excerpt of my rman backup script:
---
---
---
replace script backup_db_full {
  execute script archive_log_current;
  execute script alloc_all_disks;
  execute script set_maxcorrupt;
  backup
full
skip inaccessible
tag b_db_full
filesperset 3
format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
database;
  execute script rel_all_disks;
  execute script archive_log_current;
  execute script backup_al_all;
}
---
---

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

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

RE: how to change nls date format.

2002-07-30 Thread Sunil Kumar

I checked my Registry..
Nls_date_format is not  set in the registry..

-Original Message-
From:   Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, July 30, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: how to change nls date format.

Did you check the registry on the machine that you execute sqlplus on to see
if there is nls_date_format there?

Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:38 AM

 Hi,
 The default date format for an instance is  dd-mon-.
 Ex when issue the following statement Select to_char(sysdate) from dual;
 The output is 01-Jan-2002.

 I want to change this format to mm/dd/.
 According to Oracle documentation this can be changed @ sesion level by
the
 following :
 Alter session set nls_date_format='mm/dd/';  ( alter system does not
 work).

 To change it @ the instance level, the following needs to be added in the
 init.ora file :
 Nls_date_format=mm/dd/.

 After starting the instance, when we check v$parameter, this change  is
 reflected. But the same is not reflected while selecting data. Again when
 the sysdate select is issued the result does not change.

 The date format was not specified while installing Oracle or creating the
 instance, it was a default installation. Is there anyway to change this?

 Other Info on Database :
 Version Oracle 8.1.6
 OS - Windows NT
 NLS_TERRITORY - AMERICA
 NLS_LANGUAGE - AMERICAN
 Charset WE8ISO8851

 Thanks in advance
 Sunil Gompa

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

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

 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Yechiel Adar
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Sunil Kumar
  INET: [EMAIL PROTECTED]

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

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

RE: how to change nls date format.

2002-07-30 Thread Vikas Khanna


Yes. You can do that when you are creating an instance, define the parameter
nls_date_format in the init.ora file as per your requirement, then the
nls_date_format for the Instance would be as supplied by you.

Alter Session/Alter System would do the same at the time so defined.

Vikas Khanna  

-Original Message-
Sent: Tuesday, July 30, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L


Hi,
The default date format for an instance is  dd-mon-.
Ex when issue the following statement Select to_char(sysdate) from dual;
The output is 01-Jan-2002.

I want to change this format to mm/dd/.
According to Oracle documentation this can be changed @ sesion level by the 
following :
Alter session set nls_date_format='mm/dd/';  ( alter system does not 
work).

To change it @ the instance level, the following needs to be added in the 
init.ora file :
Nls_date_format=mm/dd/.

After starting the instance, when we check v$parameter, this change  is 
reflected. But the same is not reflected while selecting data. Again when 
the sysdate select is issued the result does not change.

The date format was not specified while installing Oracle or creating the 
instance, it was a default installation. Is there anyway to change this?

Other Info on Database :
Version Oracle 8.1.6
OS - Windows NT
NLS_TERRITORY - AMERICA
NLS_LANGUAGE - AMERICAN
Charset WE8ISO8851


Thanks in advance
Sunil Gompa





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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Vikas Khanna
  INET: [EMAIL PROTECTED]

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

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

Faster Sqlloader Question

2002-07-30 Thread Bernard, Gilbert


How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader

I loaded 20 000  lines in 1 minute and I wish to load 400 000 lines in the
same time?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ... And another RMAN Q.


Ross
   No. 
   The fundamental way RMAN works is to create the backupset on the target
system.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 30, 2002 12:58 AM
To: Multiple recipients of list ORACLE-L


Hi all,

Env.: 2 Solaris boxes both Oracle 8.1.7.3

BoxA has the RMAN catalog. BoxB is where the Prod db is.  RMAN backups are
initiated from BoxA to backup db in BoxB.  RMAN backupsets are created in
BoxB.  Is there a way to get RMAN to create the backupsets in BoxA instead?

Below is an excerpt of my rman backup script:
---
---
---
replace script backup_db_full {
  execute script archive_log_current;
  execute script alloc_all_disks;
  execute script set_maxcorrupt;
  backup
full
skip inaccessible
tag b_db_full
filesperset 3
format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
database;
  execute script rel_all_disks;
  execute script archive_log_current;
  execute script backup_al_all;
}
---
---

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

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

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

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

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

RE: OT : Basic Critical O.S. Values that Trigger Problem Alert


Vivek
   Here is a search string that should work. The list server will probably
break it into two pieces, so you'll have to patch it back together. Good
luck on your project.

http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1
Jisbn=007222360X

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Monday, July 29, 2002 11:54 PM
To: DENNIS WILLIAMS
Cc: [EMAIL PROTECTED]



Book Oracle High-Performance Tuning with STATSPACK by Don Burleson 

What is the PUBLISHER / Any Other Details ?

Thanks indeed Dennis .


-Original Message-
Sent: Tuesday, July 30, 2002 3:24 AM
To: Multiple recipients of list ORACLE-L


Vivek - This sort of thing must be used with some intelligence. It is
difficult to provide guidelines that work for all sites. Trending is very
important. If a lightly loaded site that suddenly experiences high
statistics, that may something that needs reviewed. Another site may always
be highly loaded so the statistics may always look abysmal compared to the
lightly loaded site. Time of day is also important. Ideally you collect
statistics 24x7 and compare the trends to user events. And see how the
statistics change over time. Trends are much more important than single
statistics out of context. Don Burleson devotes several chapters to
operating system indicators and trending in his book Oracle
High-Performance Tuning with STATSPACK.
   In the end, the critical measurement is user response time. If the users
think performance stinks, then by definition it stinks. Perception is
reality. Users don't care if the problem is with the network, the server,
the Web server, the application server, or the database.  If you have an
opportunity to configure a test that simulates what the users see, that is
ideal. Then when the users say that performance is bad, then you can show
them your trend line. Those sort of facts saves a lot of argument. If your
trend shows performance was bad, you will be inclined to check it out.
Otherwise, the user may be convinced that it was their perception.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Monday, July 29, 2002 2:48 AM
To: Multiple recipients of list ORACLE-L


Hi

We are Trying to make a General Document to be forwarded to Customers which
should allow them to know when they are performing far below normal

At the Operating System Level we are trying to Identify Practical
Critical Values which when below respective Threshold Limits which 
would give the alert about a potential problem .

We are Looking for these in Areas of :-

1) Network Thruput 
2) Memory Utilization 
3) Swap Utilization
4) IO Utilization

Would apreciate actual Commands used (preferably those Generic across
different O.S.)   respective Critical Threshold Limit Values for the Above 

EXAMPLE For Network thruput Between APPLICATION Server machine  Database
Server Machine 
what , by experience , are the parameters  their respective Minimum
threshold Values which would let us know that there is a Severe problem
therein ? 

NOTE - We have generally been measuring this by Manually ftping a Big
File , about 100MB , between APP  DB Server machines , noting the thruput 
Displayed in (kbytes/s) on Completion  Converting this Value to Mega Bits /
Second
(i.e. MBPS) . If this Value is Less than 40MBPS for a 100 MBPS Cable we
know there is a PRoblem with Network Bandwidth.

Miscellaneous - Some Threshold Limits known to us :-

Command - vmstat 5 3
Virtual Memory Statistics: (pagesize = 8192)
  procs  memorypagesintr
cpu
  r   w   u  act free wire fault  cow zero react  pin pout  in  sy  cs us sy
id
  3  1K  34 266K  84K  32K  811M 132M 339M   635 193M0 188 28K  1K 16  7
77
  3  1K  33 267K  84K  32K   410   71  151 0  1310 494  2K  4K 4  2
93
  3  1K  36 269K  82K  32K  5459 1720  807 0 30160 471  3K  4K 37  5
58


1) Utilization of CPU due to Operating System (Internal) Operations (%sy)
Exceeding Utilization due to user Applications (%us)

2) Average Wait of CPU for IO to Complete  (%wio) Greater than () 30 % [
From
sar Command ]

3) Utilization of CPU due to Operating System (Internal) Operations (%sy) 
30 %

4) CPU Utilization - If  Total CPU  Utilization  Consistently Near 0%
Idle Or further Coupled with any of the following :-
   a)Abnormally High Wait for IO (  30 %) [ From sar Command ]
   b)Abnormally High  Operating System CPU Utilization (  30 %)
   c)Abnormally High Run Queue [r  (3 * Number of CPUs)]

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT

How to use pipe-delimited SQL*Plus output with a long datatype



One of our developers wants to create a reusable report where the
pipe-delimited output generated by SQL*Plus would be sent off and used as
input into another process.   The problem is the remarks field which is of
type long.  It causes ORA-00997 errors.   If I take the pipe-delimits off,
the report works o.k.   If I take the remarks field out, the report works
o.k.   There seems to be an incompatibility between the two.   The
developer wants to have the remarks column included in the report and she
also wants the fields to be delimited somehow.

I saw an informative document on Metalink about the ORA-997 error but there
is no work-around suggested.  Does anyone have any bright ideas?   It is
not possible to convert the long within the database, at this time.   This
database will be obsolete in a few months so it's not worth the hassle to
recode all of the apps that use this field.

1  select /*+ USE_NL(CCD,CCDX,ERLI,ERH) */  ar.acct_no || '|' ||
  2  ar.intl_rep_no || '|' ||
  3  ar.rep_id || '|' ||
  4  cr.last_name || '|' ||
  5  cr.first_name || '|' ||
  6  erh.cnfr_no || '|' ||
  7  erli.line_item_amt || '|' ||
  8  erli.line_item_dt || '|' ||
  9  erli.line_seq_no  || '|' ||
 10  ccd.merch_name  || '|' ||
 11  erh.remarks
 12from acct_rep ar,
 13 client_rep cr,
 14 exp_rpt_hdr erh,
 15 exp_rpt_line_item erli,
 16 chrg_card_dtl_xref ccdx,
 17 chrg_card_dtl ccd
 18   where '49368' = erh.acct_no
 19 and ccd.intl_rep_no = erh.intl_rep_no
 20 AND cr.clnt_no = ar.clnt_no
 21 AND cr.intl_rep_no = ar.intl_rep_no
 22 AND erh.intl_rep_no = cr.intl_rep_no
 23 AND erh.acct_no = ar.acct_no
 24 AND erh.intl_rep_no = ar.intl_rep_no
 25 AND erh.cnfr_no = erli.cnfr_no
 26 and trunc(erh.submit_dt)  trunc(sysdate - 25)
 27 AND '810' = erli.pay_seq_no
 28 AND ccdx.cnfr_no (+) = erli.cnfr_no
 29 AND ccdx.line_seq_no (+) = erli.line_seq_no
 30 AND ccdx.cnfr_No is null
 31 AND ar.acct_no = '49368'
 32 AND ccd.acct_no = '49368'
 33 AND ccd.trans_dt = erli.line_item_dt
 34*AND ccd.posted_amt = erli.line_item_amt
SQL /
erh.remarks
*
ERROR at line 11:
ORA-00997: illegal use of LONG datatype


Thanks for any advice.

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Boivin, Patrice J


When people pass exams they tend to say the exam was easy.

When they fail the exam they tend to say either I didn't study enough or
It was hard, that one!

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Monday, July 29, 2002 6:28 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
DBA

Funny, I just heard a seasoned Oracle consultant say
that the 9i exams were considerably more difficult
than the 8i exams.


--- McBain, Neil  SITI-ITDSEL314
[EMAIL PROTECTED] wrote:
 I have just completed my Oracle 8i OCP DBA using
 only ten years of
 experience and the Sybex books (thoroughly
 recommended, except Backup 
 Recovery does not cover enough RMAN syntax). I
 believe if you sit the 9i OCP
 exams then you do have to attend one Oracle course
 (except if you had sat an
 Oracle 9i exam prior to a certain date this year),
 however you can sit the
 8i exams and then the 9i upgrade exam without
 requiring the course (or I
 hope this is true, since I am studying for the
 upgrade exam now). Also heard
 an Oracle trainer say that the 9i exams are easier
 then the 8i exams but do
 not now if this is true or not.
  
 Hope this is of help,
 Neil.
 
 -Original Message-
 Sent: 25 July 2002 23:08
 To: Multiple recipients of list ORACLE-L
 
 
 Also, isn't Oracle now REQUIRING you to go to THEIR
 classes to get your
 certification? 
 
 On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote: 
 
 Paula - I'm skeptical whether a boot camp could
 cover all the material
 
 involved in the OCP tests. I could see where you
 might come out tuned up
 
 enough to whip out a couple of tests, but once you
 got past them, you'd
 
 probably have to do the other tests the hard way --
 study for them. I would
 
 rate the individual classes as more likely to help
 you through the OCP, one
 
 test at a time.
 
 Dennis Williams 
 
 DBA, 20% OCP 
 
 Lifetouch, Inc. 
 
 [EMAIL PROTECTED] 
 
 
 
 -Original Message-
 
 Sent: Thursday, July 25, 2002 12:54 PM
 
 To: Multiple recipients of list ORACLE-L
 
 
 
 
 
 
 
 Guys, 
 
 I have been working hard on Oracle systems at
 various levels - various
 
 platforms, etc. for 8 years.  It has been a long
 time since I have taken a
 
 course.  Would like to go to IOUG.  Reading e-mails
 I have made up my mind -
 
 I think it gives me more options to get certified. 
 Problem has been I work
 
 and have 2 small kids.  Also, I am a consultant who
 has been steadily
 
 applied - not a problem but it means I am either
 working on systems or with
 
 my kids.  I am thinking this is a way to save myself
 the time I don't have
 
 and force the commitment - is it worth it?  I know
 an unfair question but by
 
 taking this and the exams will I indeed completed
 what it takes to become
 
 certified for 9I?
 
 
 
 -Original Message- 
 
 mailto:[EMAIL PROTECTED] ] 
 
 Sent: Thursday, July 25, 2002 8:26 AM 
 
 To: [EMAIL PROTECTED] 
 
 
 
 
 
 Hello, 
 
 
 
 Tomorrow (Friday July 26th) is the last day of our
 Summer Promotion that
 
 entitles 
 
 you to save 50% off our Oracle8i / 9i DBA eBoot
 Camp.  That's right, save
 
 $1,749. 
 
 
 
 We have only a handful of remaining seats for our
 Live, Online,
 
 Instructor-led 
 
 course, so call us and register today!! 
 
 
 
 In case you have lost the previous email I sent,
 here's the facts: 
 
 
 
 
 
 Because the classes must go on...whether there are
 only 5 or as many as 15 
 
 students enrolled...we've decided to allow you the
 opportunity to register
 
 for a 
 
 seat in one of our upcoming courses for 50% OFF. 
 That's right, instead of
 
 the 
 
 normal $3,499 registration fee for our Oracle8i / 9i
 DBA eBoot Camp, you can
 
 
 
 register for only $1,749. 
 
 
 
 Here's what you get: 
 
 
 
 - A 5 week blended eLearning program that includes
 Instructor Led Training 
 
   in our Virtual Classroom environment.  That's
 right, you simply need to
 
 login to 
 
   the Virtual Classroom at the designated time to
 receive Live, Instructor
 
 Led 
 
   Training...without having to leave your home or
 office! 
 
 
 
 - The course includes training for all 5 Oracle8i
 OCP DBA exams, plus as a 
 
   FREE BONUS we are including our Oracle9i New
 Features for Administrators 
 
   course that will prepare you for the Oracle9i
 Upgrade exam.  That's a
 
 
=== message truncated ===


=
Pete Barnett
Lead Database Administrator
The Regence Group
[EMAIL PROTECTED]

__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Barnett
  INET:

Re: ... And another RMAN Q.


The one way is to mount the directory from one box to another using nfs.

Alexandre

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:23 PM


 Ross
No.
The fundamental way RMAN works is to create the backupset on the target
 system.
 Dennis Williams
 DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]


 -Original Message-
 Sent: Tuesday, July 30, 2002 12:58 AM
 To: Multiple recipients of list ORACLE-L


 Hi all,

 Env.: 2 Solaris boxes both Oracle 8.1.7.3

 BoxA has the RMAN catalog. BoxB is where the Prod db is.  RMAN backups are
 initiated from BoxA to backup db in BoxB.  RMAN backupsets are created in
 BoxB.  Is there a way to get RMAN to create the backupsets in BoxA
instead?

 Below is an excerpt of my rman backup script:
 ---
 ---
 ---
 replace script backup_db_full {
   execute script archive_log_current;
   execute script alloc_all_disks;
   execute script set_maxcorrupt;
   backup
 full
 skip inaccessible
 tag b_db_full
 filesperset 3
 format '/oracle1/oracle/admin/RMAN/backup/df/dfset_%s_%t.%d'
 database;
   execute script rel_all_disks;
   execute script archive_log_current;
   execute script backup_al_all;
 }
 ---
 ---

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

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Faster Sqlloader Question


Hi,
Network performance could be a bottleneck.
Do you run loader from server or from remote host?

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 2:58 PM


 How can I do to sqlloader work faster.
 I tryed the DIRECT option, same result.
 I tryed DIRECT and PARALLEL option, same result
 I am working with an Oralce 8.1.6.3.0 patched sqlloader

 I loaded 20 000  lines in 1 minute and I wish to load 400 000 lines in the
 same time?

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Faster Sqlloader Question

2002-07-30 Thread Ayyappan S


U can set the Buffer size to increase the work faster

-Original Message-
Sent: Tuesday, July 30, 2002 6:29 PM
To: Multiple recipients of list ORACLE-L


How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader

I loaded 20 000  lines in 1 minute and I wish to load 400 000 lines in the
same time?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Ayyappan 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: Faster Sqlloader Question

2002-07-30 Thread Mercadante, Thomas F


Gilbert,

disable or remove all constraints on the table being loaded.
remove all indexes on the table being loaded.

if all else fails, buy a faster machine with faster disk.

good luck!

Tom Mercadante
Oracle Certified Professional

-Original Message-
Sent: Tuesday, July 30, 2002 8:59 AM
To: Multiple recipients of list ORACLE-L


How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader

I loaded 20 000  lines in 1 minute and I wish to load 400 000 lines in the
same time?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 11i installation ???

2002-07-30 Thread Karniotis, Stephen


Leslie:

  Please look at www.oaug.org as this is the web site for the Oracle
Applications User Group.  You can join their list serve as well.

As far as your installation issues,
1. You should install the demo environment as is and do not modify anything.
It takes approximately 6GB to install.
2. You are missing some files that are required for the 11.5.6 install and
may have been cleaned up by accident.  This is the Java Runtime Engine.
Please download from either Metalink or it should be on the cds for you.
3. Follow the installation process very carefully, as any modifications in
the process can prevent you from completing the process.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Monday, July 29, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject:11i installation ???

Hi all,

I purchased the Oracle 11i Release 5 (with 11.5.6
family packs) CD pack for Windows from Oracle online
store.

My first installed (Win2000) run out of space, and I
cleaned the folders manually.  When I got more space
and installed again, I got:

not all the dependencies for the component OEM common
files 2.2.0.0.0 are found.   Missing component
Oracle.swd.jre 1.1.8.10.0.

Looks like the manually cleanup didn't go well.  What
should I do now?


Also, how long does the install take? One guy told me
to install one product/one db at a time.  Is this a
good idea?  Is demo db enough? Are there any Oracle
11i group/email list?  I know, lots of questions. :-)

Thanks!

Leslie


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

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

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA


Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM


 When people pass exams they tend to say the exam was easy.

 When they fail the exam they tend to say either I didn't study enough or
 It was hard, that one!

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Région des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED]


  -Original Message-
 Sent: Monday, July 29, 2002 6:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
 DBA

 Funny, I just heard a seasoned Oracle consultant say
 that the 9i exams were considerably more difficult
 than the 8i exams.


 --- McBain, Neil  SITI-ITDSEL314
 [EMAIL PROTECTED] wrote:
  I have just completed my Oracle 8i OCP DBA using
  only ten years of
  experience and the Sybex books (thoroughly
  recommended, except Backup 
  Recovery does not cover enough RMAN syntax). I
  believe if you sit the 9i OCP
  exams then you do have to attend one Oracle course
  (except if you had sat an
  Oracle 9i exam prior to a certain date this year),
  however you can sit the
  8i exams and then the 9i upgrade exam without
  requiring the course (or I
  hope this is true, since I am studying for the
  upgrade exam now). Also heard
  an Oracle trainer say that the 9i exams are easier
  then the 8i exams but do
  not now if this is true or not.
 
  Hope this is of help,
  Neil.
 
  -Original Message-
  Sent: 25 July 2002 23:08
  To: Multiple recipients of list ORACLE-L
 
 
  Also, isn't Oracle now REQUIRING you to go to THEIR
  classes to get your
  certification?
 
  On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote:
 
  Paula - I'm skeptical whether a boot camp could
  cover all the material
 
  involved in the OCP tests. I could see where you
  might come out tuned up
 
  enough to whip out a couple of tests, but once you
  got past them, you'd
 
  probably have to do the other tests the hard way --
  study for them. I would
 
  rate the individual classes as more likely to help
  you through the OCP, one
 
  test at a time.
 
  Dennis Williams
 
  DBA, 20% OCP
 
  Lifetouch, Inc.
 
  [EMAIL PROTECTED]
 
 
 
  -Original Message-
 
  Sent: Thursday, July 25, 2002 12:54 PM
 
  To: Multiple recipients of list ORACLE-L
 
 
 
 
 
 
 
  Guys,
 
  I have been working hard on Oracle systems at
  various levels - various
 
  platforms, etc. for 8 years.  It has been a long
  time since I have taken a
 
  course.  Would like to go to IOUG.  Reading e-mails
  I have made up my mind -
 
  I think it gives me more options to get certified.
  Problem has been I work
 
  and have 2 small kids.  Also, I am a consultant who
  has been steadily
 
  applied - not a problem but it means I am either
  working on systems or with
 
  my kids.  I am thinking this is a way to save myself
  the time I don't have
 
  and force the commitment - is it worth it?  I know
  an unfair question but by
 
  taking this and the exams will I indeed completed
  what it takes to become
 
  certified for 9I?
 
 
 
  -Original Message-
 
  mailto:[EMAIL PROTECTED] ]
 
  Sent: Thursday, July 25, 2002 8:26 AM
 
  To: [EMAIL PROTECTED]
 
 
 
 
 
  Hello,
 
 
 
  Tomorrow (Friday July 26th) is the last day of our
  Summer Promotion that
 
  entitles
 
  you to save 50% off our Oracle8i / 9i DBA eBoot
  Camp.  That's right, save
 
  $1,749.
 
 
 
  We have only a handful of remaining seats for our
  Live, Online,
 
  Instructor-led
 
  course, so call us and register today!!
 
 
 
  In case you have lost the previous email I sent,
  here's the facts:
 
 
 
 
 
  Because the classes must go on...whether there are
  only 5 or as many as 15
 
  students enrolled...we've decided to allow you the
  opportunity to register
 
  for a
 
  seat in one of our upcoming courses for 50% OFF.
  That's right, instead of
 
  the
 
  normal $3,499 registration fee for our Oracle8i / 9i
  DBA eBoot Camp, you can
 
 
 
  register for only $1,749.
 
 
 
  Here's what you get:
 
 
 
  - A 5 week blended eLearning program that includes
  Instructor Led Training
 
in our Virtual Classroom environment.  That's
  right, you simply need to
 
  login to
 
the Virtual Classroom at the designated time to
  receive Live, Instructor
 
  Led
 
Training...without having to leave your home or
  office!
 
 
 
  - The course includes training for all 5 Oracle8i
  OCP DBA exams, plus as a
 
FREE BONUS we are including our Oracle9i New
  Features for Administrators
 
course that

RE: Faster Sqlloader Question

2002-07-30 Thread John . Hallas


See Oracle SQ Loader  - The definitive guide by Jonathan Gennick
Amazon URL is
http://www.amazon.com/exec/obidos/ASIN/1565929489/qid%3D1028034789/sr%3D11-1
/ref%3Dsr%5F11%5F1/104-2680480-7921519#product-details

Also there is a good review (and examples)  by a member of this list -
Stephen Andert at
http://oracle.oreilly.com/news/oraclesqlload_0401.html

HTH

John


-Original Message-
Sent: 30 July 2002 13:59
To: Multiple recipients of list ORACLE-L


How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader

I loaded 20 000  lines in 1 minute and I wish to load 400 000 lines in the
same time?

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Faster Sqlloader Question


Gilbert - Have you looked at:

http://www.orafaq.com/faqloadr.htm#SPEED

Are you saying that performance with and without direct produced the same
time? There were some good suggestions on the list yesterday, I recall, but
I didn't keep them.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, July 30, 2002 7:59 AM
To: Multiple recipients of list ORACLE-L


How can I do to sqlloader work faster.
I tryed the DIRECT option, same result.
I tryed DIRECT and PARALLEL option, same result
I am working with an Oralce 8.1.6.3.0 patched sqlloader

I loaded 20 000  lines in 1 minute and I wish to load 400 000 lines in the
same time?

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

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

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

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

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

RE: How to use pipe-delimited SQL*Plus output with a long

2002-07-30 Thread Godlewski, Melissa

Title: RE: How to use pipe-delimited SQL*Plus output with a long datatype





Cherie,


Did you try a set long to some value to see if that would work? set long 2000


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
Subject: How to use pipe-delimited SQL*Plus output with a long datatype




One of our developers wants to create a reusable report where the
pipe-delimited output generated by SQL*Plus would be sent off and used as
input into another process. The problem is the remarks field which is of
type long. It causes ORA-00997 errors. If I take the pipe-delimits off,
the report works o.k. If I take the remarks field out, the report works
o.k. There seems to be an incompatibility between the two. The
developer wants to have the remarks column included in the report and she
also wants the fields to be delimited somehow.


I saw an informative document on Metalink about the ORA-997 error but there
is no work-around suggested. Does anyone have any bright ideas? It is
not possible to convert the long within the database, at this time. This
database will be obsolete in a few months so it's not worth the hassle to
recode all of the apps that use this field.


1 select /*+ USE_NL(CCD,CCDX,ERLI,ERH) */ ar.acct_no || '|' ||
 2 ar.intl_rep_no || '|' ||
 3 ar.rep_id || '|' ||
 4 cr.last_name || '|' ||
 5 cr.first_name || '|' ||
 6 erh.cnfr_no || '|' ||
 7 erli.line_item_amt || '|' ||
 8 erli.line_item_dt || '|' ||
 9 erli.line_seq_no || '|' ||
10 ccd.merch_name || '|' ||
11 erh.remarks
12 from acct_rep ar,
13 client_rep cr,
14 exp_rpt_hdr erh,
15 exp_rpt_line_item erli,
16 chrg_card_dtl_xref ccdx,
17 chrg_card_dtl ccd
18 where '49368' = erh.acct_no
19 and ccd.intl_rep_no = erh.intl_rep_no
20 AND cr.clnt_no = ar.clnt_no
21 AND cr.intl_rep_no = ar.intl_rep_no
22 AND erh.intl_rep_no = cr.intl_rep_no
23 AND erh.acct_no = ar.acct_no
24 AND erh.intl_rep_no = ar.intl_rep_no
25 AND erh.cnfr_no = erli.cnfr_no
26 and trunc(erh.submit_dt)  trunc(sysdate - 25)
27 AND '810' = erli.pay_seq_no
28 AND ccdx.cnfr_no (+) = erli.cnfr_no
29 AND ccdx.line_seq_no (+) = erli.line_seq_no
30 AND ccdx.cnfr_No is null
31 AND ar.acct_no = '49368'
32 AND ccd.acct_no = '49368'
33 AND ccd.trans_dt = erli.line_item_dt
34* AND ccd.posted_amt = erli.line_item_amt
SQL /
erh.remarks
*
ERROR at line 11:
ORA-00997: illegal use of LONG datatype



Thanks for any advice.


Cherie Machler
Oracle DBA
Gelco Information Network


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

ORA-04021: timeout occurred while waiting to lock object

2002-07-30 Thread Smith, Ron L.



I have a developer using SQLNavigator and getting the following error while
trying to recompile some code.
ORA-04021: timeout occurred while waiting to lock object.  This developer is
the only one in the database.
The database has been 'bounced' to clear all locks but the error still
occurs.

Any ideas?

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

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

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

Re: How to use pipe-delimited SQL*Plus output with a long datatype

2002-07-30 Thread Chaim . Katz



I think the problem is that you can't do an operation (like concatenate) on
a long field.
But another way to get the same output is to set colsep '|' , and then use
plain old select list

chaim




[EMAIL PROTECTED]@fatcity.com on 07/30/2002 09:23:20 AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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




One of our developers wants to create a reusable report where the
pipe-delimited output generated by SQL*Plus would be sent off and used as
input into another process.   The problem is the remarks field which is of
type long.  It causes ORA-00997 errors.   If I take the pipe-delimits off,
the report works o.k.   If I take the remarks field out, the report works
o.k.   There seems to be an incompatibility between the two.   The
developer wants to have the remarks column included in the report and she
also wants the fields to be delimited somehow.

I saw an informative document on Metalink about the ORA-997 error but there
is no work-around suggested.  Does anyone have any bright ideas?   It is
not possible to convert the long within the database, at this time.   This
database will be obsolete in a few months so it's not worth the hassle to
recode all of the apps that use this field.

1  select /*+ USE_NL(CCD,CCDX,ERLI,ERH) */  ar.acct_no || '|' ||
  2  ar.intl_rep_no || '|' ||
  3  ar.rep_id || '|' ||
  4  cr.last_name || '|' ||
  5  cr.first_name || '|' ||
  6  erh.cnfr_no || '|' ||
  7  erli.line_item_amt || '|' ||
  8  erli.line_item_dt || '|' ||
  9  erli.line_seq_no  || '|' ||
 10  ccd.merch_name  || '|' ||
 11  erh.remarks
 12from acct_rep ar,
 13 client_rep cr,
 14 exp_rpt_hdr erh,
 15 exp_rpt_line_item erli,
 16 chrg_card_dtl_xref ccdx,
 17 chrg_card_dtl ccd
 18   where '49368' = erh.acct_no
 19 and ccd.intl_rep_no = erh.intl_rep_no
 20 AND cr.clnt_no = ar.clnt_no
 21 AND cr.intl_rep_no = ar.intl_rep_no
 22 AND erh.intl_rep_no = cr.intl_rep_no
 23 AND erh.acct_no = ar.acct_no
 24 AND erh.intl_rep_no = ar.intl_rep_no
 25 AND erh.cnfr_no = erli.cnfr_no
 26 and trunc(erh.submit_dt)  trunc(sysdate - 25)
 27 AND '810' = erli.pay_seq_no
 28 AND ccdx.cnfr_no (+) = erli.cnfr_no
 29 AND ccdx.line_seq_no (+) = erli.line_seq_no
 30 AND ccdx.cnfr_No is null
 31 AND ar.acct_no = '49368'
 32 AND ccd.acct_no = '49368'
 33 AND ccd.trans_dt = erli.line_item_dt
 34*AND ccd.posted_amt = erli.line_item_amt
SQL /
erh.remarks
*
ERROR at line 11:
ORA-00997: illegal use of LONG datatype


Thanks for any advice.

Cherie Machler
Oracle DBA
Gelco Information Network

--
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: Select Query - Help required

2002-07-30 Thread Amjad Saiyed


u can write a cursor.
or u want the o/p in 1 select statement

rgds,
Ams.
www.medicomsoft.com

|-Original Message-
|From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of 
|karthikeyan
|S
|Sent: Monday, July 29, 2002 6:08 PM
|To: Multiple recipients of list ORACLE-L
|Subject: Select Query - Help required
|
|
|Gurus,
|
|Please read the following problem and help me if you have any 
|solution. 
|
|Select product_id from tname where id = 2; 
|
|Product_ID
|--
|A
|B
|C
|D
|
|But I want the output as follows: 
|
|Select product_id from tname where id = 2; 
|
|Product ID
|-
|ABCD.
|
|Thanks in advance. 
|
|regards,
|Karthik 
|
|-- 
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|-- 
|Author: karthikeyan 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).
|
|

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Faster Sqlloader Question

2002-07-30 Thread Bernard, Gilbert


From server,
I put the table in nologging and I improve the loading by 84%.
Now I am at 400 000 lines in 3 minutes and I wish 400 000 in less then 1
minutes.
I do not have any trigger, index, constraintes or foreigh key.

Any more about

Thanks.

-Message d'origine-
De: Alexandre Gorbatchev
[mailto:[EMAIL PROTECTED]]
Date:   mardi 30 juillet 2002 16:03
À:  Multiple recipients of list ORACLE-L
Objet:  Re: Faster Sqlloader Question 

Hi,
Network performance could be a bottleneck.
Do you run loader from server or from remote host?

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 2:58 PM


 How can I do to sqlloader work faster.
 I tryed the DIRECT option, same result.
 I tryed DIRECT and PARALLEL option, same result
 I am working with an Oralce 8.1.6.3.0 patched sqlloader

 I loaded 20 000  lines in 1 minute and I wish to load 400 000
lines in the
 same time?

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

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


 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Bernard, Gilbert
  INET: [EMAIL PROTECTED]

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

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

Re: ORA-04021: timeout occurred while waiting to lock object


Ron,

When exactly this happens?
Could be running pl/sql procedure and trying do something with itself or
with calling procedure (like grant execute, for example)

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 4:48 PM



 I have a developer using SQLNavigator and getting the following error
while
 trying to recompile some code.
 ORA-04021: timeout occurred while waiting to lock object.  This developer
is
 the only one in the database.
 The database has been 'bounced' to clear all locks but the error still
 occurs.

 Any ideas?

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: JBDC thin driver

2002-07-30 Thread Alex


just put the zip file on your path

On Tue, 30 Jul 2002, Daniel Wisser wrote:

 hi!

 anyone knows an answer to this:

 i want to user JDBC thin driver. i can install it from the
 CD on windows using the manually configured installation.

 since thin driver is said to be purely java, i want to use
 it on linux, too. which are the necessary files?

 are they in
 $ORACLE_HOME\jdbc\lib\classes111.zip

 could not find help in metalink

 thx  regards

 daniel

 --
 Daniel Wisser, Mag.
 Papyrus Quality Assurance
 DB Team

 ISIS Information Systems
 Alter Wienerweg 12
 A-2344 Ma. Enzersdorf, Austria

 Phone: +43-2236-27551-149
 Fax: +43-2236-21081
 E-mail: [EMAIL PROTECTED]

 Hotline: +43-2236-27551-111

 Visit the ISIS Website: http://www.isis-papyrus.com

 ---
 This e-mail is only intended for the recipient and not legally
 binding. Unauthorised use, publication, reproduction or
 disclosure of the content of this e-mail is not permitted.
 ---
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Daniel Wisser
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: 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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Bishop Lewis


Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command line
tools go the way of the dodo? I do 99% of my work (be it serious or not)
from the command line and would truly miss the choice if it were taken away.

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 30 July 2002 15:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM


 When people pass exams they tend to say the exam was easy.

 When they fail the exam they tend to say either I didn't study enough or
 It was hard, that one!

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Région des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED]


  -Original Message-
 Sent: Monday, July 29, 2002 6:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
 DBA

 Funny, I just heard a seasoned Oracle consultant say
 that the 9i exams were considerably more difficult
 than the 8i exams.


 --- McBain, Neil  SITI-ITDSEL314
 [EMAIL PROTECTED] wrote:
  I have just completed my Oracle 8i OCP DBA using
  only ten years of
  experience and the Sybex books (thoroughly
  recommended, except Backup 
  Recovery does not cover enough RMAN syntax). I
  believe if you sit the 9i OCP
  exams then you do have to attend one Oracle course
  (except if you had sat an
  Oracle 9i exam prior to a certain date this year),
  however you can sit the
  8i exams and then the 9i upgrade exam without
  requiring the course (or I
  hope this is true, since I am studying for the
  upgrade exam now). Also heard
  an Oracle trainer say that the 9i exams are easier
  then the 8i exams but do
  not now if this is true or not.
 
  Hope this is of help,
  Neil.
 
  -Original Message-
  Sent: 25 July 2002 23:08
  To: Multiple recipients of list ORACLE-L
 
 
  Also, isn't Oracle now REQUIRING you to go to THEIR
  classes to get your
  certification?
 
  On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote:
 
  Paula - I'm skeptical whether a boot camp could
  cover all the material
 
  involved in the OCP tests. I could see where you
  might come out tuned up
 
  enough to whip out a couple of tests, but once you
  got past them, you'd
 
  probably have to do the other tests the hard way --
  study for them. I would
 
  rate the individual classes as more likely to help
  you through the OCP, one
 
  test at a time.
 
  Dennis Williams
 
  DBA, 20% OCP
 
  Lifetouch, Inc.
 
  [EMAIL PROTECTED]
 
 
 
  -Original Message-
 
  Sent: Thursday, July 25, 2002 12:54 PM
 
  To: Multiple recipients of list ORACLE-L
 
 
 
 
 
 
 
  Guys,
 
  I have been working hard on Oracle systems at
  various levels - various
 
  platforms, etc. for 8 years.  It has been a long
  time since I have taken a
 
  course.  Would like to go to IOUG.  Reading e-mails
  I have made up my mind -
 
  I think it gives me more options to get certified.
  Problem has been I work
 
  and have 2 small kids.  Also, I am a consultant who
  has been steadily
 
  applied - not a problem but it means I am either
  working on systems or with
 
  my kids.  I am thinking this is a way to save myself
  the time I don't have
 
  and force the commitment - is it worth it?  I know
  an unfair question but by
 
  taking this and the exams will I indeed completed
  what it takes to become
 
  certified for 9I?
 
 
 
  -Original Message-
 
  mailto:[EMAIL PROTECTED] ]
 
  Sent: Thursday, July 25, 2002 8:26 AM
 
  To: [EMAIL PROTECTED]
 
 
 
 
 
  Hello,
 
 
 
  Tomorrow (Friday July 26th) is the last day of our
  Summer Promotion that
 
  entitles
 
  you to save 50% off our Oracle8i / 9i DBA eBoot
  Camp.  That's right, save
 
  $1,749.
 
 
 
  We have only a handful of remaining seats for our
  Live, Online,
 
  Instructor-led
 
  course, so call us and register today!!
 
 
 
  In case you have lost the previous email I sent,
  here's the facts:
 
 
 
 
 
  Because the classes must go

Missed digests

2002-07-30 Thread O'Neill, Sean


Due to probs with e-mail servers I missed digests 204 - 207 inclusive from
Oracle-L.  Any chance someone subscribed digest mode with a back catalog ;)
could send them on to me please?. 
It's a bit too slow to review all via web page.

-
Seán O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode] 

This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

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

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

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

Dynamic SQL problem (Oracle 9-8)

2002-07-30 Thread Rafal Wojnar

Title: Dynamic SQL problem (Oracle 9-8)





Hello,


I have software compiled in Oracle 9 environment. And when I try to fetch data using
different versions of Oracle client/server I receive ORA-errors:


1. client 9 -- server 8: ORA-00932: inconsistent datatypes
2. client 8 -- server 9: ORA-01455: converting column overflows integer datatype


These errors do not occur when connecting client 9 to server 9.


I use the following example code (similar to example in Oracle 9 documentation):


 EXEC SQL BEGIN DECLARE SECTION;
 int intn_b;
 VARCHAR buffer[6];
 VARCHAR cursor_def[500];
 EXEC SQL END DECLARE SECTION;


 strcpy((char*)cursor_def.arr, SELECT tstintn,tstcode FROM test WHERE tstcode LIKE 'AU%');
 cursor_def.len = strlen((char*)cursor_def.arr);


 EXEC SQL PREPARE S FROM :cursor_def;
 EXEC SQL DECLARE My_cursor CURSOR FOR S;
 EXEC SQL OPEN My_cursor ;
 EXEC SQL WHENEVER NOT FOUND DO break;


 for (;;)
 {
 int i=0;
 EXEC SQL FETCH My_cursor INTO :intn_b, :buffer;
 buffer.arr[buffer.len] = '\0';
 printf(%6d %7s\n, intn_b, buffer.arr);
 }
 EXEC SQL CLOSE My_cursor;



When I declare cursor without using dynamic SQL:


EXEC SQL DECLARE My_cursor CURSOR FOR
 SELECT tstintn, tstcode FROM test WHERE tstcode LIKE 'AU%';


everything works fine.



Does anyone know how to solve this problem?


Regards,
Rafal Wojnar
e-mail: [EMAIL PROTECTED]

Problem while importing a dmp file

2002-07-30 Thread karthikeyan S


Hi,

I am facing the following problem while importing a .dmp file (from a tape) into 
solaris 8 server. 
Oracle : 8.1.7

I am getting the following error while using the IMP command. 

 Invalid format of import utility name 
 Verify that oracle_home is properly set

Any help regarding this is appreciated.  

Thanks in advance,

regards,
Karthik 
 
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: karthikeyan 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: Faster Sqlloader Question


Maybe partitioning on several disks?

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 4:54 PM


 From server,
 I put the table in nologging and I improve the loading by 84%.
 Now I am at 400 000 lines in 3 minutes and I wish 400 000 in less then 1
 minutes.
 I do not have any trigger, index, constraintes or foreigh key.

 Any more about

 Thanks.

 -Message d'origine-
 De: Alexandre Gorbatchev
 [mailto:[EMAIL PROTECTED]]
 Date: mardi 30 juillet 2002 16:03
 À: Multiple recipients of list ORACLE-L
 Objet: Re: Faster Sqlloader Question

 Hi,
 Network performance could be a bottleneck.
 Do you run loader from server or from remote host?

 Alexandre
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, July 30, 2002 2:58 PM


  How can I do to sqlloader work faster.
  I tryed the DIRECT option, same result.
  I tryed DIRECT and PARALLEL option, same result
  I am working with an Oralce 8.1.6.3.0 patched sqlloader
 
  I loaded 20 000  lines in 1 minute and I wish to load 400 000
 lines in the
  same time?
 
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Bernard, Gilbert
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858)
 538-5051
  San Diego, California-- Public Internet access / Mailing
 Lists
 
 
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Alexandre Gorbatchev
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Bernard, Gilbert
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Alexandre Gorbatchev
  INET: [EMAIL PROTECTED]

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

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

RE: ORA-04021: timeout occurred while waiting to lock object

2002-07-30 Thread Smith, Ron L.


The developer has the object opened for update in SQLNqvigator.  When he
tries to compile and save it,
he gets the error.  

Ron

 

-Original Message-
Sent: Tuesday, July 30, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L


Ron,

When exactly this happens?
Could be running pl/sql procedure and trying do something with itself or
with calling procedure (like grant execute, for example)

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 4:48 PM



 I have a developer using SQLNavigator and getting the following error
while
 trying to recompile some code.
 ORA-04021: timeout occurred while waiting to lock object.  This developer
is
 the only one in the database.
 The database has been 'bounced' to clear all locks but the error still
 occurs.

 Any ideas?

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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


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

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

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

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

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

RE: Cloning Problems

2002-07-30 Thread Hand, Michael T


Ethan,

Consider performing the clone in 2 distinct phases (my SOP). 1) Copying the
source database to the target machine w/ recovery if necessary, and 2)
Renaming/recreating the controlfile.

The recovery can be against a hot backup copy or cold w/ a controlfile
backup, and assures one of having a viable database for renaming.  This
method also gives you the option to apply post-copy archived redos from the
source database if last minute changes are required on the clone.

Please let me know if I've missed your point, as my short-term memory is not
what it should be.
What was I saying?  ;

Mike

-Original Message-
Sent: Monday, July 29, 2002 6:00 PM
To: Multiple recipients of list ORACLE-L


Michael,

See previous post.  It does appear that even during a shutdown immediate
(which does checkpoint) that instance recovery could be required.  Thus we
need redo logs.  Yes they will be recreated as you stated.  However, there
is no way to both rename the database and perform instance recovery on a
clone from a cold backup.  Thus the solution is going to be either shutdown
normal or perform a few log switches and shutdown right away (and cross
fingers).  These both should work but a straight shutdown immediate seems to
be risky.

Ethan Post
perotdba (AIM), epost1 (Yahoo)



-Original Message-
Sent: Monday, July 29, 2002 3:59 PM
To: Multiple recipients of list ORACLE-L


From my understanding you do not need the on-line redo logs unless you
perform a shutdown abort.  As a matter of fact the database will create the
logs if they do not exist when you issue the alter database open resetlogs
command.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Hand, Michael T
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Problem while importing a dmp file

2002-07-30 Thread Farnsworth, Dave


Did you do a 
SET ORACLE_SID=my_importDBName

before issuing the IMP command?

Dave

-Original Message-
Sent: Tuesday, July 30, 2002 10:20 AM
To: Multiple recipients of list ORACLE-L


Hi,

I am facing the following problem while importing a .dmp file (from a tape) into 
solaris 8 server. 
Oracle : 8.1.7

I am getting the following error while using the IMP command. 

 Invalid format of import utility name 
 Verify that oracle_home is properly set

Any help regarding this is appreciated.  

Thanks in advance,

regards,
Karthik 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: karthikeyan 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread KENNETH JANUSZ


I don't know the answer to your question.  But I prefer the command line.
You know exactly what is going on whereas with GUI tools you don't know what
is going on behind the scenes.  Most Unix admin people I know also prefer
the command line.

My 0.02 Euros worth,

Ken Janusz, CPIM

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 10:20 AM


Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command line
tools go the way of the dodo? I do 99% of my work (be it serious or not)
from the command line and would truly miss the choice if it were taken away.

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 30 July 2002 15:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses.

Corporate IT
THE WOOLWICH
--

Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM


 When people pass exams they tend to say the exam was easy.

 When they fail the exam they tend to say either I didn't study enough or
 It was hard, that one!

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Région des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED]


  -Original Message-
 Sent: Monday, July 29, 2002 6:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
 DBA

 Funny, I just heard a seasoned Oracle consultant say
 that the 9i exams were considerably more difficult
 than the 8i exams.


 --- McBain, Neil  SITI-ITDSEL314
 [EMAIL PROTECTED] wrote:
  I have just completed my Oracle 8i OCP DBA using
  only ten years of
  experience and the Sybex books (thoroughly
  recommended, except Backup 
  Recovery does not cover enough RMAN syntax). I
  believe if you sit the 9i OCP
  exams then you do have to attend one Oracle course
  (except if you had sat an
  Oracle 9i exam prior to a certain date this year),
  however you can sit the
  8i exams and then the 9i upgrade exam without
  requiring the course (or I
  hope this is true, since I am studying for the
  upgrade exam now). Also heard
  an Oracle trainer say that the 9i exams are easier
  then the 8i exams but do
  not now if this is true or not.
 
  Hope this is of help,
  Neil.
 
  -Original Message-
  Sent: 25 July 2002 23:08
  To: Multiple recipients of list ORACLE-L
 
 
  Also, isn't Oracle now REQUIRING you to go to THEIR
  classes to get your
  certification?
 
  On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote:
 
  Paula - I'm skeptical whether a boot camp could
  cover all the material
 
  involved in the OCP tests. I could see where you
  might come out tuned up
 
  enough to whip out a couple of tests, but once you
  got past them, you'd
 
  probably have to do the other tests the hard way --
  study for them. I would
 
  rate the individual classes as more likely to help
  you through the OCP, one
 
  test at a time.
 
  Dennis Williams
 
  DBA, 20% OCP
 
  Lifetouch, Inc.
 
  [EMAIL PROTECTED]
 
 
 
  -Original Message-
 
  Sent: Thursday, July 25, 2002 12:54 PM
 
  To: Multiple recipients of list ORACLE-L
 
 
 
 
 
 
 
  Guys,
 
  I have been working hard on Oracle systems at
  various levels - various
 
  platforms, etc. for 8 years.  It has been a long
  time since I have taken a
 
  course.  Would like to go to IOUG.  Reading e-mails
  I have made up my mind -
 
  I think it gives me more options to get certified.
  Problem has been I work
 
  and have 2 small kids.  Also, I am a consultant who
  has been steadily
 
  applied - not a problem but it means I am either
  working on systems or with
 
  my kids.  I am thinking this is a way to save myself
  the time I don't have
 
  and force the commitment - is it worth it?  I know
  an unfair question but by
 
  taking this and the exams will I indeed completed
  what it takes to become
 
  certified for 9I?
 
 
 
  -Original Message-
 
  mailto:[EMAIL PROTECTED] ]
 
  Sent: Thursday, July 25, 2002 8:26 AM
 
  To: [EMAIL PROTECTED]
 
 
 
 
 
  Hello,
 
 
 
  Tomorrow (Friday July

Re: deploy forms on web

2002-07-30 Thread Marc Perkowitz


Here's an excerpt from the documentation:

When deploying a Forms application on the Web, the icon files in ICO format
specified for an iconic button, a menu, or a window) are not used. The only
file formats accessible through the Web are GIF or JPG files (GIF is the
default format).  By default, the icons are found relative to the
DocumentBase Directory, which is the directory containing the HTML file. If
you want to store your icons in another location, you have to create an
application file to specify the virtual directory where the icon files
reside and the file format they use (GIF or JPG). This application file must
be referenced in the HTML file.

Make sure that the .ico extension is not used in your fmb file.  Then the
correction extension will be used by the forms server when your form is on
the web.  Just convert your icon files or get new images and store then in
the correct directory and it will work automatically.

Marc Perkowitz

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 12:08 AM


 So i dont have to do anything with my original .fmb compiled in .fmx for
 icon, but how does forms server would know that where am diplaying connect
 icon on .fmx file will be converted into connect.gif while displaying the
 same .fmx in browser.actulay i have setup everything from my side like
 ,change in forms60web.cfg ,registry file,vitrual directory for icons, but
 still waiting for a luck ..

 -Original Message-
 Sent: Tuesday, July 30, 2002 4:34 AM
 To: Multiple recipients of list ORACLE-L


 Also be sure you have gif files set up.  You can't display icon files in
the
 browser so you must convert any icons to gif files and store them in the
 appropriate directory.

 Marc Perkowitz

 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Monday, July 29, 2002 5:05 PM


  icons not appearing is most commonly caused by the
  various env setting FORMS60_... not mapping correctly
  to the virtual directories defined on the web server
 
  hth
  connor
 
   --- Arvind Kumar [EMAIL PROTECTED] wrote: 
  DearAll
  
  
i want to deploy my application (forms 
   reports) on web, for this i
   have instlled forms and
   reports server 6i can see the forms (.fmx) in
   browser but its window size is
   not appearing proper and the icons also not
   appearing .what could be the
   problem.
  
   Thanks in advance
  
  
   Regards
   Arvind Kumar
   --
   Please see the official ORACLE-L FAQ:
   http://www.orafaq.com
   --
   Author: Arvind Kumar
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- (858) 538-5051  FAX:
   (858) 538-5051
   San Diego, California-- Public Internet
   access / Mailing Lists
  
  
   To REMOVE yourself from this mailing list, send an
   E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of
   'ListGuru') and in
   the message BODY, include a line containing: UNSUB
   ORACLE-L
   (or the name of mailing list you want to be removed
   from).  You may
   also send the HELP command for other information
   (like subscribing).
 
  =
  Connor McDonald
  http://www.oracledba.co.uk
  http://www.oaktable.net
 
  Remember amateurs built the ark - Professionals built the Titanic
 
  __
  Do You Yahoo!?
  Everything you'll ever need on one web page
  from News and Sport to Email and Music Charts
  http://uk.my.yahoo.com
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California-- Public Internet access / Mailing Lists
  
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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).
 --
 Please see the official ORACLE-L FAQ:

Foxbase to Oracle

2002-07-30 Thread dmeng


Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

-- 
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: Install Oracle 8i on Windows XP?

2002-07-30 Thread Eric D. Pierce



On 28 Jul 2002 at 19:33, Michael Kline wrote:

   There are a lot of
   stable production windows server systems. Not as good Unix,
   but it doesn't have to be.
  
  Oh, there are? I've also heard that legend, but after having an 
  Exchange server down
  last week for almost a day, I stopped believing it. Moreover, for the 
  database server,
  it DOES HAVE to be as good and as stable as possible. I can live with 
  rebooting
  a desktop machine twice a day, but if that happens to the database 
  server, I'm in
  trouble. That is why my company is using 4-way HP 9000/N cluster. NT 
  simply doesn't
  cut it.
  
 I've had several Windows NT and 2000 servers that will run Oracle for
 months, but Linux is quite good as well.
 
 I remember once while testing software, I had to busy a version 8
 database, then use the software(DB Scope) to look over the database
 and tell me what was wrong. I got it busy inserting records, dropping
 records, doing full table scans in a script that just kept repeating 
 itself.

Sorry if I missed it before, but what is DB Scope?

 
 Well a few months later I had a revision to the software and had to look
 at a Version 8 database again... I found the I/O in the billions and 
 couldn't figure out why.

Which one? The NT?


 
 The Linux box had been running at 99% CPU running my script for 2-3 months
 doing that test on Oracle 8, running our backup DNS, and backup Email
 server and no one even knew the box was that busy... 

yes, well err 
backup DNS and backup Email server ??? what kind of load 
do they put on the system? Furthermore, does the backup Email 
server have equivalent functionality as Exchange?

I've had Oracle7.3 running on Netware for years along with 
file, print services and an email server (not to mention a 
tape backup program!!!).

executing the dos command copy n:lrg_file.txt o:*.* 
practically kills the whole server, oracle or not.



Yet, our super
 powerful Exchange Server was down usually 1-2 times a week and was probably
 3-5 times faster with twin processors.

Yes, Exchange (aka SQL Server) is a nightmare, which is well 
understood by ayone that has been in the windows server world 
for long. 

Which is irrelevant to running Oracle on NT/2000 as far as I 
can tell. 



 
 Usually when management sees a Windows database server and tries to 
 add something to it, that's when you really start having problems.
 Keep it plain and it will do much better. 

Excellent advice, that is what we do.

Unfortunately, for non-enterprise Oracle users, you need a 
pile of NT/2000 servers (don't know if this is same for *nix) 
if you want to use the main components of Oracle's latest 
technology stack.

1) db server
2) OEM server
3) connectivity server (oracle names, or whatever the heck 
they call it)
4) iAS server
5) and goodness knows what else, I haven't finished PTFM/RTFM 
for db v8i/9i

blech.

presumably, at least for small/non-enterprise installs, #2 and 
#3 can probably run (together) on an old utility box, which we 
will have a lot of as there are hundreds of desktop PII/350 
SMP boxes (IBM Intellistations) that are being replaced by new 
P4s.

 
 I just found 99% cpu for 3 months very impressive.

Great. It is refreshing to see someone providing some actual 
factual info.

My assumption is that (everything else equal) *nix on a PC 
server is a superior technology, more performant, more stable.

Unfortunately one has to know a lot more low level tech stuff 
to get into the *nix game than is the case with windows, and 
therefore *nix on a PC will remain to a large extent in the 
domain of high-skill-set purists and tech elites, not the mass 
market.

regards,
ep



http://www.retrobox.com/rbwww/home


-- 
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: pfile/spfile Sync Problems

2002-07-30 Thread John . Hallas


John,
I have been discussing this with a colleague and our question is  - what are
you hoping to achieve?
If you are using a spfileSID.ora file then that will be used every time you
startup so in what circumstances would you use the pfile?

PS one suggestion re the problem creating the trigger is to create it as
user sys rather than another user

John


-Original Message-
Sent: 29 July 2002 21:48
To: Multiple recipients of list ORACLE-L


Hi all,

I'm in the process of migrating 8i to 9i over the next couple weeks.  One of
my outstanding tasks it to find a way to keep the pfile/spfile synchronized
as
much as reasonable possible.  I figured the easiest way would be to include 
startup and shutdown triggers to regenerate them from each other and include

similar work in the backup.  No, it's not perfect, but should be sufficient
to meet the immediate need, after all pfile will eventually go away...maybe.
Anyway, I wrote the following segment which works great at the command line:


  1  DECLARE
  2  spfile   VARCHAR2(120);
  3  pfileVARCHAR2(120);
  4  cursor_handleINTEGER;
  5  return_cdINTEGER;
  6  BEGIN
  7SELECT rtrim(a.value,'bdump')||'pfile/spfile'||b.value||'.ora',
  8   rtrim(a.value,'bdump')||'pfile/init'||b.value||'.ora'
  9INTO   spfile, pfile
 10FROM   v$parameter a, v$parameter b
 11WHERE  a.name = 'background_dump_dest' and b.name = 'db_name';
 12cursor_handle:=DBMS_SQL.OPEN_CURSOR;
 13DBMS_SQL.PARSE(cursor_handle,'CREATE SPFILE='''||spfile||''' FROM  /
   PFILE='''||pfile||,dbms_sql.native);
 14return_cd:=DBMS_SQL.EXECUTE(cursor_handle);
 15DBMS_SQL.CLOSE_CURSOR(cursor_handle);
 16EXCEPTION
 17WHEN OTHERS THEN
 18  DBMS_SQL.CLOSE_CURSOR(cursor_handle);
 19* END;

When I turn it into a trigger:
CREATE OR REPLACE TRIGGER sys.sync_spfile AFTER STARTUP ON DATABASE
{everything else the same}

It compiles fine.  However it doesn't execute on startup for some reason.

Any ideas?

TIA,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: how to change nls date format.

2002-07-30 Thread Igor Neyman


Do you have nls_language parameter specified in your init.ora file?
I think, Oracle will not pick up the value for nls_date_format from
init.ora unless you have nls_language specified in it.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 1:38 AM


 Hi,
 The default date format for an instance is  dd-mon-.
 Ex when issue the following statement Select to_char(sysdate) from dual;
 The output is 01-Jan-2002.

 I want to change this format to mm/dd/.
 According to Oracle documentation this can be changed @ sesion level by
the
 following :
 Alter session set nls_date_format='mm/dd/';  ( alter system does not
 work).

 To change it @ the instance level, the following needs to be added in the
 init.ora file :
 Nls_date_format=mm/dd/.

 After starting the instance, when we check v$parameter, this change  is
 reflected. But the same is not reflected while selecting data. Again when
 the sysdate select is issued the result does not change.

 The date format was not specified while installing Oracle or creating the
 instance, it was a default installation. Is there anyway to change this?

 Other Info on Database :
 Version Oracle 8.1.6
 OS - Windows NT
 NLS_TERRITORY - AMERICA
 NLS_LANGUAGE - AMERICAN
 Charset WE8ISO8851


 Thanks in advance
 Sunil Gompa





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

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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: Igor Neyman
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Creating a DEFAULT database

2002-07-30 Thread Straub, Dan

Title: RE: Creating a **DEFAULT** database





 
 The same thing is not required on Sun Solaris. On Solaris 'user1' still belongs 
 to a different unix group. 
 


I have an user on both DG-UX and HP-UX which is not in the 'dba' group. Connection (internal or tcpip) works fine on both systems with following setup:

export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=ORCL
export ORACLE_PATH=.:${ORACLE_HOME}/bin:/opt/bin:/bin:/GNU/bin/make:/usr/ccs/bin
export SQLPATH=$ORACLE_HOME/sqlplus/admin
export PATH=${PATH}:${ORACLE_HOME}/bin:/usr/contrib/bin/X11:${OBK_HOME}/bin


I initially got the 'oracle not available' error on HP-UX when I tested this just now on both systems, but then realized that the HP was running 8.1.7 and DG was on 8.1.6. I had forgotten to set oracle_home correctly to 8.1.7. :) Once I did that, all was fine.

Regards,
Dan Straub
McKesson Information Solutions
541-681-8278
44°03'N 123°05'W (or thereabouts)
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

RE: Foxbase to Oracle

2002-07-30 Thread Mark Leith


Not sure if Oracle provides one, but another solution is available here:

http://www.kumaran.com/xbaseconverter.asp

If it is such a small app though - why not just stick it in (dare I say
this) something like Access or SQLServer..

-Original Message-
[EMAIL PROTECTED]
Sent: 30 July 2002 17:09
To: Multiple recipients of list ORACLE-L


Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

--
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: Mark Leith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Tim Gorman


GUI tools are simply a front-end presentation layer for SQL commands.  GUI
tools do not bypass the SQL command-line layer;  they only abstract it.
Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but
simply do a lot less abstraction on the presentation.  Command-line tools
will never go the way of the dodo, because they are part of the diagnostic
process for GUI tools, if nothing else.  Also, since the days of ISPF and
JCL (anybody recognize those), on platforms from OS/360 through Windows, it
has proven impossible to wean users away from command-line, especially for
batch processing...

The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 9:20 AM


Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command line
tools go the way of the dodo? I do 99% of my work (be it serious or not)
from the command line and would truly miss the choice if it were taken away.

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 30 July 2002 15:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses.

Corporate IT
THE WOOLWICH
--

Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM


 When people pass exams they tend to say the exam was easy.

 When they fail the exam they tend to say either I didn't study enough or
 It was hard, that one!

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Région des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED]


  -Original Message-
 Sent: Monday, July 29, 2002 6:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
 DBA

 Funny, I just heard a seasoned Oracle consultant say
 that the 9i exams were considerably more difficult
 than the 8i exams.


 --- McBain, Neil  SITI-ITDSEL314
 [EMAIL PROTECTED] wrote:
  I have just completed my Oracle 8i OCP DBA using
  only ten years of
  experience and the Sybex books (thoroughly
  recommended, except Backup 
  Recovery does not cover enough RMAN syntax). I
  believe if you sit the 9i OCP
  exams then you do have to attend one Oracle course
  (except if you had sat an
  Oracle 9i exam prior to a certain date this year),
  however you can sit the
  8i exams and then the 9i upgrade exam without
  requiring the course (or I
  hope this is true, since I am studying for the
  upgrade exam now). Also heard
  an Oracle trainer say that the 9i exams are easier
  then the 8i exams but do
  not now if this is true or not.
 
  Hope this is of help,
  Neil.
 
  -Original Message-
  Sent: 25 July 2002 23:08
  To: Multiple recipients of list ORACLE-L
 
 
  Also, isn't Oracle now REQUIRING you to go to THEIR
  classes to get your
  certification?
 
  On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote:
 
  Paula - I'm skeptical whether a boot camp could
  cover all the material
 
  involved in the OCP tests. I could see where you
  might come out tuned up
 
  enough to whip out a couple of tests, but once you
  got past them, you'd
 
  probably have to do the other tests the hard way --
  study for them. I would
 
  rate the individual classes as more likely to help
  you through the OCP, one
 
  test at a time.
 
  Dennis Williams
 
  DBA, 20% OCP
 
  Lifetouch, Inc.
 
  [EMAIL PROTECTED]
 
 
 
  -Original Message-
 
  Sent: Thursday, July 25, 2002 12:54 PM
 
  To: Multiple recipients of list ORACLE-L
 
 
 
 
 
 
 
  Guys,
 
  I have been working hard on Oracle systems at
  various levels - various
 
  platforms, etc. for 8 years.  It has been a long
  time since I have taken a
 
  course.  Would like to go to IOUG.  Reading e-mails
  I have made up my mind -
 
  I think it gives me more options to get certified.
  Problem has

DBD::Oracle and JDBC Thin

2002-07-30 Thread Jesse, Rich


Has anyone been able to install/use the DBD::Oracle Perlmod with only the
JDBC thin driver?  I keep nabbing .h files and .mk files from other boxes,
then trying to re-install, but I haven't had much luck yet.

Jared, this would be a great free chapter from your new book!  ;)  (I'll
buy it anyway!)

BTW, I need to use the thin driver because my machine is an Alpha running
RedHat, which has no OCI support from Oracle.

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

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

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

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Jared . Still


 ...hardcore DBAs might never use GUI tools.

I fit that category.  :)

Gaja Vaidyanatha has recently moved to Oracle, and server tools
are now his responsibility.

I challenged him to turn OEM into something I would actually
be willing to use.  :)

Jared






Alexandre Gorbatchev [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 07:28 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA


Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while 
hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM





-- 
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: Replication Question

2002-07-30 Thread John Weatherman


So how do I get into the archives?  I've got a question I know I've seen
answered.

Thanks,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

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

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

Space Contention and LOG_BUFFER size

2002-07-30 Thread Farnsworth, Dave


I am doing some performance monitoring on an 8.1.7 DB on Windoze.  I ran the following 
query;

SQL select name,value
  2  from v$sysstat
  3  where name = 'redo log space requests';

NAME  VALUE
 --
redo log space requests  27


If the number of 'redo log space requests' is much over zero then I should increase 
the LOG_BUFFER size in my init.ora, at least that is what I get from RTFM.  One 
question I have is that does the size of the LOG_BUFFER parameter have to be a 
multiple of the DB_BLOCK_SIZE parameter?  I vaguely remember that it shuold be but 
have not found anything in TFM to verify this.

Thanks,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: DBD::Oracle and JDBC Thin

2002-07-30 Thread Jared . Still


Jesse,

Enlighten me as to why DBD::Oracle cares which JDBC driver you use. 

Jared






Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 09:38 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:DBD::Oracle and JDBC Thin


Has anyone been able to install/use the DBD::Oracle Perlmod with only the
JDBC thin driver?  I keep nabbing .h files and .mk files from other boxes,
then trying to re-install, but I haven't had much luck yet.

Jared, this would be a great free chapter from your new book!  ;)  (I'll
buy it anyway!)

BTW, I need to use the thin driver because my machine is an Alpha running
RedHat, which has no OCI support from Oracle.

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

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

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



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

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

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

RE: Foxbase to Oracle

2002-07-30 Thread dmeng



Thanks all who replied.
I agree that for this app SQL Server might be more suitable. My main
concern is the application code that enforces business logic.  How do we
migrate the source code into the new application without re-rewriting? I
will definitely look into the tool recommended by Mike. But if we are to go
with SQL Server or Access, what do we do with the application code?
Thanks again

Dennis Meng
Database Administrator
Focal Communications Corp.


   

  Mark Leith 

  mark@cool-tools To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  .co.uk  cc: 

  Sent by: Subject: RE: Foxbase to Oracle  

  [EMAIL PROTECTED] 

   

   

  07/30/02 11:28   

  AM   

  Please respond   

  to ORACLE-L  

   

   





Not sure if Oracle provides one, but another solution is available here:

http://www.kumaran.com/xbaseconverter.asp

If it is such a small app though - why not just stick it in (dare I say
this) something like Access or SQLServer..

-Original Message-
[EMAIL PROTECTED]
Sent: 30 July 2002 17:09
To: Multiple recipients of list ORACLE-L


Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

--
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: Mark Leith
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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,

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Straub, Dan

Title: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA





  
  ...hardcore DBAs might never use GUI tools.
  
 
 I fit that category. :)
 


What about the OUI? Don't you use that? :)


Dan.

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA



I fit that category as well. I talked to him last night he's gonna
try :)

--- [EMAIL PROTECTED] wrote:
  ...hardcore DBAs might never use GUI tools.
 
 I fit that category.  :)
 
 Gaja Vaidyanatha has recently moved to Oracle, and server tools
 are now his responsibility.
 
 I challenged him to turn OEM into something I would actually
 be willing to use.  :)
 
 Jared
 
 
 
 
 
 
 Alexandre Gorbatchev [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/30/2002 07:28 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: Guys:  Is this worth $1,749 for 8 year
 Oracle veteran DBA
 
 
 Oracle's politic is to make us using GUI tools. This is reflected in
 OCP
 exams, so I can conclude that for newbies exams become easier while 
 hardcore
 DBAs might never use GUI tools.
 
 Alexandre
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, July 30, 2002 3:03 PM
 
 
 
 
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.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).

RE: Replication Question


John - I've noticed that Google queries pull up info from the archives.
Obviously you'll get other stuff, but if you can make your query pretty
specific it may get you what you need.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-Original Message-
Sent: Tuesday, July 30, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L


So how do I get into the archives?  I've got a question I know I've seen
answered.

Thanks,

John P Weatherman
Database Administrator
Replacements Ltd.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Weatherman
  INET: [EMAIL PROTECTED]

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

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

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

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

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Bill Pass


Being a hardcore SQL*Plus hacker as well I was amazed
to find a freebie on the net that I actually liked and
used. It will work with any JDBC accessible database
(being written itself in java). All you have to do is
load your JDBC driver of choice. It also provides a
panel for entering SQL commands directly (for you
hardcore types).

The name of the tool is DBVisualizer and is available
at the following URL:
http://www.minq.se/products/dbvis/index.html

--- [EMAIL PROTECTED] wrote:
  ...hardcore DBAs might never use GUI tools.
 
 I fit that category.  :)
 
 Gaja Vaidyanatha has recently moved to Oracle, and
 server tools
 are now his responsibility.
 
 I challenged him to turn OEM into something I would
 actually
 be willing to use.  :)
 
 Jared
 
 
 
 
 
 
 Alexandre Gorbatchev
 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/30/2002 07:28 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: Guys:  Is this worth
 $1,749 for 8 year Oracle veteran DBA
 
 
 Oracle's politic is to make us using GUI tools. This
 is reflected in OCP
 exams, so I can conclude that for newbies exams
 become easier while 
 hardcore
 DBAs might never use GUI tools.
 
 Alexandre
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Tuesday, July 30, 2002 3:03 PM
 
 
 
 
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Karniotis, Stephen


Tim:

  I take exception to the age thing here.  Yes, I remember rewriting the MVS
procs for Oracle's MVS implementation because they never checked to see if
MPM was running in the background task manager of SDSF.  Add to it that I
wrote (helped Oracle) a complete TSO Dialog Manager interface to all of the
Oracle tools that ran on the mainframe.

  GUI tools hide the work involved in solving the problem  Go Command
Line!!!

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, July 30, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Guys:  Is this worth $1,749 for 8 year Oracle veteran
DBA

GUI tools are simply a front-end presentation layer for SQL commands.  GUI
tools do not bypass the SQL command-line layer;  they only abstract it.
Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but
simply do a lot less abstraction on the presentation.  Command-line tools
will never go the way of the dodo, because they are part of the diagnostic
process for GUI tools, if nothing else.  Also, since the days of ISPF and
JCL (anybody recognize those), on platforms from OS/360 through Windows, it
has proven impossible to wean users away from command-line, especially for
batch processing...

The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 9:20 AM


Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command line
tools go the way of the dodo? I do 99% of my work (be it serious or not)
from the command line and would truly miss the choice if it were taken away.

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 30 July 2002 15:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses.

Corporate IT
THE WOOLWICH
--

Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM


 When people pass exams they tend to say the exam was easy.

 When they fail the exam they tend to say either I didn't study enough or
 It was hard, that one!

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Région des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED]


  -Original Message-
 Sent: Monday, July 29, 2002 6:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
 DBA

 Funny, I just heard a seasoned Oracle consultant say
 that the 9i exams were considerably more difficult
 than the 8i exams.


 --- McBain, Neil  SITI-ITDSEL314
 [EMAIL PROTECTED] wrote:
  I have just completed my Oracle 8i OCP DBA using
  only ten years of
  experience and the Sybex books (thoroughly
  recommended, except Backup 
  Recovery does not cover enough RMAN syntax). I
  believe if you sit the 9i OCP
  exams then you do have to attend one Oracle course
  (except if you had sat an
  Oracle 9i exam prior to a certain date this year),
  however you can sit the
  8i exams and then the 9i upgrade exam without
  requiring the course (or I
  hope this is true, since I am studying for the
  upgrade exam now). Also heard
  an Oracle trainer say that the 9i exams are easier
  then the 8i exams but do
  not now if this is true or not.
 
  Hope this is of help,
  Neil.
 
  -Original Message-
  Sent: 25 July 2002 23:08
  To: Multiple recipients of list ORACLE-L
 
 
  Also, isn't Oracle now REQUIRING you to go to THEIR
  classes to get your
  certification?
 
  On Thu, 2002-07-25 at 14:19, DENNIS WILLIAMS wrote:
 
  Paula - I'm skeptical whether a boot camp could
  cover all the material
 
  involved in the OCP tests. I could see where you
  might come out tuned up

RE: Slightly OT: Chart generation tool for db monitoring scripts

2002-07-30 Thread Jamadagni, Rajendra


Thanks everyone for your kind help, advise and hints.

I finally got it working with gnuplot.

I had to make some changes to my code, but this is how it works.

1. Every 10 minutes MS task scheduler wakes up and executes a CMD file.
2. This CMD file 
   a. Executes a SQL script that generates a HTML table output on different
data.
   b. Generates an appropriate DATA files for the same.
   c. Generates a script for gnuplot to load and generate the plots as gif
files.
   d. Loads gnuplot and generates the gif files.
   e. Moved the images to their default directories.
3. By clocking on the column header (in the HTML report), I open a new
window and display the plot for that parameter.

Works very nice ... I have a long way to go yet (to cover all statistics),
but this has been a good start and good learning on GNUPLOT.

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!
-Original Message-
Sent: Monday, July 29, 2002 10:10 PM
To: '[EMAIL PROTECTED]'


Sorry, I missed the part about automating it. Please let us know how
gnuchart works. 
 -Original Message- 
 From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 
 
 me being lazy (and excel ignorant), wanted to find an 
 automated way out of 
 this. If I am going to be generating 10-15 graphs, doing it 
 every half hour 
 might just be too much for me. 
  



*2

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.

*2

RE: Foxbase to Oracle

2002-07-30 Thread Karniotis, Stephen


Dennis:

   Foxbase was originally called 10-base before Fox Systems change the name.
Foxbase was changed to FoxPro and then purchased by Microsoft and called
Microsoft FoxPro, and then Microsoft Visual FoxPro.  I would highly
recommend investigating the MSFT solution.  Sorry guys, but this is a
realistic solution.  Oracle, for eight users, will probably cost too much
for the implementation.

   If you need to convert to Oracle, do the following:
1. Convert to FoxPro
2. Bridge Visual FoxPro to SQLServer and use the Data Transformation
Services (DTS) to migrate the data to Oracle.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, July 30, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:Foxbase to Oracle 

Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: 11i installation ???

2002-07-30 Thread James J. Morrow




Leslie Lu wrote:
 
 Hi all,
 
 I purchased the Oracle 11i Release 5 (with 11.5.6
 family packs) CD pack for Windows from Oracle online
 store.
 
 My first installed (Win2000) run out of space, and I
 cleaned the folders manually.  When I got more space
 and installed again, I got:
 
 not all the dependencies for the component OEM common
 files 2.2.0.0.0 are found.   Missing component
 Oracle.swd.jre 1.1.8.10.0.
 
 Looks like the manually cleanup didn't go well.  What
 should I do now?
 
 Also, how long does the install take? One guy told me
 to install one product/one db at a time.  Is this a
 good idea?  Is demo db enough? Are there any Oracle
 11i group/email list?  I know, lots of questions. :-)
 
 Thanks!
 
 Leslie

Bear in mind that Oracle Applications 11i has certain dependencies that are
specific to the M$FT Windows NT/2000 platform.  Most notably:  Visual C++ 6.0
and MKS Toolkit (both of which are additional cost items, totalling between
$600-$1000).  

There are several documents on metalink you may want to look at if you've had a
failed install (on Windows... similar docs exist for Unix):

  DocID:  137200.1 Checklist when OUI Fails for Windows
  DocID:  143976.1 How to clean up a failed install of OA 11.5 on an NT
Platform

As far as how long the install takes:

  On Unix, once you've built your staging area, it can take upwards of 2-3 hours
to do a full install of the VIS demo instance.  Mostly determined by the speed
of your system (CPUs/Memory/Disk).

  On NT, it can take a bit longer.  Especially if you factor in the additional
time required to install the prerequisites.  (MS Visual C++, MKS Toolkit,
GNUMake).  And, of course, there are at least 5 reboots involved...  (More if
you're into patching things current...)

-- James

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
McKinney, TX, USA

The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man.  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: [EMAIL PROTECTED]

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

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

Re: How to use pipe-delimited SQL*Plus output with a long datatype



Thanks to those who recommended the relatively new set colsep command.   It
did work in this report.

Thanks again,

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
[EMAIL PROTECTED]
  
ardier.comTo: Multiple recipients of 
list ORACLE-L [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] cc:  
  
  Subject: Re: How to use 
pipe-delimited SQL*Plus output with a long 
   datatype
  
07/30/02 09:59 AM  
  
Please respond to ORACLE-L 
  
   
  
   
  





I think the problem is that you can't do an operation (like concatenate) on
a long field.
But another way to get the same output is to set colsep '|' , and then use
plain old select list

chaim




[EMAIL PROTECTED]@fatcity.com on 07/30/2002 09:23:20 AM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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




One of our developers wants to create a reusable report where the
pipe-delimited output generated by SQL*Plus would be sent off and used as
input into another process.   The problem is the remarks field which is of
type long.  It causes ORA-00997 errors.   If I take the pipe-delimits off,
the report works o.k.   If I take the remarks field out, the report works
o.k.   There seems to be an incompatibility between the two.   The
developer wants to have the remarks column included in the report and she
also wants the fields to be delimited somehow.

I saw an informative document on Metalink about the ORA-997 error but there
is no work-around suggested.  Does anyone have any bright ideas?   It is
not possible to convert the long within the database, at this time.   This
database will be obsolete in a few months so it's not worth the hassle to
recode all of the apps that use this field.

1  select /*+ USE_NL(CCD,CCDX,ERLI,ERH) */  ar.acct_no || '|' ||
  2  ar.intl_rep_no || '|' ||
  3  ar.rep_id || '|' ||
  4  cr.last_name || '|' ||
  5  cr.first_name || '|' ||
  6  erh.cnfr_no || '|' ||
  7  erli.line_item_amt || '|' ||
  8  erli.line_item_dt || '|' ||
  9  erli.line_seq_no  || '|' ||
 10  ccd.merch_name  || '|' ||
 11  erh.remarks
 12from acct_rep ar,
 13 client_rep cr,
 14 exp_rpt_hdr erh,
 15 exp_rpt_line_item erli,
 16 chrg_card_dtl_xref ccdx,
 17 chrg_card_dtl ccd
 18   where '49368' = erh.acct_no
 19 and ccd.intl_rep_no = erh.intl_rep_no
 20 AND cr.clnt_no = ar.clnt_no
 21 AND cr.intl_rep_no = ar.intl_rep_no
 22 AND erh.intl_rep_no = cr.intl_rep_no
 23 AND erh.acct_no = ar.acct_no
 24 AND erh.intl_rep_no = ar.intl_rep_no
 25 AND erh.cnfr_no = erli.cnfr_no
 26 and trunc(erh.submit_dt)  trunc(sysdate - 25)
 27 AND '810' = erli.pay_seq_no
 28 AND ccdx.cnfr_no (+) = erli.cnfr_no
 29 AND ccdx.line_seq_no (+) = erli.line_seq_no
 30 AND ccdx.cnfr_No is null
 31 AND ar.acct_no = '49368'
 32 AND ccd.acct_no = '49368'
 33 AND ccd.trans_dt = erli.line_item_dt
 34*AND ccd.posted_amt = erli.line_item_amt
SQL /
erh.remarks
*
ERROR at line 11:
ORA-00997: illegal use of LONG datatype


Thanks for any advice.

Cherie Machler
Oracle DBA
Gelco Information Network

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

Creating sequences on the DUAL table?



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread April Wells


Snip
The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...
/snip

Except you still can't select from V$AQ in sqlplus even in 9i... just a
teeny little thing... but (per a dozen hits on metalink) it only works in
server manager... 

ajw


-Original Message-
Sent: Tuesday, July 30, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L


Tim:

  I take exception to the age thing here.  Yes, I remember rewriting the MVS
procs for Oracle's MVS implementation because they never checked to see if
MPM was running in the background task manager of SDSF.  Add to it that I
wrote (helped Oracle) a complete TSO Dialog Manager interface to all of the
Oracle tools that ran on the mainframe.

  GUI tools hide the work involved in solving the problem  Go Command
Line!!!

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, July 30, 2002 12:38 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Guys:  Is this worth $1,749 for 8 year Oracle veteran
DBA

GUI tools are simply a front-end presentation layer for SQL commands.  GUI
tools do not bypass the SQL command-line layer;  they only abstract it.
Command-line tools (such as SQL*Plus) use the same API as the GUI tools, but
simply do a lot less abstraction on the presentation.  Command-line tools
will never go the way of the dodo, because they are part of the diagnostic
process for GUI tools, if nothing else.  Also, since the days of ISPF and
JCL (anybody recognize those), on platforms from OS/360 through Windows, it
has proven impossible to wean users away from command-line, especially for
batch processing...

The functionality for Server Manager command-line was migrated in it's
entirety into SQL*Plus (near as I can tell, including ORADEBUG), so Oracle
eliminated svrmgrl not so much as a way of deprecating command-line
utilities in general, but rather to consolidate redundant products...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 9:20 AM


Yes, i seem to recall whilst on the crashes, dumps and corruptions seminar
that it was mentioned that Oracle are moving away from command line tools in
favour of GUI tools in much the same way that server manager is no longer
available - does anyone know if this is truly the case? Will command line
tools go the way of the dodo? I do 99% of my work (be it serious or not)
from the command line and would truly miss the choice if it were taken away.

Lewis Bishop
---
Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - [EMAIL PROTECTED]


-Original Message-
Sent: 30 July 2002 15:28
To: Multiple recipients of list ORACLE-L

This header confirms that this email message has been swept for the
presence of computer viruses.

Corporate IT
THE WOOLWICH
--

Oracle's politic is to make us using GUI tools. This is reflected in OCP
exams, so I can conclude that for newbies exams become easier while hardcore
DBAs might never use GUI tools.

Alexandre
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 3:03 PM


 When people pass exams they tend to say the exam was easy.

 When they fail the exam they tend to say either I didn't study enough or
 It was hard, that one!

 Regards,
 Patrice Boivin
 Systems Analyst (Oracle Certified DBA)

 Systems Admin  Operations | Admin. et Exploit. des systèmes
 Technology Services| Services technologiques
 Informatics Branch | Direction de l'informatique
 Maritimes Region, DFO  | Région des Maritimes, MPO

 E-Mail: [EMAIL PROTECTED]


  -Original Message-
 Sent: Monday, July 29, 2002 6:28 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran
 DBA

 Funny, I just heard a seasoned Oracle consultant say
 that the 9i exams were considerably more difficult
 than the 8i exams.


 --- McBain, Neil  SITI-ITDSEL314
 [EMAIL PROTECTED] wrote:
  I have just completed my Oracle 8i OCP DBA using
  only ten years of
  experience and the Sybex books (thoroughly
  recommended, except Backup 
  Recovery does not cover enough RMAN syntax). I
  believe if you sit the 9i OCP
  exams then you do have to attend one Oracle course
  (except if you had sat an
  Oracle 9i exam prior to a certain date this year),
  however you can sit the
  8i exams and then the 9i upgrade exam without
  requiring the course (or I
  hope this is true, since I am studying for the
  upgrade exam now).

db comparison site

2002-07-30 Thread Boivin, Patrice J


FYI,

While looking for db comparisons I found a site that has a few:

http://www.itsystems.lv/gints/compare_db.htm

Note that it is located in Latvia.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-- 
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: Space Contention and LOG_BUFFER size

2002-07-30 Thread Babu . Nagarajan



More than the number of time you are waiting for 'redo log space requests'
its more important to find out how long you are waiting for that. 27 times
out of a million might not be a big deal for you to tune.

having said that, here is a posting by Steve Adams on this topic

Q : Every day our production database has more than 10 redo log space requests. 
Oracle suggested that this number should be near 0.
I resized the log files, and increased the log buffer to 1M. What else can I do?

A :  This idea of increasing the log_buffer to get space requests down to 0 is both 
ineffective and bad for performance.
There is always a risk of space requests at log switches and a few other points when 
redo generation is disabled entirely.
 It does not matter how big your log buffer is then. You will get space request waits 
if you try to generate redo at that time.
Also, a large log buffer is actually much worse for performance than the occasional 
space request,
even if that is a genuine log buffer space wait.  


hth

babu




Farnsworth, Dave [EMAIL PROTECTED]@fatcity.com on
07/30/2002 12:19:02 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


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



I am doing some performance monitoring on an 8.1.7 DB on Windoze.  I ran
the following query;

SQL select name,value
  2  from v$sysstat
  3  where name = 'redo log space requests';

NAME  VALUE
 --
redo log space requests  27


If the number of 'redo log space requests' is much over zero then I should
increase the LOG_BUFFER size in my init.ora, at least that is what I get
from RTFM.  One question I have is that does the size of the LOG_BUFFER
parameter have to be a multiple of the DB_BLOCK_SIZE parameter?  I vaguely
remember that it shuold be but have not found anything in TFM to verify
this.

Thanks,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread April Wells


If anyone can... he might be able to.  

-Original Message-
Sent: Tuesday, July 30, 2002 12:34 PM
To: Multiple recipients of list ORACLE-L



I fit that category as well. I talked to him last night he's gonna
try :)

--- [EMAIL PROTECTED] wrote:
  ...hardcore DBAs might never use GUI tools.
 
 I fit that category.  :)
 
 Gaja Vaidyanatha has recently moved to Oracle, and server tools
 are now his responsibility.
 
 I challenged him to turn OEM into something I would actually
 be willing to use.  :)
 
 Jared
 
 
 
 
 
 
 Alexandre Gorbatchev [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/30/2002 07:28 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:Re: Guys:  Is this worth $1,749 for 8 year
 Oracle veteran DBA
 
 
 Oracle's politic is to make us using GUI tools. This is reflected in
 OCP
 exams, so I can conclude that for newbies exams become easier while 
 hardcore
 DBAs might never use GUI tools.
 
 Alexandre
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Tuesday, July 30, 2002 3:03 PM
 
 
 
 
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.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).

begin 666 InterScan_Disclaimer.txt
M5AE(EN9F]R;6%T:6]N(-O;G1A:6YE9!I;B!T:ES(4M;6%I;!IR!S
M=')I8W1L2!C;VYF:61E;G1I86P@86YD(9OB!T:4@:6YT96YD960@=7-E
M(]F('1H92!A91R97-S964@;VYL3L@:70@;6%Y(%LV\@8F4@;5G86QL
M2!PFEV:6QE9V5D(%N9]OB!PFEC92!S96YS:71I=F4N(!.;W1I8V4@
M:7,@:5R96)Y(=I=F5N('1H870@86YY(1IV-L;W-UF4L('5S92!OB!C
M;W!Y:6YG(]F('1H92!I;F9OFUA=EO;B!B2!A;GEO;F4@;W1H97(@=AA
M;B!T:4@:6YT96YD960@F5C:7!I96YT(ES('!R;VAI8FET960@86YD(UA
M2!B92!I;QE9V%L+B @268@6]U(AA=F4@F5C96EV960@=AIR!M97-S
M86=E(EN(5RF]R+!P;5AV4@;F]T:69Y('1H92!S96YD97(@:6UM961I
M871E;'D@8GD@F5T=7)N(4M;6%I;X*D-OG!OF%T92!37-T96US+!)
M;F,N(AAR!T86ME;B!E=F5R2!R96%S;VYA8FQE('!R96-A=71I;VX@=\@
M96YS=7)E('1H870@86YY(%T=%C:UE;G0@=\@=AIR!E+6UA:6P@:%S
M()E96X@W=E'0@9F]R('9IG5S97,N(!792!A8V-E'0@;F\@;EA8FEL
M:71Y(9OB!A;GD@9%M86=E('-UW1A:6YE9!AR!A(')EW5L=!O9B!S
M;V9T=V%R92!V:7)UV5S(%N9!A9'9IV4@6]U(-AG)Y(]U=!Y;W5R
M(]W;B!V:7)UR!C:5C:W,@8F5F;W)E(]P96YI;F@86YY(%T=%C:UE
%;G0N#0H 
end

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Install Oracle 8i on Windows XP?

2002-07-30 Thread Gogala, Mladen


 My assumption is that (everything else equal) *nix on a PC 
 server is a superior technology, more performant, more stable.
 
 Unfortunately one has to know a lot more low level tech stuff 
 to get into the *nix game than is the case with windows, and 
 therefore *nix on a PC will remain to a large extent in the 
 domain of high-skill-set purists and tech elites, not the mass 
 market.

For running a stable production database that a company can rely on,
those  high-skill-set purists and tech elitist a*holes are still needed.
It's not a job for the faint hearted clickety click people. Name of the
game is 99% uptime and it's only for the major league, and that means Unix
and OS/390
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

Make sure that it is in your class path aswell.
Alex [EMAIL PROTECTED] wrote:
just put the zip file on your pathOn Tue, 30 Jul 2002, Daniel Wisser wrote: hi! anyone knows an answer to this: i want to user JDBC thin driver. i can install it from the CD on windows using the manually configured installation. since thin driver is said to be purely java, i want to use it on linux, too. which are the necessary files? are they in $ORACLE_HOME\jdbc\lib\classes111.zip could not find help in metalink thx regards daniel -- Daniel Wisser, Mag. Papyrus Quality Assurance DB Team ISIS Information Systems Alter Wienerweg 12 A-2344 Ma. Enzersdorf, Austria Phone: +43-2236-27551-149 Fax: +43-2236-21081 E-mail: daniel.wisser@!
!
isis-papyrus.com Hotline: +43-2236-27551-111 Visit the ISIS Website: http://www.isis-papyrus.com --- This e-mail is only intended for the recipient and not legally binding. Unauthorised use, publication, reproduction or disclosure of the content of this e-mail is not permitted. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Wisser INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note E!
!
XACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AlexINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do You Yah!
!
oo!?
Yahoo! Health - Feel better, live better

RE: Foxbase to Oracle

2002-07-30 Thread Farrell, Thomas M.Mr. NGB-ARNG


Dennis,

While I hate doing this on an Oracle list, you might want to consider SAP DB
considering your limited budget and requirements. The general product
details are here: http://www.sapdb.org/ and you can request a free CD here:
http://www.sapdb.org/sap_db_cd.htm.

Quite impressive and under-rated if you ask me. ;

Good luck.

Cheers,
Thom
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farrell, Thomas M.Mr. NGB-ARNG
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Gesler, Rich

Title: RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA






I'd like to add another free gui thats kind of neat, DataBee DBATool utility.
You can find it at http://www.databee.com


-Rich



-Original Message-
From: Bill Pass [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA



Being a hardcore SQL*Plus hacker as well I was amazed
to find a freebie on the net that I actually liked and
used. It will work with any JDBC accessible database
(being written itself in java). All you have to do is
load your JDBC driver of choice. It also provides a
panel for entering SQL commands directly (for you
hardcore types).


The name of the tool is DBVisualizer and is available
at the following URL:
http://www.minq.se/products/dbvis/index.html


--- [EMAIL PROTECTED] wrote:
  ...hardcore DBAs might never use GUI tools.
 
 I fit that category. :)
 
 Gaja Vaidyanatha has recently moved to Oracle, and
 server tools
 are now his responsibility.
 
 I challenged him to turn OEM into something I would
 actually
 be willing to use. :)
 
 Jared
 
 
 
 
 
 
 Alexandre Gorbatchev
 [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/30/2002 07:28 AM
 Please respond to ORACLE-L
 
 
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject: Re: Guys: Is this worth
 $1,749 for 8 year Oracle veteran DBA
 
 
 Oracle's politic is to make us using GUI tools. This
 is reflected in OCP
 exams, so I can conclude that for newbies exams
 become easier while 
 hardcore
 DBAs might never use GUI tools.
 
 Alexandre
 - Original Message -
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 Sent: Tuesday, July 30, 2002 3:03 PM
 
 
 
 
 
 -- 
 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).



__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
 INET: [EMAIL PROTECTED]


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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Foxbase to Oracle

2002-07-30 Thread Shaw John-P55297


Visual FoxPro has an upsize wizard that can go directly to Oracle. It would
still be a lot cheaper to keep it in FoxPro over the cost of Oracle.

-Original Message-
Sent: Tuesday, July 30, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L


Dennis:

   Foxbase was originally called 10-base before Fox Systems change the name.
Foxbase was changed to FoxPro and then purchased by Microsoft and called
Microsoft FoxPro, and then Microsoft Visual FoxPro.  I would highly
recommend investigating the MSFT solution.  Sorry guys, but this is a
realistic solution.  Oracle, for eight users, will probably cost too much
for the implementation.

   If you need to convert to Oracle, do the following:
1. Convert to FoxPro
2. Bridge Visual FoxPro to SQLServer and use the Data Transformation
Services (DTS) to migrate the data to Oracle.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Tuesday, July 30, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:Foxbase to Oracle 

Hi All -
We have a small application that was written in Foxbase under DOS. While it
runs fairly well most of the time, the management wants to migrate it to a
windows-based application. We are open to any mainstream application and
database solutions at this point, although our budget is very tight and
this application has only about 8 users max. My question is - does Oracle
provide a good tool for migration from Foxbase? This is a small application
and have only about a dozen tables, my main challenge would be the
application code.
If Oracle turns out to be too expensive, what is the least expensive, least
painful migration path? Another attractive option seems to be Visual
FoxPro, which I know little about.   I want to bounce it off the list first
before we make the choice.

TIA

Dennis Meng
Database Administrator
Focal Communications Corp.

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



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Shaw John-P55297
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Creating sequences on the DUAL table?

2002-07-30 Thread kkennedy


H?  Sequences are not created on the dual table.  Sequences exist as independent 
entities.  Ofttimes, sequence values are selected using the dual table (e.g., select 
seqname.nextval from dual) -- this is a coding choice.  Performance of queries that 
select from the dual table are generally not inviting poor performance (although 
I've seen some postings on how to improve their performance).

If I were you, I would do some more reading up on sequences in the Concepts manual and 
not worry too much about the performance.  Suggest to the developers that they use the 
sequences directly whenever possible rather than selecting from dual as in the 
following:

One method:
select seqname.nextval into local_var from dual;
insert into destination_table (...id_column...) values (...local_var...);

Better method:
insert into destination_table (...id_column...) values (...seqname.nextval...);

And, if the value is needed for other things:
insert into destination_table (...id_column...) values (...seqname.nextval...)
   returning id_column into local_var;

HTH
Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Tuesday, July 30, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: kkennedy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Space Contention and LOG_BUFFER size

2002-07-30 Thread Sherman, Edward


I can't find it in the docs either.

Info at ixora.com suggests setting LOG_BUFFER to a multiple of the log block
size.
http://www.ixora.com.au/tips/tuning/log_buffer_size.htm

This next link explains what a log block size is:
http://www.ixora.com.au/notes/log_block_size.htm

Have fun!
Ed

-Original Message-
Sent: Tuesday, July 30, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L


I am doing some performance monitoring on an 8.1.7 DB on Windoze.  I ran the
following query;

SQL select name,value
  2  from v$sysstat
  3  where name = 'redo log space requests';

NAME  VALUE
 --
redo log space requests  27


If the number of 'redo log space requests' is much over zero then I should
increase the LOG_BUFFER size in my init.ora, at least that is what I get
from RTFM.  One question I have is that does the size of the LOG_BUFFER
parameter have to be a multiple of the DB_BLOCK_SIZE parameter?  I vaguely
remember that it shuold be but have not found anything in TFM to verify
this.

Thanks,

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (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: 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).

RE: Creating sequences on the DUAL table?

2002-07-30 Thread Jacques Kilchoer

Title: RE: Creating sequences on the DUAL table?





answer below


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 
 I have a request from one of our developers to create two new 
 sequences on
 the DUAL table.
 
 This seems like a bad idea to me. I've never had such a 
 request in the
 past. I asked for clarification on why this is needed and I 
 didn't get a
 lot of details yet.
 
 Is this something that is standard operating procedure? My 
 understanding
 that interfacing with the DUAL table is usually inviting poor 
 performance.
 Plus, I don't like to mess around with system tables, in general.
 
 Under what circumstances would it be justified to create 
 sequences on the
 DUAL table? Should I just flat-out refuse this request and 
 if so, why?


You don't mean that the developer wants to add columns to dual?
I think the developer means that you should create two sequences, and he will get the next value by saying
select seq.nextval from dual ;
(example:
SQL create sequence s ;
Séquence créée.
SQL select s.nextval from dual ;


 NEXTVAL
-
 1
end of example)
I don't see a problem with creating a sequence for someone, as long as you make them beg properly first to teach them respect for the importance of the DBA.

RE: Creating sequences on the DUAL table?

2002-07-30 Thread Fink, Dan


Cherie,
My first response is 'WHY?'. Do they mean that they want to create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some information
on the performance implications of DUAL at
http://www.optimaldba.com/internals/oraint_dual.html. 

Dan Fink

-Original Message-
Sent: Tuesday, July 30, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: Fink, Dan
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Creating sequences on the DUAL table?

2002-07-30 Thread Rajesh . Rao



Communication gap and ignorance. The developers proably want to create new
sequences. And they are used to writing queries as Select
sequencename.nextval from dual; So they call it sequences on the dual
table.




   
   
kkennedy 
   
kkennedy@firstTo: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
point.com cc: 
   
Sent by:   Subject: RE: Creating sequences on the 
DUAL table? 
[EMAIL PROTECTED]
   
m  
   
   
   
   
   
July 30, 2002  
   
02:28 PM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




H?  Sequences are not created on the dual table.  Sequences exist as
independent entities.  Ofttimes, sequence values are selected using the
dual table (e.g., select seqname.nextval from dual) -- this is a coding
choice.  Performance of queries that select from the dual table are
generally not inviting poor performance (although I've seen some postings
on how to improve their performance).

If I were you, I would do some more reading up on sequences in the Concepts
manual and not worry too much about the performance.  Suggest to the
developers that they use the sequences directly whenever possible rather
than selecting from dual as in the following:

One method:
select seqname.nextval into local_var from dual;
insert into destination_table (...id_column...) values (...local_var...);

Better method:
insert into destination_table (...id_column...) values
(...seqname.nextval...);

And, if the value is needed for other things:
insert into destination_table (...id_column...) values
(...seqname.nextval...)
   returning id_column into local_var;

HTH
Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Tuesday, July 30, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
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: kkennedy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail

Re: Slightly OT: Chart generation tool for db monitoring scripts

2002-07-30 Thread Ray Stell



Think about how you will roll the trend data up over time.  That is
usually the real killer task.  That is why you got people talking
mrtg, because it is the poor man's solution to that problem.  At least
it is one wheel that has already been invented at the right price.

The snapshots you are making are really not that valuable, but they
are better then a stick in the eye.



On Tue, Jul 30, 2002 at 09:44:49AM -0800, Jamadagni, Rajendra wrote:
 Thanks everyone for your kind help, advise and hints.
 
 I finally got it working with gnuplot.
 
 I had to make some changes to my code, but this is how it works.
 
 1. Every 10 minutes MS task scheduler wakes up and executes a CMD file.
 2. This CMD file 
a. Executes a SQL script that generates a HTML table output on different
 data.
b. Generates an appropriate DATA files for the same.
c. Generates a script for gnuplot to load and generate the plots as gif
 files.
d. Loads gnuplot and generates the gif files.
e. Moved the images to their default directories.
 3. By clocking on the column header (in the HTML report), I open a new
 window and display the plot for that parameter.
 
 Works very nice ... I have a long way to go yet (to cover all statistics),
 but this has been a good start and good learning on GNUPLOT.
 
 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!
 -Original Message-
 Sent: Monday, July 29, 2002 10:10 PM
 To: '[EMAIL PROTECTED]'
 
 
 Sorry, I missed the part about automating it. Please let us know how
 gnuchart works. 
  -Original Message- 
  From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] 
  
  me being lazy (and excel ignorant), wanted to find an 
  automated way out of 
  this. If I am going to be generating 10-15 graphs, doing it 
  every half hour 
  might just be too much for me. 
   

 
 *2
 
 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.
 
 *2
 


-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: Creating sequences on the DUAL table?

2002-07-30 Thread Deshpande, Kirti


Sounds like your developer hangs out with some of our developers! ;) 

I am sorry to say but, I guess the syntax ...from dual could be confusing
to the developer. 
  
Your understanding is just fine. Don't do anything with dual..
 
May be briefly explaining to the developer how sequence number work could
take care of this request. 

Good Luck..  

- Kirti 

-Original Message-
Sent: Tuesday, July 30, 2002 12:54 PM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

-- 
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: 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: DB/APPlication?

Title: RE: DB/APPlication?





Seema,
That's part of the tnsnames.ora which the client needs to connect to the database.
Check out the alert.log file and look for any trace files for the reason the DB crashed.


-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L
Subject: DB/APPlication?



Hi,
I have DB server and 2 web servers.Couple days back DB server was crashed 
and back again.I am wondering few processes like
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) on web server.All the 
applications are working fine.But its strange for me.
Is this some kind of hack?
Thx
-Seema



_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


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


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

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

RE: Creating sequences on the DUAL table?

Title: RE: Creating sequences on the DUAL table?





Sequences are DB objects independent of any tables including dual (not
possible to create a sequence on a table. Sequences are sometimes used
to populate the PK of a table, but the actual sequence and the table are
not structurally related. 


Such as:


SQL create sequence myseq;


Sequence created.


Then, often developers will use the dual table when grabbing the next value from
the sequence.


SQL select myseq.nextval from dual;


better to do this...insert into table1(id,name) values(myseq.nextval,'FName');


Check out the info in the docs on Sequences, maybe the concepts part would be a
good start.


HTH



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 30, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Creating sequences on the DUAL table?




I have a request from one of our developers to create two new sequences on
the DUAL table.


This seems like a bad idea to me. I've never had such a request in the
past. I asked for clarification on why this is needed and I didn't get a
lot of details yet.


Is this something that is standard operating procedure? My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.


Under what circumstances would it be justified to create sequences on the
DUAL table? Should I just flat-out refuse this request and if so, why?


Thanks,


Cherie Machler
Oracle DBA
Gelco Information Network


-- 
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: DBD::Oracle and JDBC Thin

2002-07-30 Thread Jesse, Rich


Oh fdge.  (Only I didn't say fudge).  10-watt bulb:on  After
transcribing all my install problems here, I just realized that I'm supposed
to be using DBD::JDBC instead of DBD::Oracle, aren't I?  Hey, I was working
on this at 1:00 AM this morning...

Never mind...  blush

Thanks, Jared!  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, July 30, 2002 11:11 AM
 To: [EMAIL PROTECTED]
 Cc: Jesse, Rich
 Subject: Re: DBD::Oracle and JDBC Thin
 
 
 Jesse,
 
 Enlighten me as to why DBD::Oracle cares which JDBC driver you use. 
 
 Jared
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Creating sequences on the DUAL table?

2002-07-30 Thread Gogala, Mladen

What are sequence on the table? All I know about sequences
is that they are entities for fas generation of unique numbers
without encountering locks. They are standalone entries without
much connection to any other object. 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, July 30, 2002 1:54 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Creating sequences on the DUAL table?

 I have a request from one of our developers to create two new 
 sequences on
 the DUAL table.

 This seems like a bad idea to me.   I've never had such a 
 request in the
 past.   I asked for clarification on why this is needed and I 
 didn't get a
 lot of details yet.

 Is this something that is standard operating procedure?   My 
 understanding
 that interfacing with the DUAL table is usually inviting poor 
 performance.
 Plus, I don't like to mess around with system tables, in general.

 Under what circumstances would it be justified to create 
 sequences on the
 DUAL table?   Should I just flat-out refuse this request and 
 if so, why?

 Thanks,

 Cherie Machler
 Oracle DBA
 Gelco Information Network

 -- 
 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: Gogala, Mladen
  INET: [EMAIL PROTECTED]

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

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

Re: Creating sequences on the DUAL table?


Cherie,

You don't create sequences on a table, they are objects in and of
themselves.

So you can create the sequences for the developers but I'm
wondering where they got the notion that sequences were created on a
table. And why they want to use DUAL.

Rachel
--- [EMAIL PROTECTED] wrote:
 
 I have a request from one of our developers to create two new
 sequences on
 the DUAL table.
 
 This seems like a bad idea to me.   I've never had such a request in
 the
 past.   I asked for clarification on why this is needed and I didn't
 get a
 lot of details yet.
 
 Is this something that is standard operating procedure?   My
 understanding
 that interfacing with the DUAL table is usually inviting poor
 performance.
 Plus, I don't like to mess around with system tables, in general.
 
 Under what circumstances would it be justified to create sequences on
 the
 DUAL table?   Should I just flat-out refuse this request and if so,
 why?
 
 Thanks,
 
 Cherie Machler
 Oracle DBA
 Gelco Information Network
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.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).

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Jared . Still


No, I use a hex editor and directly write the bits to disk.

Isn't that the way everyone here does it?

Jared





Straub, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 10:25 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: Guys:  Is this worth $1,749 for 8 year Oracle veteran DBA


  
  ...hardcore DBAs might never use GUI tools. 
  
 
 I fit that category.  :) 
 
What about the OUI? Don't you use that? :) 
Dan. 


-- 
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: Creating sequences on the DUAL table?



Dan,

Haven't heard the why yet but I think it may be just a poorly worded
request.   I suspect he wants the sequences created on another table and
just wants to be able to select from dual.   Maybe he never realized that
the sequences were actually created on another table.Maybe he actually
thought that the sequences were created on the DUAL table since he only
ever used them by selecting from DUAL.   Our developers run quite a wide
gamut and I don't work very regularly with this one so it's hard to know
where he's coming from.   Still trying to get him on the phone.

Thanks for this info about performance on DUAL.  I will pass the info on.
Thanks to everyone for getting us all on the same page.   I'm sure that
once I talk this out with him, it'll be straightened out quickly.

Cherie


   
 
Fink, Dan
 
Dan.Fink@mdx.   To: '[EMAIL PROTECTED]' 
[EMAIL PROTECTED],   
com  '[EMAIL PROTECTED]' 
[EMAIL PROTECTED]   
 cc:   
 
07/30/02 12:46   Subject: RE: Creating sequences on the 
DUAL table? 
PM 
 
   
 
   
 




Cherie,
   My first response is 'WHY?'. Do they mean that they want to
create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some
information
on the performance implications of DUAL at
http://www.optimaldba.com/internals/oraint_dual.html.

Dan Fink

-Original Message-
Sent: Tuesday, July 30, 2002 11:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
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: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the ones and zeros   :)



--- [EMAIL PROTECTED] wrote:
 No, I use a hex editor and directly write the bits to disk.
 
 Isn't that the way everyone here does it?
 
 Jared
 
 
 
 
 
 Straub, Dan [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/30/2002 10:25 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Guys:  Is this worth $1,749 for 8 year
 Oracle veteran DBA
 
 
   
   ...hardcore DBAs might never use GUI tools. 
   
  
  I fit that category.  :) 
  
 What about the OUI? Don't you use that? :) 
 Dan. 
 
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.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).

RE: Ids and passwords for application users

Title: RE: Ids and passwords for application users





Peter,


not clear on if the database is going to be used by developers doing
development work or will an application use it and you'll have up to 300
application users?


If it's an application, how about making one account that owns all of the DB
objects, another generic account on top of that which you grant access to execute
packages, select on tables, etc...so that it can access the objects owned by real account
but has limited abilities accept through privileges it's been granted. That is,


app_owner - owns all DB objects
app_user - owns no DB objects, but has restricted access to objects owned by PRODUCTION
tech_support - granted select privileges only
user1/user1, user2/user2, etc... - id's and passwords stored in a table, password encrypted


When a user needs access to the application, they give login/password as user1/user1, but the 
application uses the APP_USER account, to look in the table that stores the logins to see if the
user is valid, and if so, the application loads, if not they're denied access.


HTH



-Original Message-
From: Schauss, Peter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 4:59 PM
To: Multiple recipients of list ORACLE-L
Subject: Ids and passwords for application users



I am in the process of designing a small database which may have
as many as 250 to 300 users. We are reaching a stage where we need
to decide how we will control access to this database. As I see it
we have two options:


1. Provide a single hidden login for the entire application and control
access to the applicaiton itself either by roll your own security or
using the operating system (UNIX) controls.


2. Create ids for the users in Oracle and grant them access
to the necessary tables using roles.


Any opinions or alternate suggestions?


thanks,


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


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

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

causing full table scan

2002-07-30 Thread BigP




Hi list ,
In one of my queries if I use  in where 
clause it is causing full table scan . If i use "IN " ( ) it uses 
index . Actually if it is"  " the it is doing hash join and if"IN" 
then nested loop . 
when i make opt_indx_cost_adj to 5 it starts using 
index again with  condition .
Is there a way i can cause it to use index ( yeah i 
can use hints . ) ? anything else ..
-bp

dbsnmpj access violation

2002-07-30 Thread Seefelt, Beth

Title: dbsnmpj access violation







Hi all,


I've just finished installed 9.2 on W2K. Whenever I submit a job through the OEM console the dbsnmpj.exe process gets an access violation and the job fails to run. When I enable tracing on dbsnmpj, it works fine. Disable tracing and it dies again. Has anyone seen this problem?

Thanks,


Beth

RE: Creating sequences on the DUAL table?



Kevin,

Thanks for the suggestion on select statements.   I will pass them on.   I
think it's just a misunderstanding on his part as to where the sequences
are actually created.   Apparently he only uses them in a select from dual
so he thinks they reside there.

Cherie


   
  
kkennedy 
  
kkennedy@first   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
point.comcc:  
  
Sent by:  Subject: RE: Creating sequences on the 
DUAL table? 
[EMAIL PROTECTED]
  
m  
  
   
  
   
  
07/30/02 01:28 
  
PM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




H?  Sequences are not created on the dual table.  Sequences exist as
independent entities.  Ofttimes, sequence values are selected using the
dual table (e.g., select seqname.nextval from dual) -- this is a coding
choice.  Performance of queries that select from the dual table are
generally not inviting poor performance (although I've seen some postings
on how to improve their performance).

If I were you, I would do some more reading up on sequences in the Concepts
manual and not worry too much about the performance.  Suggest to the
developers that they use the sequences directly whenever possible rather
than selecting from dual as in the following:

One method:
select seqname.nextval into local_var from dual;
insert into destination_table (...id_column...) values (...local_var...);

Better method:
insert into destination_table (...id_column...) values
(...seqname.nextval...);

And, if the value is needed for other things:
insert into destination_table (...id_column...) values
(...seqname.nextval...)
   returning id_column into local_var;

HTH
Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Tuesday, July 30, 2002 10:54 AM
To: Multiple recipients of list ORACLE-L



I have a request from one of our developers to create two new sequences on
the DUAL table.

This seems like a bad idea to me.   I've never had such a request in the
past.   I asked for clarification on why this is needed and I didn't get a
lot of details yet.

Is this something that is standard operating procedure?   My understanding
that interfacing with the DUAL table is usually inviting poor performance.
Plus, I don't like to mess around with system tables, in general.

Under what circumstances would it be justified to create sequences on the
DUAL table?   Should I just flat-out refuse this request and if so, why?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network

--
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: kkennedy
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to:

RE: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-07-30 Thread Mercadante, Thomas F


coding?  ha!  I used to flip switches to load my programs directly into core
memory!  and then I had to read the results from the light console!  up-hill
both-ways in a snow-storm!


-Original Message-
Sent: Tuesday, July 30, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L


Hex editor? geez you youngsters have it soft, in MY day we ran magnets
over the disks to encode the ones and zeros   :)



--- [EMAIL PROTECTED] wrote:
 No, I use a hex editor and directly write the bits to disk.
 
 Isn't that the way everyone here does it?
 
 Jared
 
 
 
 
 
 Straub, Dan [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 07/30/2002 10:25 AM
 Please respond to ORACLE-L
 
  
 To: Multiple recipients of list ORACLE-L
 [EMAIL PROTECTED]
 cc: 
 Subject:RE: Guys:  Is this worth $1,749 for 8 year
 Oracle veteran DBA
 
 
   
   ...hardcore DBAs might never use GUI tools. 
   
  
  I fit that category.  :) 
  
 What about the OUI? Don't you use that? :) 
 Dan. 
 
 
 -- 
 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).


__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: ODBC connection privs in Oracle