date:20020110


Hello Shuan

If I am not mistaken you need to run a configuration program before you can
start using OEM on 8.1.6.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: C.S.Venkata Subramanian [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 6:55 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Re: Management Server
 
 Chk for the username and password. Or else try creating the repository
 after dropping the same.
 
 Venkat 
 --
 
 On Wed, 09 Jan 2002 15:56:26  
  shuan wrote:
 good day, DBA...
 
 i'm now self-learning Oracle 8.1.6 Enterprise Edition.
 using Oracle8.1.6 on Win2000 Advance Server,
 and the Oracle Management Server also in the same machine.
 after i faced the problem of ORA-12638 when attempt to login,
 the Management Server failed to run.(even the Service).
 now the error ORA-12638 is fixed by changing a line in sqlnet.ora.
 yet i still cant start the Management Server Service.
 when i check the Event Viewer, it say,
 
 The service has terminated abnormally.  See the file 
 D:\Oracle\PODB\sysman\log\OMS.log for details. 
 
 and this:
 
 No login credentials were provided.  The service cannot start. 
 
 so, what's wrong with this?
 pls help.
 
 thanks and hav a nice day.
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: C.S.Venkata Subramanian
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

RE: TEMPORARY TABLES

2002-01-10 Thread Pravin Mali


Bruce,

I have a question on this?  How do you create a temp table which
automatically
clears the data after usage.  Because I had faced the same problem.

I insert data into a temp table and I commit it.

I say select * from table Name

I get the data.

I come out of that SQL session and again login in again to the same
database.

I say select * from table Name

I get No data.

What might be the problem?  I could not solve this till date.

Thanks for your advice in advance,



PRAVIN MALI



-Original Message-
Bruce (CALBBAY)
Sent: Thursday, January 10, 2002 2:30 PM
To: Multiple recipients of list ORACLE-L


Peter,

The tables are permanent but the data within them is temporary - the data
life is either until you commit or until you logoff depending upon the
option chosen when you create the table.

This is initially confusing as it is different to how (say) Rdb handles
temporary tables.

Somewhat related, if you look at locks, you will see locks held on these
tables until you either commit (for on commit delete) or until you truncate
the table (for on commit preserve).

HTH,
Bruce Reardon


-Original Message-
Sent: Thursday, 10 January 2002 15:06

Hi

I am working on some development here and have decided to use temporary
tables to do some work as they seemed to be the best way to acheive what I
wanted and the data is only required for the sesion.

I seem to be experiencing a problem where the only way the temporary tables
are removed is by actually dropping them or by  bouncing the database.

I thought that they were supposed to be session specific or program module
specific.

Perhaps I misundestood the docs

I am creating them as follows

v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_cal1 ( part NUMBER,
readings NUMBER) ON COMMIT PRESERVE ROWS';
EXECUTE IMMEDIATE  v_CreateString;
and
v_CreateString := 'CREATE GLOBAL TEMPORARY TABLE t_tmp_cal2 ( part NUMBER)
ON COMMIT DELETE ROWS';
EXECUTE IMMEDIATE v_CreateString;


Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production


I have looked at metalink and found nothing specific to point the way
Any help appreciated
--
=
Peter McLarty   E-mail: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +61 (0)402 094 238
   Facsimile: +61 (0)7 3303 3048
=
A great pleasure in life is doing what people say you cannot do.

   - Walter Bagehot (1826-1877 British Economist)
=
Mincom The People, The Experience, The Vision

=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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

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

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

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

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

RE: reading variables


Hello All

I use TOAD version 7.1.
When I run a select with  (like where id = id) a pop up window ask for the
replacement value.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 2:02 AM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: reading variables
 
  -Original Message- 
  From: Lance Prais [ mailto:[EMAIL PROTECTED]] 
  
  I am using toad. 
  
  If I use the following for to reference a variable in my code: 
  Update Primus_Temp_Dump set owner =(test) where secure_id = Secure; 
   
  I get this compile error: 
  PLS-00103: Encountered the symbol  when expecting one of 
  the following: 
   
  This is how you are supposed to reference variables in a SQL 
  Statement? 
   
  If I do this: 
  Update Primus_Temp_Dump set owner =('test') where secure_id 
  = Secure; 
   
  I do not get the error but it passes test into my query and it fails 
 
 
 What version of TOAD? I have 7.1 on my desktop, and I see the following in
 the help (searching for the word substitution):
 
 Window: Variables 
 This window will come up if you specify parameters in your SQL query, from
 the SQL Edit window, such as: 
 select * from employee where employee_id = :empid 
 -OR- 
 select * from employee where employee_id = empid 
 Once the variables window comes up, select each bound variable, select the
 data type, and enter the desired value.  Click OK to run the resulting SQL
 statement.
 
 Note: Bound parameter substitution is NOT supported in anonymous PL/SQL
 blocks. 
 
 I experimented with the feature and it worked as advertised in the help. 
 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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


Your boss is right.
Oracle dropped support for 8.1.6.

We have the same problem, but I think that I will wait another 2-3 months
and move to 9i.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: David Ehresmann [SMTP:[EMAIL PROTECTED]]
 Sent: Wed, January 09, 2002 6:20 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Upgrade to 8.1.7
 
 My boss wants to upgade from 8.1.6 to 8.1.7 on NT4.0.  Are they any know
 issues that I would have to deal with?
 
 Thanks for your help!
 
 David Ehresmann
 Oracle DBA 8  8i OCP
 MCI Worldcom
 [EMAIL PROTECTED]
 972.656.1015
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: David Ehresmann
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

2002-01-10 Thread Mark Leith


Windows XP Security Hole Lets Attackers 'Plug and Prey'

Microsoft has issued a security patch to fix a vulnerability on its new
Windows XP operating system. Enterprises must act at once to deter malicious
attacks on their networked PCs.




Event
On 20 December 2001, Microsoft, acknowledging a serious vulnerability in
its Universal Plug and Play (UPnP) software, urged Windows users to apply a
security patch to protect their networked PCs from malicious attacks.
Microsoft recommends the patch for all customers of Windows XP. Customers
using Windows 98, 98SE or ME should apply the patch if UPnP service is
running. Windows users can download the patch from Microsoft's Web site at
www.microsoft.com/technet/security/bulletin/MS01-059.asp.

First Take

The 2001 holiday season hasn't been merry for early adopters of Microsoft's
Windows XP. They must cope with two cases of serious security
vulnerabilities - in the Internet Explorer 6 browser (see Gartner FirstTake
FT-15-1348, Patch Security Holes but Demand Better Security From Vendors)
and now with UPnP service - both of which are embedded in Windows XP.

These vulnerabilities rate High Risk on Gartner's Internet Vulnerability
Risk Rating methodology. Gartner predicts that by the end of the first
quarter of 2002, standard hacker attack tools will incorporate these
weaknesses into the rampant hacker scanning that is seen on cable modem and
digital subscriber line Internet access systems.

The UPnP vulnerability validates Gartner's view that Microsoft's Secure
Windows Initiative was limited to its server operating systems. Discovery of
such a serious buffer overflow vulnerability in Windows XP software shows
that Microsoft must significantly increase management attention to security,
and focus on improving its software development and testing processes.

Enterprises considering a move to Windows XP should wait to see if more
security vulnerabilities are found in the operating system (OS) during the
next three to six months. Enterprises actively planning Windows XP migration
should follow Gartner's standard advice for testing application
compatibility with this patch (and subsequent fixes to that patch) in the
new OS image. Enterprises using Windows XP or that have installed UPnP
services on Windows ME-based PCs should block ports 1900 and 5000 on
corporate firewalls (plus personal firewall software on laptops and small or
home office router firewalls) and patch all affected desktops at once.
Enterprises that allow employees to remotely connect using home PCs that run
Windows ME should provide them with instructions to disable UPnP services
and install the patch.

Analytical Sources: John Pescatore, Information Security Strategies, Michael
Silver, End-User Computing, David Smith, Internet Strategies, and Neil
MacDonald, NT Strategies

Need to Know: Reference Material and Recommended Reading

Secure Windows: Oxymoron or on the Horizon? (SPA-14-7346) The Secure
Windows Initiative must change Microsoft's mindset to focus on a long-term
campaign to reduce security vulnerabilities.
By John Pescatore

Internet Vulnerability Risk Rating Methodology (TU-14-9003) Enterprises
should use the Gartner risk rating methodology to quickly rank software
vulnerabilities. By John Pescatore

http://www4.gartner.com/DisplayDocument?doc_cd=103499

HTH

Mark

-Original Message-
Pierce
Sent: 09 January 2002 19:42
To: Multiple recipients of list ORACLE-L


ORACLE-L Digest -- Volume 2002, Number 009
 --

  From: Gogala, Mladen [EMAIL PROTECTED]
  Date: Tue, 8 Jan 2002 13:42:33 -0500
  Subject: RE: Oracle Future???

...

 win XP is allegedly the worst edition ever when it comes to stability
 and security.

According to who?

(no lumping, please, deal with stability and security
separately unless there is an explicit connection).

thanks,
ep

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

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

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

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

Re: Clone a database

2002-01-10 Thread Beatriz Martínez Jiménez


Hello again,
thanks all  that have replied.
I have another question. Is it possible to clone a database just only through
OS operations? For example, is it possible to overwrite the files related
with one database (.dbf, .ctl..) with the one related with the database to
'clone'?
Maybe it sounds crazy...
.
Ruth Gramolini ha escrito:

 Have a look at  None:73974.1 on Metalink.  It give the step for cloning a
 database from backups.

 HTH,
 Ruth
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, January 09, 2002 4:50 AM

 Hello list,
 I new to clone a database for changing between test to production.
 The new database is going to be in a different host.
 I have the copy obtained through the enterprise manager (I suppose it´s
 a cold backup).
 Which are the steps I should follow?
 A lot of thanks

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
   INET: [EMAIL PROTECTED]

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

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
  INET: [EMAIL PROTECTED]

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

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

Sorry, forgot the start. It is :WE8ISO8859P1.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From:   [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 12:00 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: US7ASCII, UTF8, characters sets,
 conversions.aggHH!!!

 Hello Chris

 We are using ISO8859P1 because we need support for Hebrew character set.

 Yechiel Adar, Mehish Computer Services
 [EMAIL PROTECTED]

  -Original Message-
  From:   Grabowy, Chris [SMTP:[EMAIL PROTECTED]]
  Sent:   Wed, January 09, 2002 5:45 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: US7ASCII, UTF8, characters sets,
  conversions.aggHH!!!

  Hey Yechiel,

  Thanks.  And which character set is that?

  Chris

  -Original Message-
  Sent: Wednesday, January 09, 2002 9:15 AM
  To: Multiple recipients of list ORACLE-L

  Hello Chris

  We made a point to have all the components (servers and clients and
 db's)
  in
  the same character sets.

  Yechiel Adar, Mehish Computer Services
  [EMAIL PROTECTED]

   -Original Message-
   From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
   Sent: Wed, January 09, 2002 3:35 PM
   To:   Multiple recipients of list ORACLE-L
   Subject:  Re: US7ASCII, UTF8, characters sets,
   conversions.aggHH!

   When I connected I got:

   OWS-05101: Execution failed due to Oracle error -6550

   Oops!  Maybe they have the wrong character set.

   Grabowy,

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

   @fcg.comcc:

   Sent by: rootSubject: US7ASCII, UTF8,
   characters sets, 

 conversions.aggHH!

   01/08/2002

   04:05 PM

   Please

   respond to

   ORACLE-L

   So we stumbled upon the white paper...

   WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET
   By David F. Pennington, GlaxoSmithKline

   This white paper raises a potential issue that DBAs might need to be
  aware
   of.  Basically, it has to do with certain characters not storing
  correctly
   in the database because of different character sets being used between
  the
   database, client and how the user enters data into the application.

   Has this issue been raised on the list before?

   Basically, were wondering how other DBAs/sites are
 handling/approaching
   this
   issue.

   Many TIA!!

   Chris

   I believe the below link will get you to the white paper on the IOUG
   website.

 http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tec
   h_

   content_phy_Id=5310v_trx=784353
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.com
   --
   Author: Grabowy, Chris
 INET: [EMAIL PROTECTED]

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

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

  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  -- 
  Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: [EMAIL PROTECTED]

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

  To REMOVE yourself

RE: Clone a database

2002-01-10 Thread Martin Kendall


Yes it is quite possible to do just that.

The only thing is that you have to generate a CREATE DATABASE command
from the source DB by ALTER DATABASE BACKUP CONTROLFILE TO TRACE command.

Note the CONTROLFILE does not have a space in it !

You then alter the contents of the Trace file to SET the Database Name to
the new name that you require.  In addition you make any necessary changes
to the file locations that have been generated.

You then have a CREATE DATABASE command that will create the cloned
database.

NB: DO NOT copy the Control files - they will be created as part of the
CREATE DATABASE command.
DO NOT Copy the Online Redo Logs -  they will be created as part of the
CREATE DATABASE command.

Martin - Oracle-Rescue.com

-Original Message-
Martínez Jiménez
Sent: 10 January 2002 11:20
To: Multiple recipients of list ORACLE-L


Hello again,
thanks all  that have replied.
I have another question. Is it possible to clone a database just only
through
OS operations? For example, is it possible to overwrite the files related
with one database (.dbf, .ctl..) with the one related with the database to
'clone'?
Maybe it sounds crazy...
.
Ruth Gramolini ha escrito:

 Have a look at  None:73974.1 on Metalink.  It give the step for cloning a
 database from backups.

 HTH,
 Ruth
 - Original Message -
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, January 09, 2002 4:50 AM

 Hello list,
 I new to clone a database for changing between test to production.
 The new database is going to be in a different host.
 I have the copy obtained through the enterprise manager (I suppose it´s
 a cold backup).
 Which are the steps I should follow?
 A lot of thanks

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
   INET: [EMAIL PROTECTED]

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

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
  INET: [EMAIL PROTECTED]

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

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

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

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

RUNNING .BAT FILE FROM PROCEDURE ?

2002-01-10 Thread Bunyamin K. Karadeniz




OS : WINNT , DB : 8.1.7
I have a java class embedded in database and I am 
calling it with a procedure. 
The procedere executes a bat file . 
In the bat file there 2 copy commands . First of 
them copying a file from a local directory to another local directory. 

Second command copy's a file in a shared directory 
of another computer to another shared directory of that computer. 
BAT file and permissions are all set correctly in 
all directories..(everyone ,full access).Also gave javasyspriv role and other 
privileges to the user .
When I double click on the bat file . Both 
two commands run correctly. 
But When I run the bat file via the procedure . The 
first command runs correctly (local copy command) , but the second one (copying 
a file in a shared directory of another computer to another shared directory of 
that computer) does not run . 

What is the problem ? I gave all permissions but 
still does not work for remote computer shared files.
I tried it on 9i database and it worked 
..(INTERESTING)
Any ideas please ???

Re: Recovery scenario query


O'Neill, Sean wrote:
 
 We perform disk-to-disk offline backups on a nighlty basis.  Database is
 running in archived log mode.  Due to space contraints (don't ask =:-[ ) we
 are currently forced to backup only some of the data files.  The data files
 excluded belong to specific schema owners and are not being updated, or so
 I'm informed =:-0.  I'm trying to get my head around what the recovery
 implications are if some of the data files not backed up have being updated
 and a recovery is required?.  I expect it depends on what the recovery
 scenario is.  So whats worst case scenario and what would my options, if any
 be?.
 
 Oracle 7.3.3, 8.0.5, 8.1.7
 NT4, W2K
 -
 Seán O' Neill
 Organon (Ireland) Ltd.
 [subscribed: digest mode]

Sean,

   I am afraid that if you do not backup ALL of your databases you are
heading for a lot of trouble. Even if datafiles are not updated (and you
seem, quite justifiably, to doubt it) I would be surprised if datafile
header blocks where not updated at one time or another - eg shutdown or
startup (check file dates, it can give a good clue). Which means that
Oracle will flatly refuse to open the database when you try to do it
with a mix of recently backed-up files and the associated archived redo
logs, plus very old 'not updated' datafiles - without the archived redo
logs to fill the gap. You will probably be able to open the database by
dropping the tablespaces for which you only have old data. In other
words, be ready to bid farewell to the data you do not backup (I suggest
you export it ASAP). IMHO, your situation may not be as bad as it may
look according to the books, but you are doing tight-rope dancing with a
safety net full of gaping holes, and even if you manage to avoid the
fatal plunge when you have a problem, it will not be easy and may take
some time before you have a database looking remotely to what it was
before the problem up and running.
-- 
Regards,

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

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

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

RE: Recovery scenario query

2002-01-10 Thread Martin Kendall


Hi,

I would want to ensure that the datafiles being exluded have READ ONLY
Tablespaces
to ensure that they do not change.

This would ensure that in the event of a recovery there will not be an SCN
issue

Martin

-Original Message-
Sean
Sent: 10 January 2002 12:05
To: Multiple recipients of list ORACLE-L


We perform disk-to-disk offline backups on a nighlty basis.  Database is
running in archived log mode.  Due to space contraints (don't ask =:-[ ) we
are currently forced to backup only some of the data files.  The data files
excluded belong to specific schema owners and are not being updated, or so
I'm informed =:-0.  I'm trying to get my head around what the recovery
implications are if some of the data files not backed up have being updated
and a recovery is required?.  I expect it depends on what the recovery
scenario is.  So whats worst case scenario and what would my options, if any
be?.


Oracle 7.3.3, 8.0.5, 8.1.7
NT4, W2K
-
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).

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

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

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

RE: Database jobs still hot

Where is your door?

Ken

 -Original Message-
Sent:   Wednesday, January 09, 2002 7:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Database jobs still hot

Ya, can you send them to my door?

-Original Message-
WILLIAMS
Sent: Wednesday, January 09, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L

To cheer up the listers that are searching for jobs, here is an article that
says database skills are still in the most demand. And, of course, Oracle is
specifically mentioned.

 http://www.cio.com/staffing/edit/010302_hot.html
--
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: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

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

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

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

Ang: RE: Unix - script

2002-01-10 Thread Roland . Skoldblom



So I have to use the ip-addresses? I cant use  the name of the computer, for instance 
hakon5.

Thanks in advance

Roland






Gogala, Mladen [EMAIL PROTECTED]@fatcity.com den 2002-01-09 07:11 PST

Sänd svar till [EMAIL PROTECTED]

Sänt av:  [EMAIL PROTECTED]


Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:

I would suggest using wget, which is built exactly for this purpose.

-Original Message-
Sent: Wednesday, January 09, 2002 3:20 AM
To: Multiple recipients of list ORACLE-L


Roland,

Try this by setting up environment variables at the top of your script:

SERVER1= 10.10.10.10
USER1= 'xxx'
PWD1= 'xxx'
SERVER2= 10.10.10.20
USER1= 'yyy'
PWD2= ''

Then have this:

ftp -i -n  EOF
open $SERVER1
user $USER1  $PWD1
cd scripts
get file
close
EOF

You can then have a section like the one below if you want to copy to a
different server
other than the one you are running this script from:

ftp -i -n  EOF
open $SERVER2
user $USER2  $PWD2
cd scripts
put file
close
EOF

Both of these can be included in the one shell script.

Hope that helps.
Kev.


'In Windows no one can hear you scream'
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com





-Original Message-
Sent: 09 January 2002 07:16
To: Multiple recipients of list ORACLE-L


Hallo,

I would like to have an example of a unix script, which does the following:

copy some files from directory /prod/sas/data  located at hardy.(which is
a computer)
to the other database hakon. Is it possible to do this. Please help me
quick.


Thanks in advance

Roland S

--
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: Thomas, Kevin
  INET: [EMAIL PROTECTED]

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

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

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

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









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

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

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

Re: Dig it - killer freeware editor

2002-01-10 Thread bill thater


[EMAIL PROTECTED] wrote:

Ya, you are right, some unix having no GUI for the first installation like
FreeBSD 4.
vi is the only one availabe there for you to configure your xwindows or KDE.

it also helps if you have a lot of the commands hardwired into your 
fingers.;-)

and one of the first things i do on any box i can is install vim.;-)


-- 
--
Bill Shrek Thater  ORACLE DBA
[EMAIL PROTECTED]

You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.

Disclaimer:  Any errors in spelling, tact, or fact are transmission errors.






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

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

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

nls_date_format problem in sqlldr

2002-01-10 Thread Ruth Gramolini


Good morning,

We are having a problem load a file containing dates in MON DD  format
into a database having and nls_date_format=MMDD.  Is there a way to do
an alter session command in the control file or the parameter file to that
we can load this data?

We have had the production database down for 4 days with various problems
and this is the last straw.

Thanks in advance,
Ruth

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

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

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

Re: RUNNING .BAT FILE FROM PROCEDURE ?

2002-01-10 Thread Igor Neyman




The fact, that it works under 9i, is really 
interesting. I didn't have chance to play with it yet.
As for 8.1.7, Oracle runs under NT 'SYSTEM' account 
(just look at startup options of Oracle service in 
ControlPanel/Services).
Hence, your .bat file, called from Oracle,is 
executed under 'SYSTEM' account, which does not have privileges to access 
'mapped' network drives, and it is not possible to grant those privileges to 
'SYSTEM' account.
What you can try, is to create NT account, grant 
itappropriate privileges to access network drive, and change startup 
options for Oracle service to'Logon' as this new account, 
should work.

Again, it's interesting, what's been changed in 
9i. Check the account used to run Oracle service.

Igor Neyman, OCP DBA[EMAIL PROTECTED] 


  - Original Message - 
  From: 
  Bunyamin K. Karadeniz 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Thursday, January 10, 2002 7:40 
  AM
  Subject: RUNNING .BAT FILE FROM PROCEDURE 
  ?
  
  OS : WINNT , DB : 8.1.7
  I have a java class embedded in database and I am 
  calling it with a procedure. 
  The procedere executes a bat file . 
  In the bat file there 2 copy commands . First of 
  them copying a file from a local directory to another local directory. 
  
  Second command copy's a file in a shared 
  directory of another computer to another shared directory of that computer. 
  
  BAT file and permissions are all set correctly in 
  all directories..(everyone ,full access).Also gave javasyspriv role and other 
  privileges to the user .
  When I double click on the bat file . Both 
  two commands run correctly. 
  But When I run the bat file via the procedure . 
  The first command runs correctly (local copy command) , but the second one 
  (copying a file in a shared directory of another computer to another shared 
  directory of that computer) does not run . 
  
  What is the problem ? I gave all permissions but 
  still does not work for remote computer shared files.
  I tried it on 9i database and it worked 
  ..(INTERESTING)
  Any ideas please ???

Re: Dig it - killer freeware editor

2002-01-10 Thread Jan Pruner


and mc.

:-)

On Thu 10. January 2002 13:50, you wrote:
 [EMAIL PROTECTED] wrote:
 Ya, you are right, some unix having no GUI for the first installation like
 FreeBSD 4.
 vi is the only one availabe there for you to configure your xwindows or
  KDE.

 it also helps if you have a lot of the commands hardwired into your
 fingers.;-)

 and one of the first things i do on any box i can is install vim.;-)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

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

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

RE: Database Comparison


I've had some problems with the Change Manager.

For some databases it doesn't see any of the objects that would fall in
the last few item categories in the navigator pane on the left - including
tablespaces.

There is a bug with the JVM, sometimes the Oracle Java tool colours go
beserk (fluorescent) and in one occation the window positioning was
completely off.  I use 1024x768 desktops on some NT servers.  Sometimes the
whole graphic column that shows checkmarks or crosses in comparison reports
appears in the upper left corner of the screen instead of where it should
be.  These are probably all related to the same known bug for the JVM
display functions.

The reports also are extensive, I don't know if it is possible to tell
Change Manager to only put in reports just the information you want.
Internet browsers are not happy with HTML files that are megabytes in size,
they take a long time to load.

The Change Manager is faster if run on the console holding the repository
than from a remote client. I recommend running it from the OEM repository
console if at all possible, to avoid network trips as the Change Manager
stores information into the repository.  There will be enough networking
going on with it comparing two remote systems.

Would anyone care to share tips on how to use Change Manager appropriately?
Did you find any problems with Change Manager, are there any differences it
did not catch?

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:   Thursday, January 10, 2002 1:20 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Database Comparison

 Srini,
Use the change manager that comes with Oracle Enterprise manager. The
initial set-up is little bit difficult. But once u r through, then it is an
handy tool.
Venkat
--
--
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: Management Server

2002-01-10 Thread orantdba




That is correct, you will need to run the enterprise Manager Configuration
Assistant. It will configure your oms to work with a OEM repository.

When you run the oms for the first time you will use username sysman password
oem_temp it
will prompt you to change this value.

John

[EMAIL PROTECTED] wrote:

  Hello ShuanIf I am not mistaken you need to run a configuration program before you canstart using OEM on 8.1.6.Yechiel Adar, Mehish Computer Services[EMAIL PROTECTED]
  
-Original Message-From: C.S.Venkata Subramanian [SMTP:[EMAIL PROTECTED]]Sent: Thu, January 10, 2002 6:55 AMTo:   Multiple recipients of list ORACLE-LSubject:  Re: Management ServerChk for the username and password. Or else try creating the repositoryafter dropping the same.Venkat --On Wed, 09 Jan 2002 15:56:26   shuan wrote:

  good day, DBA...i'm now self-learning Oracle 8.1.6 Enterprise Edition.using Oracle8.1.6 on Win2000 Advance Server,and the Oracle Management Server also in the same machine.after i faced the problem of ORA-12638 when attempt to login,the Management Server failed to run.(even the Service).now the error ORA-12638 is fixed by changing a line in sqlnet.ora.yet i still cant start the Management Server Service.when i check the "Event Viewer", it say,   The service has terminated abnormally.  See the fileD:\Oracle\PODB\sysman\log\OMS.log for details. and this:   No login credentials were provided.  The service cannot start. so, what's wrong with this?pls help.thanks and hav a nice day.
  
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: C.S.Venkata Subramanian  INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051San Diego, California-- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: nls_date_format problem in sqlldr


Ruth Gramolini wrote:
 
 Good morning,
 
 We are having a problem load a file containing dates in MON DD  format
 into a database having and nls_date_format=MMDD.  Is there a way to do
 an alter session command in the control file or the parameter file to that
 we can load this data?
 
 We have had the production database down for 4 days with various problems
 and this is the last straw.
 
 Thanks in advance,
 Ruth
 

You can specify in the SQL*LOADER control file the date mask with date
columns. I know that syntactic schemas are not extremely explicit, but
have a harder look at field descriptions in the manual.
-- 
Regards,

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

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

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

RE: Database Comparison


There is a site on the 'net somewhere that inventories who is using what OS
and Web server for major Web sites, but I can't remember what the URL for
that is.

It only reflects what they are using to serve pages to the Web, though.

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:   Thursday, January 10, 2002 1:20 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Database Comparison

 Srini,
Use the change manager that comes with Oracle Enterprise manager. The
initial set-up is little bit difficult. But once u r through, then it is an
handy tool.
Venkat
--

On Wed, 09 Jan 2002 11:00:36  
 Paul Baumgartel wrote:
There's a very good script available at http://www.dbspecialists.com.

--- [EMAIL PROTECTED] wrote:
 Hi:
 
 I need to compare my Production database with  QA database.  I would
 like to
 generate a report that shows differences in schemas across these two
 databases(tables, indexes, views, object definition,  etc..).  I
 would
 appreciate it if you could forward me a script that would accomplish
 this or
 any websites where I can find one.
 
 Thanks
 
 Srini Rajendran.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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



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

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

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

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

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

RE: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!

2002-01-10 Thread Grabowy, Chris


Ok, so to get a better feel for what's going on, is everyone still using
US7ASCII??  Have sites started switching over to UTF8??  Have there been any
conversion problems??  Do the websites(like Amazon, Yahoo, BN, etc) that
have an Oracle backend enforce UTF8 as a standard, so that they can store
any type of character that a user enters???

-Original Message-
Sent: Tuesday, January 08, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


So we stumbled upon the white paper...

WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET 
By David F. Pennington, GlaxoSmithKline

This white paper raises a potential issue that DBAs might need to be aware
of.  Basically, it has to do with certain characters not storing correctly
in the database because of different character sets being used between the
database, client and how the user enters data into the application.

Has this issue been raised on the list before?

Basically, were wondering how other DBAs/sites are handling/approaching this
issue.

Many TIA!!

Chris

I believe the below link will get you to the white paper on the IOUG
website.

http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tech_
content_phy_Id=5310v_trx=784353
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

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

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

Unix - copyscript

2002-01-10 Thread Roland . Skoldblom


Hallo,

Can anyone tell me why I get this errormessage when I run this script. I know that 
there  are files in the directory
prod/sas/data/bilbo/indata

Files that exists in that directory are  for example customer.txt, cars.txt. I want to 
copy those files. But it doesnt sem to find them.
The error message at the bottom when i run the script says the following line:

.txt*: No such file or directory: No such file or directory.

What is wrong? How can I correct this script?


#!/sbin/bash -x
dato=`date +%m%d%H%M`
fromdir=/prod/sas/data/bilbo/indata
todir=/d31/appl/konto/tmp
logg=/d31/appl/konto/tmp/filecopy$$.log
ftpadr=10.100.10.145
ftpuser=bboadmin
ftppw=bboadmin
fileprefix=.txt

echo `basename $0` startet: `date` | tee -a $logg
#-
echo Overforer filer: `date` | tee -a $logg
(echo open $ftpadr
echo user $ftpuser $ftppw
echo cd $fromdir
echo lcd $todir
echo mget $fileprefix*
#echo mdelete $fileprefix*
echo bye) | ftp -n -i

Thanks in advance

Roland



-- 
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: US7ASCII, UTF8, characters sets, conversions.....agghhhhHH!!!

2002-01-10 Thread Cherie_Machler



Chris,

We have started using UTF8 on our new databases as a standard.

All of our old, existing databases use US7ASCII.

We need to convert a couple of existing databases such as our
200Gig data warehouse from US7ASCII to UTF8.

I am concerned about conversion problems.   I asked a few weeks
ago if anyone had successfully converted from US7ASCII to UTF8
but got no response.

I've searched on Metalink for the topic and didn't find much.   If you
get any responses, could you forward them on to me or post to the
list.

Thanks much,

Cherie Machler
Oracle DBA
Gelco Information Network


   
   
Grabowy,  
   
Chris   To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]  
cgrabowy@fcg.   cc:   
   
com Subject: RE: US7ASCII, UTF8, characters 
sets,
Sent by:  conversions.aggHH!!! 
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
01/10/02 07:35 
   
AM 
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Ok, so to get a better feel for what's going on, is everyone still using
US7ASCII??  Have sites started switching over to UTF8??  Have there been
any
conversion problems??  Do the websites(like Amazon, Yahoo, BN, etc) that
have an Oracle backend enforce UTF8 as a standard, so that they can store
any type of character that a user enters???

-Original Message-
Sent: Tuesday, January 08, 2002 4:05 PM
To: Multiple recipients of list ORACLE-L


So we stumbled upon the white paper...

WHY WE ARE MOVING OUR DATABASES TO THE UTF8 CHARACTER SET
By David F. Pennington, GlaxoSmithKline

This white paper raises a potential issue that DBAs might need to be aware
of.  Basically, it has to do with certain characters not storing correctly
in the database because of different character sets being used between the
database, client and how the user enters data into the application.

Has this issue been raised on the list before?

Basically, were wondering how other DBAs/sites are handling/approaching
this
issue.

Many TIA!!

Chris

I believe the below link will get you to the white paper on the IOUG
website.

http://www.ioug.org/ioug_s/REPOSITORY_PKG.REPOSITORY_BUILD_VIEW_FORM?v_tech_

content_phy_Id=5310v_trx=784353
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
  INET: [EMAIL PROTECTED]

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

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

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

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

2002-01-10 Thread dgoulet


Anyone care to comment on the following, IMHO it's about time:

---
Introducing two new levels of Oracle Certified Professional (OCP) Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of Professional
Certification. And in an October survey from *crn.com on Certification, 58% of
respondents said that it is very difficult to find qualified Oracle Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of professional
achievement to DBAs (and soon to be released to Application and Java Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.html
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001

-
-- 
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: Unix - copyscript

2002-01-10 Thread April Wells


It is not the file prefix it is the file suffix.  Try moving your '*' to
before the variable name (this is keeping your variable name... which I
would change to reflect what it really is.  Your script thinks it is
.txtcustomer .txtcars

echo mget *$fileprefix
#echo mdelete *$fileprefix

I think if you try that it will fix your problem...

April Wells
Corporate Systems
Amarillo Texas


 -Original Message-
Sent:   Thursday, January 10, 2002 7:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Unix - copyscript

Hallo,

Can anyone tell me why I get this errormessage when I run this script. I
know that there  are files in the directory
prod/sas/data/bilbo/indata

Files that exists in that directory are  for example customer.txt, cars.txt.
I want to copy those files. But it doesnt sem to find them.
The error message at the bottom when i run the script says the following
line:

.txt*: No such file or directory: No such file or directory.

What is wrong? How can I correct this script?


#!/sbin/bash -x
dato=`date +%m%d%H%M`
fromdir=/prod/sas/data/bilbo/indata
todir=/d31/appl/konto/tmp
logg=/d31/appl/konto/tmp/filecopy$$.log
ftpadr=10.100.10.145
ftpuser=bboadmin
ftppw=bboadmin
fileprefix=.txt

echo `basename $0` startet: `date` | tee -a $logg
#-
echo Overforer filer: `date` | tee -a $logg
(echo open $ftpadr
echo user $ftpuser $ftppw
echo cd $fromdir
echo lcd $todir
echo mget $fileprefix*
#echo mdelete $fileprefix*
echo bye) | ftp -n -i

Thanks in advance

Roland



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

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: Unix - copyscript


Change mget $fileprefix* to mget *$fileprefix 

- Kirti 

-Original Message-
Sent: Thursday, January 10, 2002 7:50 AM
To: Multiple recipients of list ORACLE-L


Hallo,

Can anyone tell me why I get this errormessage when I run this script. I
know that there  are files in the directory
prod/sas/data/bilbo/indata

Files that exists in that directory are  for example customer.txt, cars.txt.
I want to copy those files. But it doesnt sem to find them.
The error message at the bottom when i run the script says the following
line:

.txt*: No such file or directory: No such file or directory.

What is wrong? How can I correct this script?


#!/sbin/bash -x
dato=`date +%m%d%H%M`
fromdir=/prod/sas/data/bilbo/indata
todir=/d31/appl/konto/tmp
logg=/d31/appl/konto/tmp/filecopy$$.log
ftpadr=10.100.10.145
ftpuser=bboadmin
ftppw=bboadmin
fileprefix=.txt

echo `basename $0` startet: `date` | tee -a $logg
#-
echo Overforer filer: `date` | tee -a $logg
(echo open $ftpadr
echo user $ftpuser $ftppw
echo cd $fromdir
echo lcd $todir
echo mget $fileprefix*
#echo mdelete $fileprefix*
echo bye) | ftp -n -i

Thanks in advance

Roland



-- 
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: Database Comparison

2002-01-10 Thread Jamadagni, Rajendra


www.netcraft.com

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: Thursday, January 10, 2002 8:40 AM
To: Multiple recipients of list ORACLE-L


There is a site on the 'net somewhere that inventories who is using what OS
and Web server for major Web sites, but I can't remember what the URL for
that is.

It only reflects what they are using to serve pages to the Web, though.



*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: SQL Loader Question


My guess is : No. 
Can you run a quick test and let us know ?? 
Thanks.
- Kirti 

-Original Message-
Sent: Wednesday, January 09, 2002 3:45 PM
To: Multiple recipients of list ORACLE-L


8.1.7 on W2000
I would like to know if there is a way to group more than one parfile into
one file?  I would like to run just one file verses a number of parfiles.

Thanks,
Ken Janusz, CPIM 
Database Conversion Lead 
Sufficient Systems, Inc. 
Minneapolis, MN

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

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

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


Ruth:

Are you using a delimited flat file via SQL Loader?  Would the to_date
function do the trick?

My 0.03 Euro's worth,

Ken

 -Original Message-
Sent:   Thursday, January 10, 2002 7:25 AM
To: Multiple recipients of list ORACLE-L
Subject:nls_date_format problem in sqlldr

Good morning,

We are having a problem load a file containing dates in MON DD  format
into a database having and nls_date_format=MMDD.  Is there a way to do
an alter session command in the control file or the parameter file to that
we can load this data?

We have had the production database down for 4 days with various problems
and this is the last straw.

Thanks in advance,
Ruth

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

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

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

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

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


Hello Ruth

The answer is not to change the nls_date_format but to tell the loader the
format you use for your date.
We use the following in our ctl files:
  
xx_xx_TAR_NECHONUT date(8) 'MMDD',   

maybe you can use: my_date date(8) 'MMMDD' .
(I did not check if it works).

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Ruth Gramolini [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 3:25 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  nls_date_format problem in sqlldr
 
 Good morning,
 
 We are having a problem load a file containing dates in MON DD  format
 into a database having and nls_date_format=MMDD.  Is there a way to do
 an alter session command in the control file or the parameter file to that
 we can load this data?
 
 We have had the production database down for 4 days with various problems
 and this is the last straw.
 
 Thanks in advance,
 Ruth
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ruth Gramolini
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

2002-01-10 Thread Robert Pegram


Sean,

First of all, datafiles actually belong to a
tablespace - not a schema.

1.  You could place the tablespace into read-only
mode, take a backup of the tablespaces datafile(s),
then no additional backups are required for those
datafile(s) (and you are assured that no one updates
the data).

2.  In general, to recover from media failure, you
would have to restore the datafile from some backup,
and apply all the archived redo logs since the backup.

HTH
Rob Pegram
Oracle DBA

--- O'Neill, Sean [EMAIL PROTECTED] wrote:
 We perform disk-to-disk offline backups on a nighlty
 basis.  Database is
 running in archived log mode.  Due to space
 contraints (don't ask =:-[ ) we
 are currently forced to backup only some of the data
 files.  The data files
 excluded belong to specific schema owners and are
 not being updated, or so
 I'm informed =:-0.  I'm trying to get my head around
 what the recovery
 implications are if some of the data files not
 backed up have being updated
 and a recovery is required?.  I expect it depends on
 what the recovery
 scenario is.  So whats worst case scenario and what
 would my options, if any
 be?.  
 
 
 Oracle 7.3.3, 8.0.5, 8.1.7 
 NT4, W2K 
 -
 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).


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robert Pegram
  INET: [EMAIL PROTECTED]

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

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

2002-01-10 Thread Robertson Lee - lerobe


Put your * before the fileprefix variable.

Regards

Lee 


-Original Message-
Sent: 10 January 2002 13:50
To: Multiple recipients of list ORACLE-L


Hallo,

Can anyone tell me why I get this errormessage when I run this script. I
know that there  are files in the directory
prod/sas/data/bilbo/indata

Files that exists in that directory are  for example customer.txt, cars.txt.
I want to copy those files. But it doesnt sem to find them.
The error message at the bottom when i run the script says the following
line:

.txt*: No such file or directory: No such file or directory.

What is wrong? How can I correct this script?


#!/sbin/bash -x
dato=`date +%m%d%H%M`
fromdir=/prod/sas/data/bilbo/indata
todir=/d31/appl/konto/tmp
logg=/d31/appl/konto/tmp/filecopy$$.log
ftpadr=10.100.10.145
ftpuser=bboadmin
ftppw=bboadmin
fileprefix=.txt

echo `basename $0` startet: `date` | tee -a $logg
#-
echo Overforer filer: `date` | tee -a $logg
(echo open $ftpadr
echo user $ftpuser $ftppw
echo cd $fromdir
echo lcd $todir
echo mget $fileprefix*
#echo mdelete $fileprefix*
echo bye) | ftp -n -i

Thanks in advance

Roland



-- 
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 information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please 
re-send this communication to the sender and delete the 
original message or any copy of it from your computer
system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robertson Lee - lerobe
  INET: [EMAIL PROTECTED]

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

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

2002-01-10 Thread Ron Rogers




Ruth,
If the source file is being loaded with SQL LOADER that you 
can format the date load in the controlfile. We get our dates in the MMDD 
format and load in to the database default by defining the source 
data:

SaleDate TERMINATED BY "," 
"TO_DATE(:SALEDATE,'MMDD')", 
...Good Luck.
Ron
ROR mª¿ªm [EMAIL PROTECTED] 01/10/02 08:25AM 
Good morning,We are having a problem load a file 
containing dates in MON DD  formatinto a database having and 
nls_date_format=MMDD. Is there a way to doan alter session command 
in the control file or the parameter file to thatwe can load this 
data?We have had the production database down for 4 days with various 
problemsand this is the last straw.Thanks in 
advance,Ruth-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ruth 
Gramolini INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

RE: The OCP bar is being raised

2002-01-10 Thread Karniotis, Stephen


To be honest, I think this is actually lowering the bar.  Oracle finally
realized that the OCP has no value to an organization unless you induce the
word Master.  This has been taken from their former certification, the
Oracle Master's Certification, which was worthless and only showed that you
had taken all of the courses within a specific track.

Oracle is simply acting like any other software vendor and locating new ways
of generating revenue. 

Thank You

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


 -Original Message-
Sent:   Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject:The OCP bar is being raised

Anyone care to comment on the following, IMHO it's about time:


---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of
Professional
Certification. And in an October survey from *crn.com on Certification, 58%
of
respondents said that it is very difficult to find qualified Oracle
Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of
professional
achievement to DBAs (and soon to be released to Application and Java
Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum
exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htm
l
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001


-
-- 
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: 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: The OCP bar is being raised

Title: RE: The OCP bar is being raised





I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we would first have to get the OCA. Whether or not we need the entry level cert we have to have it. Then, and only then, can we take the OCP. Then and only then, can we take the OCM and that is after we take these REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams or Jared Still, has to spend money in a class that they could probably teach from memory before they can get certification and that is after getting 2 other certs that have no value to them. Call me a cynic, but to me, this is nothing but a money grab.

From the website:


--To become an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role. Typically, 
--two exams are required; the first one can be taken via the Internet, 
--while subsequent exams must be taken in a proctored environment. By 
--completing your Oracle Associate, you are half-way toward achieving the
-- Oracle Certified Professional credential. 



--To become an Oracle Certified Professional, you must pass all required exams 
--in your selected job role, including those at the Associate level. 



--To become an Oracle Certified Master, you must first be an Oracle 
--Certified Professional. Additionally, achieving your OCM credential 
--requires attending two advanced level Oracle University courses from 
--the list shown on this page as well as passing the OCM Practicum exam. 



--Chris



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: The OCP bar is being raised



Anyone care to comment on the following, IMHO it's about time:

---
Introducing two new levels of Oracle Certified Professional (OCP) Achievement 

A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of Professional
Certification. And in an October survey from *crn.com on Certification, 58% of
respondents said that it is very difficult to find qualified Oracle Certified
Professionals-Database Administrators. 


To meet this demand, we have recently introduced two new levels of professional
achievement to DBAs (and soon to be released to Application and Java Developers
worldwide): 


The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.html
for more information


IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001

-
-- 
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: Database jobs still hot

2002-01-10 Thread Kimberly Smith


Portland, OR

-Original Message-
Sent: Thursday, January 10, 2002 5:00 AM
To: Multiple recipients of list ORACLE-L


Where is your door?

Ken

 -Original Message-
Sent:   Wednesday, January 09, 2002 7:40 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Database jobs still hot

Ya, can you send them to my door?

-Original Message-
WILLIAMS
Sent: Wednesday, January 09, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L


To cheer up the listers that are searching for jobs, here is an article that
says database skills are still in the most demand. And, of course, Oracle is
specifically mentioned.

 http://www.cio.com/staffing/edit/010302_hot.html
--
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: Kimberly Smith
  INET: [EMAIL PROTECTED]

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

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

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

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

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

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

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

Re: RUNNING .BAT FILE FROM PROCEDURE ?

2002-01-10 Thread Bunyamin K. Karadeniz




Thanks Igor ,
I am trying it but when I want to log on to db , it 
gives 
ORA-12500: TNS:listener failed to start a dedicated 
server process 
error.
Will I do another change ? For example the startup 
account of TNSLISTENER Service .?
Bunyamin

  - Original Message - 
  From: 
  Igor 
  Neyman 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, January 10, 2002 3:30 
  PM
  Subject: Re: RUNNING .BAT FILE FROM 
  PROCEDURE ?
  
  The fact, that it works under 9i, is really 
  interesting. I didn't have chance to play with it yet.
  As for 8.1.7, Oracle runs under NT 'SYSTEM' 
  account (just look at startup options of Oracle service in 
  ControlPanel/Services).
  Hence, your .bat file, called from 
  Oracle,is executed under 'SYSTEM' account, which does not have 
  privileges to access 'mapped' network drives, and it is not possible to grant 
  those privileges to 'SYSTEM' account.
  What you can try, is to create NT account, grant 
  itappropriate privileges to access network drive, and change startup 
  options for Oracle service to'Logon' as this new account, 
  should work.
  
  Again, it's interesting, what's been changed in 
  9i. Check the account used to run Oracle service.
  
  Igor Neyman, OCP DBA[EMAIL PROTECTED] 
  
  
- Original Message - 
From: 
Bunyamin K. Karadeniz 
To: Multiple 
recipients of list ORACLE-L 
Sent: Thursday, January 10, 2002 7:40 
AM
Subject: RUNNING .BAT FILE FROM 
PROCEDURE ?

OS : WINNT , DB : 8.1.7
I have a java class embedded in database and I 
am calling it with a procedure. 
The procedere executes a bat file . 

In the bat file there 2 copy commands . First 
of them copying a file from a local directory to another local 
directory. 
Second command copy's a file in a shared 
directory of another computer to another shared directory of that computer. 

BAT file and permissions are all set correctly 
in all directories..(everyone ,full access).Also gave javasyspriv role and 
other privileges to the user .
When I double click on the bat file . 
Both two commands run correctly. 
But When I run the bat file via the procedure . 
The first command runs correctly (local copy command) , but the second one 
(copying a file in a shared directory of another computer to another shared 
directory of that computer) does not run . 

What is the problem ? I gave all permissions 
but still does not work for remote computer shared files.
I tried it on 9i database and it worked 
..(INTERESTING)
Any ideas please ???

RE: The OCP bar is being raised

2002-01-10 Thread SARKAR, Samir

Title: RE: The OCP bar is being raised

Chris,

Am not clear on this.
To b an OCP, we require to pass 5 examsright ?? So, if we get
the
OCP Associate after passing
2 exams, we need to pass only another 3 exams for getting
OCP
or do we have to go through
all the 5 exams all over again ??

I think we can directly sit
for the OCP tests though instead of going through the OCA. But to get
the
OCP Master, we will
necessarily have to b a OCP.

Do correct me if I am wrong
though.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon
Team SchlumbergerSema
Email :
[EMAIL PROTECTED]
[EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418
Ext. 76217 Fax
: +44 (0) 115 - 957
6018

-Original Message-From: Bowes, Chris
[mailto:[EMAIL PROTECTED]]Sent: 10 January 2002
15:05To: Multiple recipients of list ORACLE-LSubject:
RE: The OCP bar is being raised
I'd say the cost is being raised. Look at the
requirements for each. You can't just take the OCM exam. No we
would first have to get the OCA. Whether or not we need the entry level
cert we have to have it. Then, and only then, can we take the OCP.
Then and only then, can we take the OCM and that is after we take these
REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams
or Jared Still, has to spend money in a class that they could probably teach
from memory before they can get certification and that is after getting 2
other certs that have no value to them. Call me a cynic, but to me, this
is nothing but a money grab.
From the website:
--To become an Oracle Associate, you must pass the exams
required -- for the Oracle Associate level of your
selected job role. Typically, --two exams are
required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By
--completing your Oracle Associate, you are half-way
toward achieving the -- Oracle Certified Professional
credential.
--To become an Oracle Certified Professional, you must pass
all required exams --in your selected job role,
including those at the Associate level.
--To become an Oracle Certified Master, you must first be an
Oracle --Certified Professional. Additionally,
achieving your OCM credential --requires attending two
advanced level Oracle University courses from --the
list shown on this page as well as passing the OCM Practicum exam.

--Chris
-Original Message- From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:16 AM To:
Multiple recipients of list ORACLE-L Subject: The OCP
bar is being raised
Anyone care to comment on the following, IMHO it's about
time:
--- Introducing two new levels of
Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education and
Training Services quoted database professionals and
network engineers as the fastest-growing areas of Professional
Certification. And in an October survey from *crn.com on
Certification, 58% of respondents said that it is very
difficult to find qualified Oracle Certified Professionals-Database Administrators.
To meet this demand, we have recently introduced two new
levels of professional achievement to DBAs (and soon
to be released to Application and Java Developers worldwide):
The Oracle Certified Associate (OCA) -- an entry-level Oracle
qualification requiring successful completion of two
exams. The Oracle Certified Master (OCM) -- an
advanced qualification for Oracle Certified
Professionals (OCP), that requires students to take a practicum exam
on-sitee at an Oracle University education center.
Visit http://www.oracle.com/education/certification/news/index.html?certlevels.html
for more information
IDC, IT Education and Training, Sept 2001 crn.com, Certification: What's Hot, What's Not, Oct 2001

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

___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions

Re: The OCP bar is being raised

2002-01-10 Thread Ron Rogers




Dick,
I see value in the addition of the two levels of 
certification. 
With the addition of the OCA certification it will allow 
"junior" DBA's to start on the read to successful certification. Learning and 
understanding the basics of SQL and ADMIN should be promoted, displayed, and 
rewarded. It is akin to the Associates Degree that is usually acquired before 
the B.S. and continuing education towards the Ph.D.
The addition of the OCM is a way to promote yourself as 
a seasoned professional that has taken the time to learn the ins and outs of the 
database and can be a valuable asset to a company.
The new levels of certification will allow the employer to 
search for employees with at least a minimum certification 
requirement.
I know that there are a LOT of professionals working as 
DBA's, and participate on this list, that are very good and OCM qualified but 
have not decided to become an OCP. Their reasons are their own and I look 
proudly upon their achievements and ethics.

On the other hand... With the ability to take 2 tests and get 
an OCA , 5 test to get an OCP, and take 2 additional courses plus a practicum 
exam and you are a OCM. The requirements list that you take the courses at the 
Oracle training centers. Sounds like a way to keep the Oracle training centers 
alive. The one in Atlanta is a ghost town compared to 5 years ago.
Thanks for the update info.
Ron
ROR mª¿ªm
 [EMAIL PROTECTED] 01/10/02 09:15AM 
Anyone care to comment on the following, IMHO it's about 
time:---Introducing 
two new levels of Oracle Certified Professional (OCP) Achievement A 
recent *IDC report on IT Education and Training Services quoted 
databaseprofessionals and network engineers as the fastest-growing areas of 
ProfessionalCertification. And in an October survey from *crn.com on 
Certification, 58% ofrespondents said that it is very difficult to find 
qualified Oracle CertifiedProfessionals-Database Administrators. To 
meet this demand, we have recently introduced two new levels of 
professionalachievement to DBAs (and soon to be released to Application and 
Java Developersworldwide): The Oracle Certified Associate (OCA) -- 
an entry-level Oracle qualificationrequiring successful completion of two 
exams.The Oracle Certified Master (OCM) -- an advanced qualification for 
OracleCertified Professionals (OCP), that requires students to take a 
practicum examon-sitee at an Oracle University education center. 
Visithttp://www.oracle.com/education/certification/news/index.html?certlevels.htmlfor 
more informationIDC, IT Education and Training, Sept 2001crn.com, 
Certification: What's Hot, What's Not, Oct 
2001--- 
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-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).

Analyze vs. DBMS_STATS

2002-01-10 Thread Jay Hostetter


Now that I finally have all of our databases upgraded to 8.1.7 I am taking some time 
to look at our method of gathering statistics for CBO.  It looks like I should move 
towards using DBMS_STATS to gather statistics, but I may want to use ANALYZE if I need 
to gather stats on individual columns (according to Note:166215.1).  I was just 
curious to know if most DBAs are using  DBMS_STATS instead of ANALYZE.  For the most 
part, I had been using DBMS_UTILITY.ANALYZE_SCHEMA.  I'll probably start using 
DBMS_STATS.GATHER_SCHEMA_STATS unless somebody convinces me otherwise.  Any comments 
or things that I should watch out for?

Thanks,


Jay Hostetter
Oracle DBA
D.  E. Communications
Ephrata, PA  USA

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

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

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

RE: The OCP bar is being raised


They offered the Oracle Master certification before, I was told from Oracle
Canada two years ago that to earn it one had to have taken courses
specifically from Oracle.

I asked because they offered NT Core Technologies, and I had taken the same
course from a Microsoft-certified training center.

I met all the requirements to move on toward the Masters certificate, but
when they realized I had taken courses on NT from Microsoft, they told me I
could never earn the Masters Certificate.

I was rather annoyed with Oracle Education for that, why would NT Core
Technologies from Microsoft be different from NT Core Technologies from
Oracle Education - the course titles were identical.  It seemed to me that
this Masters certificate was just a carrot to encourage people to purchase
more instructor-led training.

They had similar tracks for Solaris and HP-UX, I wonder if their attitude
was the same re. courses (with identical names) offered by Sun or HP
certified training centers.

I think this is a good move, to split up the OCP certifications - of course
that may mean more people will sign up to write exams.

Rather than using the OCP exams to verify whether you remember how to use
the latest features from a particular release, I wish the OCP would rather
concentrate on practical database administration issues - in some cases the
new features don't work properly, or are not used in real-world
environments.  They should include questions about new features, but not put
so much emphasis on them.

Questions about securing databases come to mind, it would be nice to have
more of those in the OCP exams.
Questions covering the most common reasons for databases failures
Questions covering the most common generic TARs that people log
Etc.

Just my $0.02.  I can't help it...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Thursday, January 10, 2002 10:16 AM
To: Multiple recipients of list ORACLE-L
Subject:The OCP bar is being raised

Anyone care to comment on the following, IMHO it's about time:


---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of
Professional
Certification. And in an October survey from *crn.com on Certification, 58%
of
respondents said that it is very difficult to find qualified Oracle
Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of
professional
achievement to DBAs (and soon to be released to Application and Java
Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum
exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htm
l
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001


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

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

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

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

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

RE: The OCP bar is being raised

Title: Message



From 
the website:
--To become an Oracle Certified Professional, you must pass all 
required exams --in your selected job role, including 
those at the Associate level. 

The 
way I read that, you have to have the OCA exams before you can get the 
OCP. So if you take and pass the OCP, until you pay for and pass the OCA, 
you cannot get the OCP certificat and recognitionand you cannot even take 
the OCM.

--Chris


  
  -Original Message-From: SARKAR, Samir 
  [mailto:[EMAIL PROTECTED]] Sent: Thursday, 
  January 10, 2002 10:28 AMTo: '[EMAIL PROTECTED]'Cc: 
  '[EMAIL PROTECTED]'Subject: RE: The OCP bar is being 
  raised
  Chris,
  
  Am not clear on 
  this. To b an OCP, we require to pass 5 examsright ?? So, if we get 
  the
  OCP Associate after 
  passing 2 exams, we need to pass only another 3 exams for getting 
  OCP
  or do we have to go 
  through all the 5 exams all over again ??
  
  I think we can directly 
  sit for the OCP tests though instead of going through the OCA. But to get 
  the
  OCP Master, we will 
  necessarily have to b a OCP.
  
  Do correct me if I am 
  wrong though.
  
  Regards,
  Samir
  
  Samir Sarkar 
  Oracle DBA - Lennon 
  Team SchlumbergerSema Email : 
  [EMAIL PROTECTED]  
  [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 
  EPABX : +44 (0) 115 - 957 
  6418 Ext. 76217 Fax : +44 (0) 115 - 957 
  6018 
  
  
-Original Message-From: Bowes, Chris 
[mailto:[EMAIL PROTECTED]]Sent: 10 January 2002 
15:05To: Multiple recipients of list ORACLE-LSubject: 
RE: The OCP bar is being raised
I'd say the cost is being raised. Look at the 
requirements for each. You can't just take the OCM exam. No we 
would first have to get the OCA. Whether or not we need the entry 
level cert we have to have it. Then, and only then, can we take the 
OCP. Then and only then, can we take the OCM and that is after we take 
these REQUIRED classes from Oracle Ed. So someone the caliber of Steve 
Adams or Jared Still, has to spend money in a class that they could probably 
teach from memory before they can get certification and that is after 
getting 2 other certs that have no value to them. Call me a cynic, but 
to me, this is nothing but a money grab.
From the website: 
--To become an Oracle Associate, you must pass the exams 
required -- for the Oracle Associate level of your 
selected job role. Typically, --two exams are 
required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By 
--completing your Oracle Associate, you are half-way 
toward achieving the -- Oracle Certified 
Professional credential. 
--To become an Oracle Certified Professional, you must pass 
all required exams --in your selected job role, 
including those at the Associate level. 
--To become an Oracle Certified Master, you must first be an 
Oracle --Certified Professional. Additionally, 
achieving your OCM credential --requires attending 
two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum 
exam. 
--Chris 
-Original Message- From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:16 AM To: 
Multiple recipients of list ORACLE-L Subject: The 
OCP bar is being raised 
Anyone care to comment on the following, IMHO it's about 
time:  
--- Introducing two new levels of 
Oracle Certified Professional (OCP) Achievement  A recent *IDC report on IT Education 
and Training Services quoted database professionals 
and network engineers as the fastest-growing areas of Professional 
Certification. And in an October survey from *crn.com on 
Certification, 58% of respondents said that it is 
very difficult to find qualified Oracle Certified Professionals-Database Administrators. 
To meet this demand, we have recently introduced two new 
levels of professional achievement to DBAs (and soon 
to be released to Application and Java Developers worldwide): 
The Oracle Certified Associate (OCA) -- an entry-level 
Oracle qualification requiring successful completion 
of two exams. The Oracle Certified Master (OCM) -- 
an advanced qualification for Oracle Certified 
Professionals (OCP), that requires students to take a practicum exam 
on-sitee at an Oracle University education center. 
Visit http://www.oracle.com/education/certification/news/index.html?certlevels.html 
for more information 
IDC, IT Education and Training, Sept 2001 crn.com, Certification: What's Hot, What's Not, Oct 2001 
 
- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Re: nls_date_format problem in sqlldr

2002-01-10 Thread Ruth Gramolini


We got around this issue but if anyone knows whether this is possible I
would like to know for future reference.

Thanks anyway,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 8:25 AM


 Good morning,

 We are having a problem load a file containing dates in MON DD  format
 into a database having and nls_date_format=MMDD.  Is there a way to do
 an alter session command in the control file or the parameter file to that
 we can load this data?

 We have had the production database down for 4 days with various problems
 and this is the last straw.

 Thanks in advance,
 Ruth

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

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

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

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

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

RE: The OCP bar is being raised

2002-01-10 Thread Khedr, Waleed


OCP, OCA, OCM, OCD = ?

How can you bring money?

-Original Message-
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L


Anyone care to comment on the following, IMHO it's about time:


---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of
Professional
Certification. And in an October survey from *crn.com on Certification, 58%
of
respondents said that it is very difficult to find qualified Oracle
Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of
professional
achievement to DBAs (and soon to be released to Application and Java
Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum
exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htm
l
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001


-
-- 
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: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

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

RE: The OCP bar is being raised

2002-01-10 Thread SARKAR, Samir

Title: Message

H...so all we have
to do is appear for 2 exams and get OCA and then appear for
the
remaining 3 exams and
upgrade ourselves to OCP...or do we need to take all the 5 exams

all over again
??

Samir

-Original Message-From: Bowes, Chris
[mailto:[EMAIL PROTECTED]]Sent: 10 January 2002
15:35To: SARKAR, Samir; '[EMAIL PROTECTED]'Cc: Bowes,
ChrisSubject: RE: The OCP bar is being raised
From
the website:
--To become an Oracle Certified Professional, you must pass
all required exams --in your selected job role,
including those at the Associate level.

The
way I read that, you have to have the OCA exams before you can get the
OCP. So if you take and pass the OCP, until you pay for and pass the
OCA, you cannot get the OCP certificat and recognitionand you cannot
even take the OCM.

--Chris

-Original Message-From: SARKAR, Samir
[mailto:[EMAIL PROTECTED]] Sent: Thursday,
January 10, 2002 10:28 AMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: The OCP bar is being
raised
Chris,

Am not clear on
this. To b an OCP, we require to pass 5 examsright ?? So, if we get
the
OCP Associate after
passing 2 exams, we need to pass only another 3 exams for getting
OCP
or do we have to go
through all the 5 exams all over again ??

I think we can directly
sit for the OCP tests though instead of going through the OCA. But to get
the
OCP Master, we will
necessarily have to b a OCP.

Do correct me if I am
wrong though.

Regards,
Samir

-Original Message-From: Bowes, Chris
[mailto:[EMAIL PROTECTED]]Sent: 10 January 2002
15:05To: Multiple recipients of list
ORACLE-LSubject: RE: The OCP bar is being
raised
I'd say the cost is being raised. Look at the
requirements for each. You can't just take the OCM exam. No we
would first have to get the OCA. Whether or not we need the entry
level cert we have to have it. Then, and only then, can we take the
OCP. Then and only then, can we take the OCM and that is after we
take these REQUIRED classes from Oracle Ed. So someone the caliber
of Steve Adams or Jared Still, has to spend money in a class that they
could probably teach from memory before they can get certification and
that is after getting 2 other certs that have no value to them. Call
me a cynic, but to me, this is nothing but a money grab.
From the website:
--To become an Oracle Associate, you must pass the exams
required -- for the Oracle Associate level of your
selected job role. Typically, --two exams are
required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment.
By --completing your Oracle Associate, you are
half-way toward achieving the -- Oracle Certified
Professional credential.
--To become an Oracle Certified Professional, you must
pass all required exams --in your selected job
role, including those at the Associate level.
--To become an Oracle Certified Master, you must first be
an Oracle --Certified Professional. Additionally,
achieving your OCM credential --requires attending
two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum
exam.
--Chris
-Original Message- From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L Subject: The OCP bar is being raised
Anyone care to comment on the following, IMHO it's about
time:
--- Introducing two new levels of
Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education
and Training Services quoted database professionals and network engineers as the fastest-growing areas of
Professional Certification. And in an October
survey from *crn.com on Certification, 58% of respondents said that it is very difficult to find qualified Oracle
Certified Professionals-Database Administrators.

To meet this demand, we have recently introduced two new
levels of

Re:RE: The OCP bar is being raised

2002-01-10 Thread dgoulet


Well, A number of folks have weighed in on this matter  I appreciate each point
of view, especially those about Oracle Education just trying to justify itself. 
What IMHO is good in this is the praticum exam.  It lends a true degree of
certified hands on professionalism to the certificate, not just theory.


Dick Goulet
Reply Separator
Author: Boivin; Patrice J [EMAIL PROTECTED]
Date:   1/10/2002 7:25 AM

They offered the Oracle Master certification before, I was told from Oracle
Canada two years ago that to earn it one had to have taken courses
specifically from Oracle.

I asked because they offered NT Core Technologies, and I had taken the same
course from a Microsoft-certified training center.

I met all the requirements to move on toward the Masters certificate, but
when they realized I had taken courses on NT from Microsoft, they told me I
could never earn the Masters Certificate.

I was rather annoyed with Oracle Education for that, why would NT Core
Technologies from Microsoft be different from NT Core Technologies from
Oracle Education - the course titles were identical.  It seemed to me that
this Masters certificate was just a carrot to encourage people to purchase
more instructor-led training.

They had similar tracks for Solaris and HP-UX, I wonder if their attitude
was the same re. courses (with identical names) offered by Sun or HP
certified training centers.

I think this is a good move, to split up the OCP certifications - of course
that may mean more people will sign up to write exams.

Rather than using the OCP exams to verify whether you remember how to use
the latest features from a particular release, I wish the OCP would rather
concentrate on practical database administration issues - in some cases the
new features don't work properly, or are not used in real-world
environments.  They should include questions about new features, but not put
so much emphasis on them.

Questions about securing databases come to mind, it would be nice to have
more of those in the OCP exams.
Questions covering the most common reasons for databases failures
Questions covering the most common generic TARs that people log
Etc.

Just my $0.02.  I can't help it...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Thursday, January 10, 2002 10:16 AM
To: Multiple recipients of list ORACLE-L

Anyone care to comment on the following, IMHO it's about time:


---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of
Professional
Certification. And in an October survey from *crn.com on Certification, 58%
of
respondents said that it is very difficult to find qualified Oracle
Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of
professional
achievement to DBAs (and soon to be released to Application and Java
Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum
exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htm
l
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001


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

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

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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you

RE: The OCP bar is being raised


Of course, those of us who already have the OCP and want to be called a 
'master'
just need to take the 2 required courses and then the OCM exam.

When looking at the details, they just split the previous 5 exam OCP into 
two tiers,
a 2 exam OCA, and a 2 exam OCP which has the OCA as a prerequisite.

The Oracle Master was always available, but without a test -- it just
required taking ILT courses. They just added a practicum exam to
make the OCM cert.

I can see your point about this being a 'money grab', but the only new item
here is the OCM practicum exam -- everything else existed for 8 and 8i.

-Joe

At 07:05 AM 1/10/02 -0800, you wrote:

I'd say the cost is being raised.  Look at the requirements for each.  You 
can't just take the OCM exam.  No we would first have to get the 
OCA.  Whether or not we need the entry level cert we have to have 
it.  Then, and only then, can we take the OCP.  Then and only then, can we 
take the OCM and that is after we take these REQUIRED classes from Oracle 
Ed.  So someone the caliber of Steve Adams or Jared Still, has to spend 
money in a class that they could probably teach from memory before they 
can get certification and that is after getting 2 other certs that have no 
value to them.  Call me a cynic, but to me, this is nothing but a money grab.

 From the website:

--To become an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role. Typically,
--two exams are required; the first one can be taken via the Internet,
--while subsequent exams must be taken in a proctored environment. By
--completing your Oracle Associate, you are half-way toward achieving the
-- Oracle Certified Professional credential.

--To become an Oracle Certified Professional, you must pass all required 
exams
--in your selected job role, including those at the Associate level.

--To become an Oracle Certified Master, you must first be an Oracle
--Certified Professional. Additionally, achieving your OCM credential
--requires attending two advanced level Oracle University courses from
--the list shown on this page as well as passing the OCM Practicum exam.

--Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: The OCP bar is being raised

Anyone care to comment on the following, IMHO it's about time:
 

---
Introducing two new levels of Oracle Certified Professional (OCP) Achievement

A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of 
Professional
Certification. And in an October survey from *crn.com on Certification, 
58% of
respondents said that it is very difficult to find qualified Oracle Certified
Professionals-Database Administrators.

To meet this demand, we have recently introduced two new levels of 
professional
achievement to DBAs (and soon to be released to Application and Java 
Developers
worldwide):

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum 
exam
on-sitee at an Oracle University education center.
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htmlhttp://www.oracle.com/education/certification/news/index.html?certlevels.html
 

for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001
 

-
--
Please see the official ORACLE-L FAQ: 
http://www.orafaq.comhttp://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: Joe Raube
  INET: [EMAIL PROTECTED]

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a

SQL for top 100 values

2002-01-10 Thread Deen Dayal


hi SQL wizards,

Can any body help me with the tjis SQL. I need a SQL records with top 100 values of a 
table ( not rownum  101 ).

Thanks
Deen


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

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

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

BUG? Inserting BLOB or CLOB values when table and field names are created with quotes

2002-01-10 Thread daniel szabo


Hello, i don't know if it's a bug, but probably, yes.
The case is the following:

We're using Oracle server 8.1.6, running on MS Windows 2000, and Oracle
OLEDB Provider version 8.1.7.02 on the client side.
We're tried to use ADO 2.6 sp1 to create ADO Command objects to insert data
values to BLOB or CLOB fields.

The cases were the following:

1. If you create the table and field names with quotes (tablename,
FieldName, etc), then you cannot insert BLOB or CLOB values larger than
4000 bytes (error is: Invalid Column Name). Data which is smaller or equal
then 4000 bytes is simply OK.

2. If you create the table and field names without quotes (create table
blobtest (id number, bdata blob);), then all names are capitalised to UPPER
CASE, AND YOU ARE ABLE TO INSERT DATA normally (large as you want).

I don't know, if it's a bug inside the Oracle, or what.

Any suggestions?

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

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

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

RE: The OCP bar is being raised


Some correction.. Please... 

 and only showed that you had taken all of the courses within a
specific track.
and only showed that you had paid for all the courses within a specific
track and were present for 1st and the last day of the courses.

(
 1st Day :  to make sure your name was spelled correctly. 
 Last Day:  to get your Certificate/Diploma and Instructor's signature.
)

- Kirti

-Original Message-
Sent: Thursday, January 10, 2002 9:05 AM
To: Multiple recipients of list ORACLE-L


To be honest, I think this is actually lowering the bar.  Oracle finally
realized that the OCP has no value to an organization unless you induce the
word Master.  This has been taken from their former certification, the
Oracle Master's Certification, which was worthless and only showed that you
had taken all of the courses within a specific track.

Oracle is simply acting like any other software vendor and locating new ways
of generating revenue. 

Thank You

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


 -Original Message-
Sent:   Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject:The OCP bar is being raised

Anyone care to comment on the following, IMHO it's about time:


---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of
Professional
Certification. And in an October survey from *crn.com on Certification, 58%
of
respondents said that it is very difficult to find qualified Oracle
Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of
professional
achievement to DBAs (and soon to be released to Application and Java
Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum
exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htm
l
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001


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

-- 
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: Analyze vs. DBMS_STATS

2002-01-10 Thread Toepke, Kevin M


I would highly recommend that you move to DBMS_STATS if you are running at
least 8.1.6.3 -- especially if you are estimating statistics. 

The reason is that DBMS_STATS generates more and better statistics than
analyze. I've seen queries go from hours to minutes just by changing from
ANALYZE to DBMS_STATS...

There are a couple situations where you don't want to use DBMS_STATS -- when
you are using partitioned function-based indexes. DBMS_STATS doesn't seem to
do right. Just another issue with function-based indexes that is supposed to
be fixed in 9.0.2.

Caver

-Original Message-
Sent: Thursday, January 10, 2002 10:31 AM
To: Multiple recipients of list ORACLE-L


Now that I finally have all of our databases upgraded to 8.1.7 I am taking
some time to look at our method of gathering statistics for CBO.  It looks
like I should move towards using DBMS_STATS to gather statistics, but I may
want to use ANALYZE if I need to gather stats on individual columns
(according to Note:166215.1).  I was just curious to know if most DBAs are
using  DBMS_STATS instead of ANALYZE.  For the most part, I had been using
DBMS_UTILITY.ANALYZE_SCHEMA.  I'll probably start using
DBMS_STATS.GATHER_SCHEMA_STATS unless somebody convinces me otherwise.  Any
comments or things that I should watch out for?

Thanks,


Jay Hostetter
Oracle DBA
D.  E. Communications
Ephrata, PA  USA

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

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

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

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

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

RE: The OCP bar is being raised

2002-01-10 Thread Richard Ji


Oh yeah, that's absolutly the idea behind it.  For Oracle to grab more money.
Personally I never gave a crap about certification.  We don't need an entity like
Oracle or MS to tell us how much we know.  We learn stuff because we love to
not because of the certificates.  Yes, I do know the benefits of having a certificate
but I think the companies are taken it too far with all those You must ... blah blah
requirements.

Why don't they just say You must pay $10,000 and we will give you a certificate.

Richard Ji

 [EMAIL PROTECTED] 01/10/02 10:05AM 
I'd say the cost is being raised.  Look at the requirements for each.  You
can't just take the OCM exam.  No we would first have to get the OCA.
Whether or not we need the entry level cert we have to have it.  Then, and
only then, can we take the OCP.  Then and only then, can we take the OCM and
that is after we take these REQUIRED classes from Oracle Ed.  So someone the
caliber of Steve Adams or Jared Still, has to spend money in a class that
they could probably teach from memory before they can get certification and
that is after getting 2 other certs that have no value to them.  Call me a
cynic, but to me, this is nothing but a money grab.

From the website:

--To become an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role. Typically, 
--two exams are required; the first one can be taken via the Internet, 
--while subsequent exams must be taken in a proctored environment. By 
--completing your Oracle Associate, you are half-way toward achieving the
-- Oracle Certified Professional credential. 


--To become an Oracle Certified Professional, you must pass all required
exams 
--in your selected job role, including those at the Associate level. 


--To become an Oracle Certified Master, you must first be an Oracle 
--Certified Professional. Additionally, achieving your OCM credential 
--requires attending two advanced level Oracle University courses from 
--the list shown on this page as well as passing the OCM Practicum exam. 


--Chris


-Original Message-
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L


Anyone care to comment on the following, IMHO it's about time:


---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 
 
A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of
Professional
Certification. And in an October survey from *crn.com on Certification, 58%
of
respondents said that it is very difficult to find qualified Oracle
Certified
Professionals-Database Administrators. 

To meet this demand, we have recently introduced two new levels of
professional
achievement to DBAs (and soon to be released to Application and Java
Developers
worldwide): 

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum
exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htm 
l
for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001


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

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

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

RE: The OCP bar is being raised

Title: RE: The OCP bar is being raised








ENRON



-Original
Message-
From: orantdba
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002
9:36 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: The OCP bar is being
raised



Hmmm,

Imagine that, a publicly traded company that it trying to make money, I
am shocked
dismayed, I don't believe I will be able to sleep tonight. 

Chris, could you provide me with the list of companies that are not
trying to make money?
I want to make sure that I don't go to work for them, or learn their products.

John :-)

[EMAIL PROTECTED] wrote:



I'd say the
cost is being raised. Look at the requirements for each. You can't
just take the OCM exam. No we would first have to get the OCA.
Whether or not we need the entry level cert we have to have it. Then, and
only then, can we take the OCP. Then and only then, can we take the OCM
and that is after we take these REQUIRED classes from Oracle Ed. So
someone the caliber of Steve Adams or Jared Still, has to spend money in a
class that they could probably teach from memory before they can get
certification and that is after getting 2 other certs that have no value to
them. Call me a cynic, but to me, this is nothing but a money grab.

From the
website:

--To become
an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role.
Typically, 
--two exams are required; the first one can be taken via the Internet,

--while subsequent exams must be taken in a proctored environment.
By 
--completing your Oracle Associate, you are half-way toward
achieving the
-- Oracle Certified Professional credential. 



--To become
an Oracle Certified Professional, you must pass all required exams 
--in your selected job role, including those at the Associate
level. 



--To become
an Oracle Certified Master, you must first be an Oracle 
--Certified Professional. Additionally, achieving your OCM
credential 
--requires attending two advanced level Oracle University courses
from 
--the list shown on this page as well as passing the OCM Practicum
exam. 



--Chris



-Original
Message-
From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ] 
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: The OCP bar is being raised



Anyone care
to comment on the following, IMHO it's about time:

---
Introducing two new levels of Oracle Certified Professional (OCP)
Achievement 

A recent *IDC report on IT Education and Training Services quoted
database
professionals and network engineers as the fastest-growing areas
of Professional
Certification. And in an October survey from *crn.com on
Certification, 58% of
respondents said that it is very difficult to find qualified
Oracle Certified
Professionals-Database Administrators. 

To meet this
demand, we have recently introduced two new levels of professional
achievement to DBAs (and soon to be released to Application and
Java Developers
worldwide): 

The Oracle
Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for
Oracle
Certified Professionals (OCP), that requires students to take a
practicum exam
on-sitee at an Oracle University education center. 
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.html

for more information

IDC, IT
Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001

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

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

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

RE: The OCP bar is being raised


If you already have the 8i OCP, there is a single upgrade exam to
become a 9i OCP.

I'm studying for it now.

-Joe

At 07:40 AM 1/10/02 -0800, you wrote:
H...so all we have to do is appear for 2 exams and get OCA and 
then appear for the
remaining 3 exams and upgrade ourselves to OCP...or do we need to take 
all the 5 exams
all over again ??

Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-Original Message-
From: Bowes, Chris [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 15:35
To: SARKAR, Samir; '[EMAIL PROTECTED]'
Cc: Bowes, Chris
Subject: RE: The OCP bar is being raised

 From the website:

--To become an Oracle Certified Professional, you must pass all required 
exams
--in your selected job role, including those at the Associate level.

The way I read that, you have to have the OCA exams before you can get the 
OCP.  So if you take and pass the OCP, until you pay for and pass the OCA, 
you cannot get the OCP certificat and recognition and you cannot even take 
the OCM.

--Chris

-Original Message-
From: SARKAR, Samir [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 10:28 AM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: The OCP bar is being raised

Chris,

Am not clear on  this. To b an OCP, we require to pass 5 examsright ?? 
So, if we get the
OCP Associate after passing 2 exams, we need to pass only another 3 exams 
for getting OCP
or do we have to go through all the 5 exams all over again ??

I think we can directly sit for the OCP tests though instead of going 
through the OCA. But to get the
OCP Master, we will necessarily have to b a OCP.

Do correct me if I am wrong though.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email :  [EMAIL PROTECTED]
 [EMAIL PROTECTED]
Phone : +44 (0) 115 - 95 76217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-Original Message-
From: Bowes, Chris [mailto:[EMAIL PROTECTED]]
Sent: 10 January 2002 15:05
To: Multiple recipients of list ORACLE-L
Subject: RE: The OCP bar is being raised

I'd say the cost is being raised.  Look at the requirements for each.  You 
can't just take the OCM exam.  No we would first have to get the 
OCA.  Whether or not we need the entry level cert we have to have 
it.  Then, and only then, can we take the OCP.  Then and only then, can we 
take the OCM and that is after we take these REQUIRED classes from Oracle 
Ed.  So someone the caliber of Steve Adams or Jared Still, has to spend 
money in a class that they could probably teach from memory before they 
can get certification and that is after getting 2 other certs that have no 
value to them.  Call me a cynic, but to me, this is nothing but a money grab.
 From the website:

--To become an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role. Typically,
--two exams are required; the first one can be taken via the Internet,
--while subsequent exams must be taken in a proctored environment. By
--completing your Oracle Associate, you are half-way toward achieving the
-- Oracle Certified Professional credential.
--To become an Oracle Certified Professional, you must pass all required 
exams
--in your selected job role, including those at the Associate level.
--To become an Oracle Certified Master, you must first be an Oracle
--Certified Professional. Additionally, achieving your OCM credential
--requires attending two advanced level Oracle University courses from
--the list shown on this page as well as passing the OCM Practicum exam.
--Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: The OCP bar is being raised

Anyone care to comment on the following, IMHO it's about time:
 

---
Introducing two new levels of Oracle Certified Professional (OCP) 
Achievement

A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of 
Professional
Certification. And in an October survey from *crn.com on Certification, 
58% of
respondents said that it is very difficult to find qualified Oracle 
Certified
Professionals-Database Administrators.
To meet this demand, we have recently introduced two new levels of 
professional
achievement to DBAs (and soon to be released to Application and Java 
Developers
worldwide):
The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that

RE: The OCP bar is being raised

2002-01-10 Thread Kimberly Smith

Title: RE: The OCP bar is being raised

Actually, looks like to me that they simply revised
their Masters program. Its exactly
the
same requirements except they now added an exam at the end. Not to
many
folks
were going after the Master level except for the actual Oracle
employees.

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent:
Thursday, January 10, 2002 7:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: The OCP bar is being
raised
I'd say the cost is being raised. Look at the
requirements for each. You can't just take the OCM exam. No we
would first have to get the OCA. Whether or not we need the entry level
cert we have to have it. Then, and only then, can we take the OCP.
Then and only then, can we take the OCM and that is after we take these
REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams
or Jared Still, has to spend money in a class that they could probably teach
from memory before they can get certification and that is after getting 2
other certs that have no value to them. Call me a cynic, but to me, this
is nothing but a money grab.
From the website:
--To become an Oracle Associate, you must pass the exams
required -- for the Oracle Associate level of your
selected job role. Typically, --two exams are
required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By
--completing your Oracle Associate, you are half-way
toward achieving the -- Oracle Certified Professional
credential.
--To become an Oracle Certified Professional, you must pass
all required exams --in your selected job role,
including those at the Associate level.
--To become an Oracle Certified Master, you must first be an
Oracle --Certified Professional. Additionally,
achieving your OCM credential --requires attending two
advanced level Oracle University courses from --the
list shown on this page as well as passing the OCM Practicum exam.

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

Re: The OCP bar is being raised

2002-01-10 Thread orantdba

Title: Message



Hi all,

The oca exams are the same exams you would take on the way to being an OCP
under the current program. The only difference is along the way you can
get a designation of OCA. Not unlike Microsofts MCP.

John

[EMAIL PROTECTED] wrote:

  
  
  
>From  the website:
  --To become an Oracle Certified Professional, you must
pass all  required exams 
  --in your selected job role, including  those at the Associate
level. 
  
  
  
The  way I read that, you have to have the OCA exams before you can get the
 OCP. So if you take and pass the OCP, until you pay for and pass the OCA,
 you cannot get the OCP certificat and recognitionand you cannot even take
 the OCM.
  
  
--Chris
  
  

-Original Message-
From: SARKAR, Samir[mailto:[EMAIL PROTECTED]]

Sent: Thursday,January 10, 2002 10:28 AM
To: '[EMAIL PROTECTED]'
Cc:'[EMAIL PROTECTED]'
Subject: RE: The OCP bar is beingraised


Chris,

Am not clear
onthis. To b an OCP, we require to pass 5 examsright ?? So, if we
getthe
OCP Associate
afterpassing 2 exams, we need to pass only another 3 exams for getting
   OCP
or do we have
to gothrough all the 5 exams all over again ??

I think we can
directlysit for the OCP tests though instead of going through the OCA.
But to getthe
OCP Master,
we willnecessarily have to b a OCP.

Do correct me
if I amwrong though.

Regards,
Samir

Samir Sarkar
Oracle DBA - Lennon
   Team
Schlumberger
Sema
Email :[EMAIL PROTECTED]
[EMAIL PROTECTED]

Phone : +44 (0) 115
- 95 76217
EPABX : +44 (0) 115
- 9576418 Ext. 76217
Fax : +44 (0) 115
- 9576018

  
-Original Message-
  From: Bowes, Chris  [mailto:[EMAIL PROTECTED]]
  Sent: 10 January 2002  15:05
  To: Multiple recipients of list ORACLE-L
  Subject:  RE: The OCP bar is being raised
  
  
  I'd say the cost is being raised. Look at the  
   requirements for each. You can't just take the OCM exam. No we 
would first have to get the OCA. Whether or not we need the entry  level
cert we have to have it. Then, and only then, can we take the  OCP.
Then and only then, can we take the OCM and that is after we take  these
REQUIRED classes from Oracle Ed. So someone the caliber of Steve  Adams
or Jared Still, has to spend money in a class that they could probably  
   teach from memory before they can get certification and that is after
 getting 2 other certs that have no value to them. Call me a cynic,
but  to me, this is nothing but a money grab.
  From the website:
  --To become an Oracle Associate, you must pass the
exams  required
  -- for the Oracle Associate level of your  selected
job role. Typically, 
  --two exams are  required; the first one can be
taken via the Internet, 
  --while subsequent exams must be taken in a proctored
environment. By  
  --completing your Oracle Associate, you are half-way
 toward achieving the
  -- Oracle Certified  Professional credential. 
  
  --To become an Oracle Certified Professional, you
must pass  all required exams 
  --in your selected job role,  including those at
the Associate level. 
  
  --To become an Oracle Certified Master, you must
first be an  Oracle 
  --Certified Professional. Additionally,  achieving
your OCM credential 
  --requires attending  two advanced level Oracle
University courses from 
  --the list shown on this page as well as passing the
OCM Practicum  exam. 
  
  --Chris
  
  -Original Message-
  From:  [EMAIL PROTECTED] [
mailto:[EMAIL PROTECTED]
] 
  Sent: Thursday, January 10, 2002 9:16 AM
  To:  Multiple recipients of list ORACLE-L
  Subject: The  OCP bar is being raised
  
  Anyone care to comment on the following, IMHO it's
about  time:
  
  ---
  Introducing two new levels of  Oracle Certified
Professional (OCP) Achievement 
  
  A recent *IDC report on IT Education  and Training
Services quoted database
  professionals  and network engineers as the fastest-growing
areas of Professional
  Certification. And in an October survey from *crn.com
on  Certification, 58% of
  respondents said that it is  very difficult to find
qualified Oracle Certified
  Professionals-Database Administrators. 
  To meet this demand, we have recently introduced
two new  levels of professional
  achievement to DBAs (and soon  to be released to
Application and Java Developers
  worldwide): 
  The Oracle Certified Associate (OCA) -- an entry-level
 Oracle qualification
  requiring successful completion

RE: Database Comparison

2002-01-10 Thread HAWKINS, JAMES W [IT/1000]


Srini,

But be careful - the Change Management pack for OEM is a purchaseable
option.  It is not free.

Jim

__
Jim Hawkins
Oracle Database Administrator
Data Management Center of Expertise

Pharmacia Corporation
800 North Lindbergh Blvd.
St. Louis, Missouri  63167
Work  (314) 694-4417
Cellular (314) 724-9664
Pager (314) 294-9797

[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, January 09, 2002 11:20 PM
To: Multiple recipients of list ORACLE-L


 Srini,
Use the change manager that comes with Oracle Enterprise manager. The
initial set-up is little bit difficult. But once u r through, then it is an
handy tool.
Venkat
--

On Wed, 09 Jan 2002 11:00:36  
 Paul Baumgartel wrote:
There's a very good script available at http://www.dbspecialists.com.

--- [EMAIL PROTECTED] wrote:
 Hi:
 
 I need to compare my Production database with  QA database.  I would
 like to
 generate a report that shows differences in schemas across these two
 databases(tables, indexes, views, object definition,  etc..).  I
 would
 appreciate it if you could forward me a script that would accomplish
 this or
 any websites where I can find one.
 
 Thanks
 
 Srini Rajendran.
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com


__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

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

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



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

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

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

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

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

RE: The OCP bar is being raised

Title: Message

Wait a minute. I never said it was bad for companies to make
money. My past posts on microsoft should have made that clear. If
Oracle can get away with it, then hey, more power to them. My point
was that they are trying to make this look oh so nice by saying "it's
improved! Look at the hoops you have to go to get the OCM, they have to be
good". When really all the new levels do is require more cash for the
qualified people and allow bookworms to advance to a second level without
experience. Fortuneately I believe in the wonders of market forces.
If enough people say, "yeah right, I got your OCM right here", it'll die.
If not, then when I go for certificatinon, I'll see you in OCA
101... :)

--Chris

-Original Message-From:
orantdba [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10,
2002 10:36 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: The OCP bar is being raised
Hmmm,Imagine that, a
publicly traded company that it trying to make money, I am
shockeddismayed, I don't believe I will be able to sleep tonight.
Chris, could you provide me with the list of companies
that are not trying to make money?I want to make sure that I don't go to
work for them, or learn their products.John :-)[EMAIL PROTECTED] wrote:

I'd say the cost is being raised. Look at the
requirements for each. You can't just take the OCM exam. No we
would first have to get the OCA. Whether or not we need the entry
level cert we have to have it. Then, and only then, can we take the
OCP. Then and only then, can we take the OCM and that is after we take
these REQUIRED classes from Oracle Ed. So someone the caliber of Steve
Adams or Jared Still, has to spend money in a class that they could probably
teach from memory before they can get certification and that is after
getting 2 other certs that have no value to them. Call me a cynic, but
to me, this is nothing but a money grab.
From the website:
--To become an Oracle Associate, you must pass the exams
required-- for the Oracle Associate level of your
selected job role. Typically, --two exams are
required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By
--completing your Oracle Associate, you are half-way
toward achieving the-- Oracle Certified Professional
credential.
--To become an Oracle Certified Professional, you must pass
all required exams --in your selected job role,
including those at the Associate level.
--To become an Oracle Certified Master, you must first be an
Oracle --Certified Professional. Additionally,
achieving your OCM credential --requires attending
two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum
exam.
--Chris
-Original Message-From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ]
Sent: Thursday, January 10, 2002 9:16
AMTo: Multiple recipients of list
ORACLE-LSubject: The OCP bar is being
raised
Anyone care to comment on the following, IMHO it's about
time:---Introducing two new levels of Oracle
Certified Professional (OCP) Achievement A recent *IDC report on IT Education
and Training Services quoted databaseprofessionals
and network engineers as the fastest-growing areas of
ProfessionalCertification. And in an October survey
from *crn.com on Certification, 58% ofrespondents
said that it is very difficult to find qualified Oracle
CertifiedProfessionals-Database Administrators.

To meet this demand, we have recently introduced two new
levels of professionalachievement to DBAs (and soon
to be released to Application and Java Developersworldwide):
The Oracle Certified Associate (OCA) -- an entry-level
Oracle qualificationrequiring successful completion
of two exams.The Oracle Certified Master (OCM) -- an
advanced qualification for OracleCertified
Professionals (OCP), that requires students to take a practicum
examon-sitee at an Oracle University education
center. Visithttp://www.oracle.com/education/certification/news/index.html?certlevels.html
for more information
IDC, IT Education and Training, Sept 2001crn.com, Certification: What's Hot, What's Not, Oct
2001--- 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-5051San Diego,
California -- Public Internet
access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail

RE: Analyze vs. DBMS_STATS


Jay,
 I have switched to DBMS_STATS for quite some now. Most databases are
8.1.7.x. 
 I have not had any problems running DBMS_STATS. Or from the generated
stats. 

- Kirti 

-Original Message-
Sent: Thursday, January 10, 2002 9:31 AM
To: Multiple recipients of list ORACLE-L


Now that I finally have all of our databases upgraded to 8.1.7 I am taking
some time to look at our method of gathering statistics for CBO.  It looks
like I should move towards using DBMS_STATS to gather statistics, but I may
want to use ANALYZE if I need to gather stats on individual columns
(according to Note:166215.1).  I was just curious to know if most DBAs are
using  DBMS_STATS instead of ANALYZE.  For the most part, I had been using
DBMS_UTILITY.ANALYZE_SCHEMA.  I'll probably start using
DBMS_STATS.GATHER_SCHEMA_STATS unless somebody convinces me otherwise.  Any
comments or things that I should watch out for?

Thanks,


Jay Hostetter
Oracle DBA
D.  E. Communications
Ephrata, PA  USA

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

-- 
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: SQL for top 100 values

2002-01-10 Thread Rick_Cale



If using 8i

SELECT * FROM
(SELECT *
  FROM table
  ORDER BY column_name DESC)
WHERE rownum = 100;

Rick


   
 
Deen Dayal   
 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
 
ate.nj.us[EMAIL PROTECTED]   
 
Sent by:  cc:  
 
[EMAIL PROTECTED]Subject: SQL for top 100 values  
 
om 
 
   
 
   
 
01/10/2002 
 
11:03 AM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 




hi SQL wizards,

Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum  101 ).

Thanks
Deen


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

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

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


Deen Dayal wrote:
 
 hi SQL wizards,
 
 Can any body help me with the tjis SQL. I need a SQL records with top 100 values of 
a table ( not rownum  101 ).
 
 Thanks
 Deen
 

rownum  101 is OK if you nest your query, ORDER BY included, as an
in-line view,
ie

select x.val
from (select val
  from my_table
  order by val desc) x
where rownum  101
-- 
Regards,

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

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

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

RE: Dig it - killer freeware editor

2002-01-10 Thread Mohan, Ross


Hey, who's your buddy?

But I was disappointed it doesn't have a template yet for IEEE 802.11b 
RSA triple dipstick encryption. 

-Original Message-

Hannibal,

Thanks for the link! This product is SO COOL!

I personally code in SQL, HTML, Javascript, PHP (sometimes) and am curently
trying to get my head around perl - and this product rocks for all of them!

Thanks..

Mark

-Original Message-
Sent: 08 January 2002 20:35
To: Multiple recipients of list ORACLE-L


roger that, my DBA Brother..

-Original Message-
Sent: Tuesday, January 08, 2002 2:20 PM
To: Multiple recipients of list ORACLE-L


Looks very cool Ross, thanks for the link. -E



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

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

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

RE: The OCP bar is being raised

Title: RE: The OCP bar is being raised





Maybe I am completely misreading this. However, I didn't see the 8 to 9 OCP upgrade and that is why I said, you'll have to take them over again. If I am completely out to lunch and this is just a re-org of the Masters and OCP and those 8 OCP can get OCM with 2 classes and a test, then I apologize for wasting your time and bandwidth, but from what I read (and it was a quick read) even if you are 8 OCP, you still have to have the 9 OCA and OCP before you can get the 9 OCM. 

--Chris



-Original Message-
From: Joe Raube [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 10, 2002 10:41 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: The OCP bar is being raised



Of course, those of us who already have the OCP and want to be called a 
'master'
just need to take the 2 required courses and then the OCM exam.


When looking at the details, they just split the previous 5 exam OCP into 
two tiers,
a 2 exam OCA, and a 2 exam OCP which has the OCA as a prerequisite.


The Oracle Master was always available, but without a test -- it just
required taking ILT courses. They just added a practicum exam to
make the OCM cert.


I can see your point about this being a 'money grab', but the only new item
here is the OCM practicum exam -- everything else existed for 8 and 8i.


-Joe


At 07:05 AM 1/10/02 -0800, you wrote:


I'd say the cost is being raised. Look at the requirements for each. You 
can't just take the OCM exam. No we would first have to get the 
OCA. Whether or not we need the entry level cert we have to have 
it. Then, and only then, can we take the OCP. Then and only then, can we 
take the OCM and that is after we take these REQUIRED classes from Oracle 
Ed. So someone the caliber of Steve Adams or Jared Still, has to spend 
money in a class that they could probably teach from memory before they 
can get certification and that is after getting 2 other certs that have no 
value to them. Call me a cynic, but to me, this is nothing but a money grab.

 From the website:

--To become an Oracle Associate, you must pass the exams required
-- for the Oracle Associate level of your selected job role. Typically,
--two exams are required; the first one can be taken via the Internet,
--while subsequent exams must be taken in a proctored environment. By
--completing your Oracle Associate, you are half-way toward achieving the
-- Oracle Certified Professional credential.

--To become an Oracle Certified Professional, you must pass all required 
exams
--in your selected job role, including those at the Associate level.

--To become an Oracle Certified Master, you must first be an Oracle
--Certified Professional. Additionally, achieving your OCM credential
--requires attending two advanced level Oracle University courses from
--the list shown on this page as well as passing the OCM Practicum exam.

--Chris

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Subject: The OCP bar is being raised

Anyone care to comment on the following, IMHO it's about time:
 

---
Introducing two new levels of Oracle Certified Professional (OCP) Achievement

A recent *IDC report on IT Education and Training Services quoted database
professionals and network engineers as the fastest-growing areas of 
Professional
Certification. And in an October survey from *crn.com on Certification, 
58% of
respondents said that it is very difficult to find qualified Oracle Certified
Professionals-Database Administrators.

To meet this demand, we have recently introduced two new levels of 
professional
achievement to DBAs (and soon to be released to Application and Java 
Developers
worldwide):

The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
requiring successful completion of two exams.
The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
Certified Professionals (OCP), that requires students to take a practicum 
exam
on-sitee at an Oracle University education center.
Visit
http://www.oracle.com/education/certification/news/index.html?certlevels.htmlhttp://www.oracle.com/education/certification/news/index.html?certlevels.html 


for more information

IDC, IT Education and Training, Sept 2001
crn.com, Certification: What's Hot, What's Not, Oct 2001
 

-
--
Please see the official ORACLE-L FAQ: 
http://www.orafaq.comhttp://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

Re: SQL for top 100 values

2002-01-10 Thread Marin Dimitrov


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 18:03

 hi SQL wizards,

 Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum  101 ).


u do need rownum

select *
from (select *
from X
   order by Y desc
 )
where rownum  100;


hth,

Marin



...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. 



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

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

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

Re: SQL for top 100 values

2002-01-10 Thread Ron Rogers




Deen,
You could try SELECT fields... FROM 
(SELECT field1 FROM table1 ORDER BY field1)
WHERE rownum 100; ( the value is 100 less that 
number of rows returned)
That will order the rows returned by the value in the field1 
and then give you the row numbers of the returned rows that are greater than 
100. Be sure to adjust the query to know how many rows are returned and then get 
only the last 100.Read about Top-N SQL Queries...
ROR mª¿ªm [EMAIL PROTECTED] 01/10/02 11:03AM 
hi SQL wizards,Can any body help me with the tjis SQL. I 
need a SQL records with top 100 values of a table ( not rownum  101 
).ThanksDeen-- Please see the official ORACLE-L FAQ: 
http://www.orafaq.com-- Author: Deen 
Dayal INET: [EMAIL PROTECTED]Fat City Network 
Services -- (858) 538-5051 FAX: (858) 538-5051San 
Diego, California -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

Re: SQL for top 100 values

2002-01-10 Thread Jan Pruner


Use ORDER BY name of column DESC
and, of course, rownum  101  :-)))
--
SELECT NAME, VALUE FROM (
SELECT NAME, VALUE FROM TOP100 ORDER BY VALUE DESC
) WHERE ROWNUM  101


JP

On Thu 10. January 2002 17:03, you wrote:
 hi SQL wizards,

 Can any body help me with the tjis SQL. I need a SQL records with top 100
 values of a table ( not rownum  101 ).

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

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

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

RE: SQL for top 100 values

2002-01-10 Thread Mohan, Ross


Or use KdB. 

-Original Message-
Sent: Thursday, January 10, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L



If using 8i

SELECT * FROM
(SELECT *
  FROM table
  ORDER BY column_name DESC)
WHERE rownum = 100;

Rick


 

Deen Dayal

[EMAIL PROTECTED]To: Multiple recipients of
list ORACLE-L  
ate.nj.us[EMAIL PROTECTED]

Sent by:  cc:

[EMAIL PROTECTED]Subject: SQL for top 100
values   
om

 

 

01/10/2002

11:03 AM

Please respond

to ORACLE-L

 

 





hi SQL wizards,

Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum  101 ).

Thanks
Deen


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

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

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




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

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

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

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

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

Re: SQL for top 100 values

2002-01-10 Thread tday6


SELECT * FROM (SELECT VALUES FROM TABLE ORDER BY VALUES) ROWNUM  101;


   

Deen Dayal 

ddayal  To: Multiple recipients of list ORACLE-L  

@dol.state.nj[EMAIL PROTECTED]

.us cc:   

Sent by: rootSubject: SQL for top 100 values   

   

   

01/10/2002 

11:03 AM   

Please 

respond to 

ORACLE-L   

   

   





hi SQL wizards,

Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum  101 ).

Thanks
Deen


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

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

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

2002-01-10 Thread Jared . Still



Just set the environment variable before running sqlldr:
   export NLS_DATE_FORMAT='MON DD '




   
 
Ruth Gramolini   
 
[EMAIL PROTECTED]   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
ate.vt.us   cc:   
 
Sent by: Subject: nls_date_format problem in 
sqlldr 
[EMAIL PROTECTED]   
 
   
 
   
 
01/10/02 05:25 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Good morning,

We are having a problem load a file containing dates in MON DD  format
into a database having and nls_date_format=MMDD.  Is there a way to do
an alter session command in the control file or the parameter file to that
we can load this data?

We have had the production database down for 4 days with various problems
and this is the last straw.

Thanks in advance,
Ruth

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

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

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




-- 
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: data modeling

2002-01-10 Thread Jared . Still




Check this out on amazon.com.

They have several used copies.  I replaced my copy that was 'borrowed'
just last
week for $24 US.  ( $60 list )

Jared




   
 
G.Plivna@itsys 
 
tems.lv  To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]
Sent by: cc:   
 
[EMAIL PROTECTED]   Subject: Re: data modeling
 
om 
 
   
 
   
 
01/10/02 12:30 
 
AM 
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





Case*Method Entity Relationship Modelling by Richard Barker; 1990; ISBN
0-201-41696-4;
Data Model Patterns / Conventions of Thought/ David C. Hay
The Data Model Resource Book by L. Silverston, W.H.Inmon, K. Graziano;
1997; ISBN 0471-15364-8;

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/




Janet Linsy

janetlinsy@ya   To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
hoo.com cc:

Sent by: Subject: data modeling

[EMAIL PROTECTED]

om



2002.01.10

02:35

Please respond

to ORACLE-L







Hi all,

You know any good book, web site about data modeling?
Thank you!

Janet

__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Janet Linsy
  INET: [EMAIL PROTECTED]

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

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




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

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

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




--
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: SQL Loader Question


I tested under 8.1.6 on NT and the reply is NO.
Checked also the new features for 9.0.1 and no mention of this.

Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]

 -Original Message-
 From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]]
 Sent: Thu, January 10, 2002 4:30 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: SQL Loader Question
 
 My guess is : No. 
 Can you run a quick test and let us know ?? 
 Thanks.
 - Kirti 
 
 -Original Message-
 Sent: Wednesday, January 09, 2002 3:45 PM
 To: Multiple recipients of list ORACLE-L
 
 
 8.1.7 on W2000
 I would like to know if there is a way to group more than one parfile into
 one file?  I would like to run just one file verses a number of parfiles.
 
 Thanks,
 Ken Janusz, CPIM 
 Database Conversion Lead 
 Sufficient Systems, Inc. 
 Minneapolis, MN
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Ken Janusz
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (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).
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
  This e-mail was scanned by the eSafe Mail Gateway 
 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: [EMAIL PROTECTED]

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

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

Re: Veritas Quick IO Oracle Performance

2002-01-10 Thread Brian Haas


Ed,

I would be interested in getting a copy of your test scripts to try it out 
on our setup. Solaris 8, veritas DBed 2.2 and Oracle 8.1.7.

Our performance has increased since switching to quick io, but that also 
included a major application overhaul, and new disk layout and an upgrade 
to 8.1.7.

Of course numerous factors come into play with these tests: Disk 
layout,whether the tables are analyzed, how the sql looked,hardware...etc.

As far as issues with quickio, some that I can think of are to make sure 
to size your datafiles properly because auto-extend doesn't work(if you 
use the whole file). And There are some gotchas if you use RMAN for backups
(I don't,tar works fine for quickio files). So far, no problems here.

-Brian


On Wed, 9 Jan 2002, Ed Bittel wrote:
I was asked to evaluate the potential benefit of using
Veritas Quick I/O
for one of our databases.  I put together some simple
tests to gauge the
expected impact of Veritas Quick I/O on Oracle
performance. The tests
were designed so that the only variable when running
the test scripts
was type of datafile the scripts were reading from or
writing to (i.e.,
Quick I/O or non-Quick I/O).

The results of the tests were very surprising. Only
the performance of
large DDL operations, such as copying tables and
creating indexes, was
significantly improved after implementing Veritas
Quick I/O for an
Oracle datafile.  Performance of DML operations ranged
from marginally
improved to markedly worse after implementing Veritas
Quick I/O for an
Oracle datafile.  Large selects were particularly poor
performing with
Quick IO.

Are these results typical?  Are there any issue I
should be aware of?

We're running Oracle 8.1.6.3 on Solaris with Veritas
Database Edition
for Oracle 2.1.1.


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

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

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: BUG? Inserting BLOB or CLOB values when table and field names are created with quotes

2002-01-10 Thread Marin Dimitrov



- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 18:09
created with quotes



 1. If you create the table and field names with quotes (tablename,
 FieldName, etc), then you cannot insert BLOB or CLOB values larger than
 4000 bytes (error is: Invalid Column Name). Data which is smaller or equal
 then 4000 bytes is simply OK.


this is from Metalink:

11. Are there limitations on the size of large objects (BLOB, CLOB, NCLOB,
BFILE)?

Answer
--
ADO limits a maximum of 2 GB that can be used for maximum column size.
There is a known limitation of not being able to insert  4000 bytes in LOBs
using the Command object.  Oracle is actively working on enhancing our
provider to remove this limitation.


I'm not sure if your ADO version contains a fix for this, but meanwhile
check this:
ftp://oracle-ftp.oracle.com/dev_tools/patchsets/mslang/oledb/bug1876296/


hth,

Marin


...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. 



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

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

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

RE: The OCP bar is being raised

2002-01-10 Thread Viktor


How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor

--- Bowes, Chris [EMAIL PROTECTED] wrote:
 Maybe I am completely misreading this.  However, I
 didn't see the 8 to 9 OCP
 upgrade and that is why I said, you'll have to take
 them over again.  If I
 am completely out to lunch and this is just a re-org
 of the Masters and OCP
 and those 8 OCP can get OCM with 2 classes and a
 test, then I apologize for
 wasting your time and bandwidth, but from what I
 read (and it was a quick
 read) even if you are 8 OCP, you still have to have
 the 9 OCA and OCP before
 you can get the 9 OCM.  
 
 --Chris
 
 
 -Original Message-
 Sent: Thursday, January 10, 2002 10:41 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Of course, those of us who already have the OCP and
 want to be called a 
 'master'
 just need to take the 2 required courses and then
 the OCM exam.
 
 When looking at the details, they just split the
 previous 5 exam OCP into 
 two tiers,
 a 2 exam OCA, and a 2 exam OCP which has the OCA as
 a prerequisite.
 
 The Oracle Master was always available, but without
 a test -- it just
 required taking ILT courses. They just added a
 practicum exam to
 make the OCM cert.
 
 I can see your point about this being a 'money
 grab', but the only new item
 here is the OCM practicum exam -- everything else
 existed for 8 and 8i.
 
 -Joe
 
 At 07:05 AM 1/10/02 -0800, you wrote:
 
 I'd say the cost is being raised.  Look at the
 requirements for each.  You 
 can't just take the OCM exam.  No we would first
 have to get the 
 OCA.  Whether or not we need the entry level cert
 we have to have 
 it.  Then, and only then, can we take the OCP. 
 Then and only then, can we 
 take the OCM and that is after we take these
 REQUIRED classes from Oracle 
 Ed.  So someone the caliber of Steve Adams or Jared
 Still, has to spend 
 money in a class that they could probably teach
 from memory before they 
 can get certification and that is after getting 2
 other certs that have no 
 value to them.  Call me a cynic, but to me, this is
 nothing but a money
 grab.
 
  From the website:
 
 --To become an Oracle Associate, you must pass the
 exams required
 -- for the Oracle Associate level of your selected
 job role. Typically,
 --two exams are required; the first one can be
 taken via the Internet,
 --while subsequent exams must be taken in a
 proctored environment. By
 --completing your Oracle Associate, you are
 half-way toward achieving the
 -- Oracle Certified Professional credential.
 
 --To become an Oracle Certified Professional, you
 must pass all required 
 exams
 --in your selected job role, including those at the
 Associate level.
 
 --To become an Oracle Certified Master, you must
 first be an Oracle
 --Certified Professional. Additionally, achieving
 your OCM credential
 --requires attending two advanced level Oracle
 University courses from
 --the list shown on this page as well as passing
 the OCM Practicum exam.
 
 --Chris
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 10, 2002 9:16 AM
 To: Multiple recipients of list ORACLE-L
 Subject: The OCP bar is being raised
 
 Anyone care to comment on the following, IMHO it's
 about time:

---
 - 
 
 ---
 Introducing two new levels of Oracle Certified
 Professional (OCP)
 Achievement
 
 A recent *IDC report on IT Education and Training
 Services quoted database
 professionals and network engineers as the
 fastest-growing areas of 
 Professional
 Certification. And in an October survey from
 *crn.com on Certification, 
 58% of
 respondents said that it is very difficult to find
 qualified Oracle
 Certified
 Professionals-Database Administrators.
 
 To meet this demand, we have recently introduced
 two new levels of 
 professional
 achievement to DBAs (and soon to be released to
 Application and Java 
 Developers
 worldwide):
 
 The Oracle Certified Associate (OCA) -- an
 entry-level Oracle qualification
 requiring successful completion of two exams.
 The Oracle Certified Master (OCM) -- an advanced
 qualification for Oracle
 Certified Professionals (OCP), that requires
 students to take a practicum 
 exam
 on-sitee at an Oracle University education center.
 Visit

http://www.oracle.com/education/certification/news/index.html?certlevels.h

tmlhttp://www.oracle.com/education/certification/news/index.html?certlevels
 .html 
 
 for more information
 
 IDC, IT Education and Training, Sept 2001
 crn.com, Certification: What's Hot, What's Not, Oct
 2001

---
 - 
 
 -
 --
 Please see the official ORACLE-L FAQ: 
 http://www.orafaq.comhttp://www.orafaq.com
 --
 Author:
INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
 San Diego,

Re: Where to download Oracle Applications / ERP packages

2002-01-10 Thread Jared . Still



I don't believe those are available for download, at least not legally.

Jared




   

Andrey Bronfin 

andreyb@elrontel   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
esoft.com  cc:

Sent by:Subject: Where to download Oracle 
Applications / ERP packages  
[EMAIL PROTECTED]   

   

   

01/10/02 04:00 AM  

Please respond to  

ORACLE-L   

   

   





Dear list !
Where can i download Oracle Applications / ERP packages.
Thanks a lot !


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

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

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

2002-01-10 Thread Deen Dayal


I tried to run it in Oracle 7.3.4, it comes up with a syntax error

Here is the SQL
select x.fein,x.open_bal
from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) open_bal
  from employer
  order by open_bal desc ) x
where rownum  101

Here is what I get

SQLWKS select x.fein,x.open_bal
 2 from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) 
open_bal
 3   from employer
 4   order by open_bal desc ) x
 5 where rownum  101
 6
  order by open_bal desc ) x
  *
ORA-00907: missing right parenthesis

Is it because I am on a lower version


Thanks
Deen

-Original Message-
Faroult
Sent: Thursday, January 10, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L


Deen Dayal wrote:

 hi SQL wizards,

 Can any body help me with the tjis SQL. I need a SQL records with top 100 values of 
a table ( not rownum  101 ).

 Thanks
 Deen


rownum  101 is OK if you nest your query, ORDER BY included, as an
in-line view,
ie

select x.val
from (select val
  from my_table
  order by val desc) x
where rownum  101
--
Regards,

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

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

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


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

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

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

8.1.7 Release 3 Patch for Solaris - Download Troubles

2002-01-10 Thread Kevin Lange


Hey Guys.
  Just built my 8.1.7 solaris test server at work and need to patch it up to
Release 3.  Unfortunately, OTN keeps giving me Page Not Found when I go to
download it.

Does anyone know any alternate locations that these patches are available ??

Thanks

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

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

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

RE: The OCP bar is being raised


Here's the link:

http://www.oracle.com/education/certification/index.html?dba9i_upgrade.html

and here's the upgrade path:

http://www.oracle.com/education/certification/index.html?dba9i_track.html

Oracle 7.3 to Oracle9i Upgrade Path (3 exams)
Candidates certified on Oracle 7.3 pass exam #1Z0-010 Oracle8: New Features 
for Administrators to upgrade to Oracle8, then #1Z0-020 Oracle8i: New 
Features for Administrators to upgrade to Oracle8i, and lastly exam 
#1Z0-030 Oracle9i: New Features for Administrators.

This would bring you to 9i OCP level.

-Joe

At 08:25 AM 1/10/02 -0800, you wrote:

Maybe I am completely misreading this.  However, I didn't see the 8 to 9 
OCP upgrade and that is why I said, you'll have to take them over 
again.  If I am completely out to lunch and this is just a re-org of the 
Masters and OCP and those 8 OCP can get OCM with 2 classes and a test, 
then I apologize for wasting your time and bandwidth, but from what I read 
(and it was a quick read) even if you are 8 OCP, you still have to have 
the 9 OCA and OCP before you can get the 9 OCM.

--Chris

-Original Message-
From: Joe Raube [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 10:41 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: The OCP bar is being raised

Of course, those of us who already have the OCP and want to be called a
'master'
just need to take the 2 required courses and then the OCM exam.

When looking at the details, they just split the previous 5 exam OCP into
two tiers,
a 2 exam OCA, and a 2 exam OCP which has the OCA as a prerequisite.

The Oracle Master was always available, but without a test -- it just
required taking ILT courses. They just added a practicum exam to
make the OCM cert.

I can see your point about this being a 'money grab', but the only new item
here is the OCM practicum exam -- everything else existed for 8 and 8i.

-Joe

At 07:05 AM 1/10/02 -0800, you wrote:

 I'd say the cost is being raised.  Look at the requirements for each.  You
 can't just take the OCM exam.  No we would first have to get the
 OCA.  Whether or not we need the entry level cert we have to have
 it.  Then, and only then, can we take the OCP.  Then and only then, can we
 take the OCM and that is after we take these REQUIRED classes from Oracle
 Ed.  So someone the caliber of Steve Adams or Jared Still, has to spend
 money in a class that they could probably teach from memory before they
 can get certification and that is after getting 2 other certs that have no
 value to them.  Call me a cynic, but to me, this is nothing but a money 
 grab.
 
  From the website:
 
 --To become an Oracle Associate, you must pass the exams required
 -- for the Oracle Associate level of your selected job role. Typically,
 --two exams are required; the first one can be taken via the Internet,
 --while subsequent exams must be taken in a proctored environment. By
 --completing your Oracle Associate, you are half-way toward achieving the
 -- Oracle Certified Professional credential.
 
 --To become an Oracle Certified Professional, you must pass all required
 exams
 --in your selected job role, including those at the Associate level.
 
 --To become an Oracle Certified Master, you must first be an Oracle
 --Certified Professional. Additionally, achieving your OCM credential
 --requires attending two advanced level Oracle University courses from
 --the list shown on this page as well as passing the OCM Practicum exam.
 
 --Chris
 
 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
 Sent: Thursday, January 10, 2002 9:16 AM
 To: Multiple recipients of list ORACLE-L
 Subject: The OCP bar is being raised
 
 Anyone care to comment on the following, IMHO it's about time:
 - 
 ---
 
 ---
 Introducing two new levels of Oracle Certified Professional (OCP) 
 Achievement
 
 A recent *IDC report on IT Education and Training Services quoted database
 professionals and network engineers as the fastest-growing areas of
 Professional
 Certification. And in an October survey from *crn.com on Certification,
 58% of
 respondents said that it is very difficult to find qualified Oracle 
 Certified
 Professionals-Database Administrators.
 
 To meet this demand, we have recently introduced two new levels of
 professional
 achievement to DBAs (and soon to be released to Application and Java
 Developers
 worldwide):
 
 The Oracle Certified Associate (OCA) -- an entry-level Oracle qualification
 requiring successful completion of two exams.
 The Oracle Certified Master (OCM) -- an advanced qualification for Oracle
 Certified Professionals (OCP), that requires students to take a practicum
 exam
 on-sitee at an Oracle University education center.
 Visit
 http://www.oracle.com/education/certification/news/index.html?certlevel

ORA-02085

2002-01-10 Thread tday6


Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.

I don't want to.

Tried using a synonym but that didn't work.

Tried using create database link linkname connect to userid identified by
password
 using '  (DESCRIPTION =(ADDRESS_LIST =  (ADDRESS = (PROTOCOL =
TCP)(HOST = hostname)(PORT = 1521)))(CONNECT_DATA =
(SERVICE_NAME = dbname))  )' ;

Didn't work.  It created the database link just fine but when I try to use
it I get:

ORA-02085: database link linkname connects to dbname

Anyone know of any work-arounds.

-- 
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: SQL for top 100 values

2002-01-10 Thread Babich , Sergey

Correction : SELECT * FROM (SELECT DISTINCT VALUES FROM TABLE ORDER BY
VALUES DESC) WHERE ROWNUM  101;

 -Original Message-
Sent:   Thursday, January 10, 2002 11:51 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: SQL for top 100 values

SELECT * FROM (SELECT VALUES FROM TABLE ORDER BY VALUES) ROWNUM  101;

Deen Dayal

ddayal  To: Multiple recipients of list
ORACLE-L  
@dol.state.nj[EMAIL PROTECTED]

.us cc:

Sent by: rootSubject: SQL for top 100 values

01/10/2002

11:03 AM

Please

respond to

ORACLE-L

hi SQL wizards,

Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum  101 ).

Thanks
Deen

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

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

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

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

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

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

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

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

Sqlnet dead connection detection (DCD)

2002-01-10 Thread antonio . belloni



Hi,
  
   We´ve setup DCD , using
   SQLNET.EXPIRE_TIME = 5 in  
   sqlnet.ora , but it´s not  
   working. The dead  
   connections are not being  
   disconnected. Is there any 
   further configuration or   
   issue to care about ?  
  
   Oracle = 8.0.5.1 running   
   with MTS   
   OS = AIX 4.3   
   Net8   
  
   Thanks,
   Antonio Belloni
  
  
  
  




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

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

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

RE: The OCP bar is being raised

2002-01-10 Thread Mohan, Ross


I know some Oracle employees that have OCD.

-Original Message-
Sent: Thursday, January 10, 2002 12:16 PM
To: Multiple recipients of list ORACLE-L


How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor









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

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

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

Re: ORA-02085

2002-01-10 Thread Rodd Holman





In your init.ora

 GLOBAL_NAMES=FALSE

Bounce your db and it should be OK.



On Thu, 2002-01-10 at 11:40, [EMAIL PROTECTED] wrote:

Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
database that it's linking to.

I don't want to.

Tried using a synonym but that didn't work.

Tried using create database link linkname connect to userid identified by
password
 using '  (DESCRIPTION =(ADDRESS_LIST =  (ADDRESS = (PROTOCOL =
TCP)(HOST = hostname)(PORT = 1521)))(CONNECT_DATA =
(SERVICE_NAME = dbname))  )' ;

Didn't work.  It created the database link just fine but when I try to use
it I get:

ORA-02085: database link linkname connects to dbname

Anyone know of any work-arounds.

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




-- 
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
[EMAIL PROTECTED]
(605) 988-1373

RE: Where to download Oracle Applications / ERP packages


Order the CD Pack if you are in the U.S..

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


 -Original Message-
Sent:   Thursday, January 10, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Where to download Oracle Applications / ERP packages


I don't believe those are available for download, at least not legally.

Jared




 

Andrey Bronfin

andreyb@elrontel   To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
esoft.com  cc:

Sent by:Subject: Where to download
Oracle Applications / ERP packages  
[EMAIL PROTECTED]

 

 

01/10/02 04:00 AM

Please respond to

ORACLE-L

 

 





Dear list !
Where can i download Oracle Applications / ERP packages.
Thanks a lot !


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

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

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




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

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

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


Oracle employees typically get Oracle training for free, esp. during times
when they are idle - whenever THAT happens.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
Sent:   Thursday, January 10, 2002 1:16 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: The OCP bar is being raised

How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor
-- 
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: 8.1.7 Release 3 Patch for Solaris - Download Troubles


Kevin:

I had the same problem when I tried to download 9i zip files.  It turned out
to be a problem with the security setup on my laptop for IE.  

Ken

 -Original Message-
Sent:   Thursday, January 10, 2002 11:32 AM
To: Multiple recipients of list ORACLE-L
Subject:8.1.7 Release 3 Patch for Solaris - Download Troubles

Hey Guys.
  Just built my 8.1.7 solaris test server at work and need to patch it up to
Release 3.  Unfortunately, OTN keeps giving me Page Not Found when I go to
download it.

Does anyone know any alternate locations that these patches are available ??

Thanks

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

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

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

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

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

RE: The OCP bar is being raised


Well, there are at least 6 - from
http://www.tusc.com/oracle/news/20011203a.html

Niemiec joins Dr. Paul Dorsey, David Ensor, Peter Koletzke, Scott Nelson 
and Jeremiah Wilton in the first group of Oracle Certified Masters to be 
recognized by Oracle Corp

-Joe

At 09:15 AM 1/10/02 -0800, you wrote:
How many people outhere that you know do actually have
OCM. Not ORACLE employees.

Just curious...

Regards,

Viktor

--- Bowes, Chris [EMAIL PROTECTED] wrote:
  Maybe I am completely misreading this.  However, I
  didn't see the 8 to 9 OCP
  upgrade and that is why I said, you'll have to take
  them over again.  If I
  am completely out to lunch and this is just a re-org
  of the Masters and OCP
  and those 8 OCP can get OCM with 2 classes and a
  test, then I apologize for
  wasting your time and bandwidth, but from what I
  read (and it was a quick
  read) even if you are 8 OCP, you still have to have
  the 9 OCA and OCP before
  you can get the 9 OCM.
 
  --Chris
 
 
  -Original Message-
  Sent: Thursday, January 10, 2002 10:41 AM
  To: Multiple recipients of list ORACLE-L
 
 
  Of course, those of us who already have the OCP and
  want to be called a
  'master'
  just need to take the 2 required courses and then
  the OCM exam.
 
  When looking at the details, they just split the
  previous 5 exam OCP into
  two tiers,
  a 2 exam OCA, and a 2 exam OCP which has the OCA as
  a prerequisite.
 
  The Oracle Master was always available, but without
  a test -- it just
  required taking ILT courses. They just added a
  practicum exam to
  make the OCM cert.
 
  I can see your point about this being a 'money
  grab', but the only new item
  here is the OCM practicum exam -- everything else
  existed for 8 and 8i.
 
  -Joe
 
  At 07:05 AM 1/10/02 -0800, you wrote:
 
  I'd say the cost is being raised.  Look at the
  requirements for each.  You
  can't just take the OCM exam.  No we would first
  have to get the
  OCA.  Whether or not we need the entry level cert
  we have to have
  it.  Then, and only then, can we take the OCP.
  Then and only then, can we
  take the OCM and that is after we take these
  REQUIRED classes from Oracle
  Ed.  So someone the caliber of Steve Adams or Jared
  Still, has to spend
  money in a class that they could probably teach
  from memory before they
  can get certification and that is after getting 2
  other certs that have no
  value to them.  Call me a cynic, but to me, this is
  nothing but a money
  grab.
  
   From the website:
  
  --To become an Oracle Associate, you must pass the
  exams required
  -- for the Oracle Associate level of your selected
  job role. Typically,
  --two exams are required; the first one can be
  taken via the Internet,
  --while subsequent exams must be taken in a
  proctored environment. By
  --completing your Oracle Associate, you are
  half-way toward achieving the
  -- Oracle Certified Professional credential.
  
  --To become an Oracle Certified Professional, you
  must pass all required
  exams
  --in your selected job role, including those at the
  Associate level.
  
  --To become an Oracle Certified Master, you must
  first be an Oracle
  --Certified Professional. Additionally, achieving
  your OCM credential
  --requires attending two advanced level Oracle
  University courses from
  --the list shown on this page as well as passing
  the OCM Practicum exam.
  
  --Chris
  
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]]
  Sent: Thursday, January 10, 2002 9:16 AM
  To: Multiple recipients of list ORACLE-L
  Subject: The OCP bar is being raised
  
  Anyone care to comment on the following, IMHO it's
  about time:
 
 ---
  -
  
  ---
  Introducing two new levels of Oracle Certified
  Professional (OCP)
  Achievement
  
  A recent *IDC report on IT Education and Training
  Services quoted database
  professionals and network engineers as the
  fastest-growing areas of
  Professional
  Certification. And in an October survey from
  *crn.com on Certification,
  58% of
  respondents said that it is very difficult to find
  qualified Oracle
  Certified
  Professionals-Database Administrators.
  
  To meet this demand, we have recently introduced
  two new levels of
  professional
  achievement to DBAs (and soon to be released to
  Application and Java
  Developers
  worldwide):
  
  The Oracle Certified Associate (OCA) -- an
  entry-level Oracle qualification
  requiring successful completion of two exams.
  The Oracle Certified Master (OCM) -- an advanced
  qualification for Oracle
  Certified Professionals (OCP), that requires
  students to take a practicum
  exam
  on-sitee at an Oracle University education center.
  Visit
 
 http://www.oracle.com/education/certification/news/index.html?certlevels.h
tmlhttp://www.oracle.com/education/certification/news/index.html?certlevels
  .html
  
  for more

RE: SQL for top 100 values

2002-01-10 Thread Babich , Sergey


Don't use any aliases (x in your case) and try again
Regards

 -Original Message-
Sent:   Thursday, January 10, 2002 12:32 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL for top 100 values

I tried to run it in Oracle 7.3.4, it comes up with a syntax error

Here is the SQL
select x.fein,x.open_bal
from (select sf_get_fein(employer_id) fein,
nvl(total_open_balance_amt,0) open_bal
  from employer
  order by open_bal desc ) x
where rownum  101

Here is what I get

SQLWKS select x.fein,x.open_bal
 2 from (select sf_get_fein(employer_id) fein,
nvl(total_open_balance_amt,0) open_bal
 3   from employer
 4   order by open_bal desc ) x
 5 where rownum  101
 6
  order by open_bal desc ) x
  *
ORA-00907: missing right parenthesis

Is it because I am on a lower version


Thanks
Deen

-Original Message-
Faroult
Sent: Thursday, January 10, 2002 11:26 AM
To: Multiple recipients of list ORACLE-L


Deen Dayal wrote:

 hi SQL wizards,

 Can any body help me with the tjis SQL. I need a SQL records with top 100
values of a table ( not rownum  101 ).

 Thanks
 Deen


rownum  101 is OK if you nest your query, ORDER BY included, as an
in-line view,
ie

select x.val
from (select val
  from my_table
  order by val desc) x
where rownum  101
--
Regards,

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

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

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


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

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

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

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

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

Erwin

2002-01-10 Thread Hamid Alavi


Hi List,
Sorry for off topic but if anybody know any patch for ERWIN 4.0 let me know
.
Thanks



Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

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

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

2002-01-10 Thread Igor Neyman


Try

global_names = false

in your initSID.ora file.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 10, 2002 12:40 PM


 Oracle 8.1.6, using Net8, wants me to name my db_link the same as the
 database that it's linking to.

 I don't want to.

 Tried using a synonym but that didn't work.

 Tried using create database link linkname connect to userid identified by
 password
  using '  (DESCRIPTION =(ADDRESS_LIST =  (ADDRESS = (PROTOCOL =
 TCP)(HOST = hostname)(PORT = 1521)))(CONNECT_DATA =
 (SERVICE_NAME = dbname))  )' ;

 Didn't work.  It created the database link just fine but when I try to use
 it I get:

 ORA-02085: database link linkname connects to dbname

 Anyone know of any work-arounds.

 --
 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: 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: SQL for top 100 values


Deen Dayal wrote:
 
 I tried to run it in Oracle 7.3.4, it comes up with a syntax error
 
 Here is the SQL
 select x.fein,x.open_bal
 from (select sf_get_fein(employer_id) fein, nvl(total_open_balance_amt,0) 
open_bal
   from employer
   order by open_bal desc ) x
 where rownum  101
 
 Here is what I get
 
 SQLWKS select x.fein,x.open_bal
  2 from (select sf_get_fein(employer_id) fein, 
nvl(total_open_balance_amt,0) open_bal
  3   from employer
  4   order by open_bal desc ) x
  5 where rownum  101
  6
   order by open_bal desc ) x
   *
 ORA-00907: missing right parenthesis
 
 Is it because I am on a lower version
 
 Thanks
 Deen

7.3 does not accept ORDER BY in views (inline or otherwise). There is an
old trick available however :
select sf_get_fein(e1.employer_id) fein,
nvl(e1.total_open_balance_amt,0) open_bal
from employer e1
where 99 = (select count(*)
 from employer e2
 where e2.total_open_balance_amt =
nvl(e1.total_open_balance_amt)
order by 2 desc

Should more or less give you what you want. Add an index on
total_open_balance_amt if you do not want the query to run for hours.
-- 
Regards,

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

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

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

RE: SQL Loader Question