RE: VMS equivalent of ls -lrt

[Steven Lembark]

-- Hallas John <[EMAIL PROTECTED]>

> Top Man Rich.
>
> Works well and a satisfied user for the first time in my career!!
> Nice bit of coding, especially the line formatting bit
>
> DCL is a nice language to work in I always found. Once you know what
> lexicals are available it is amazing what you can do with them.
>
>
> Much appreciated

Check the Big Grey Wall for the lexical func's in DCL
(f$foo). They are processed in the second -- lexical --
phase of DCL processing and give you access to most of
the guts of VMS.

--
Steven Lembark   2930 W. Palmer
Workhorse Computing   Chicago, IL 60647
+1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: [EMAIL PROTECTED]

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

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

[Molina, Gerardo]

There is a good article in Select Magazine (IOUG) Q4 2001 on Oracle Apps
patching.  Worth checking out.
 
Gerardo

-Original Message-
Sent: Tuesday, November 20, 2001 6:00 AM
To: Multiple recipients of list ORACLE-L



After applying the c.drv portion of the patch, 
I'm attempting to apply the d.drv portion of patch 
the patch above and adwork1 is failing applying the d.drv file. 

In the adwork1.log file I see, 
jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail 
-thin -user "USERNAME/PASSSWORD@host:port:SID"
/opt/oracle/testappl/admin/test/out/p01ldjva.jar 

followed by a ton of 
ORA-03115 unsupported network/data/type or representation 
and 
ORA-29509 incorrectly formed Java binary class definition 
errors. 

I suspect that the file 
/opt/oracle/testappl/admin/test/out/p01ldjva.jar 
was taken from new xmlparserv2.zip file that is present in 
the patch. 

Being the relative newcomer at this, my question is 
what do I do now?  It's already got part way through 
applying the d.drv file, which means (if i understand this 
correctly) that I cannot un-patch.  I have to recover from the 
backup.  What can I do to try to move this forward rather 
than recovering and starting over? 

 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
"Doing linear scans over an associative array is like 
trying to club someone to death with a loaded Uzi." 
- Larry Wall (creator of Perl) 

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

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

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

Re: TNS Listener service question

[Jonathan Gennick]

If I understand you correctly, you are shutting down a
listener on your NT box, and then, from your NT box, you are
connecting to a remote database using SQL*Plus. Am I
understanding you correctly?

You shouldn't need to have a listener running on your NT box
to connect to a remote database, so that fact that SQL*Plus
can connect doesn't surprise me. I don't understand why your
GUI tools wouldn't connect, though I may also be
misunderstanding your original note.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com

Wednesday, November 21, 2001, 10:05:20 AM, you wrote:
BPJ> I noticed that if I leave the TNS Listener service stopped on my NT
BPJ> workstation, I can't access anything using the GUI tools.

BPJ> But my script that runs command line can successfully login to the remote
BPJ> databases to verify that they are accessible.  It uses
BPJ> c:\oracle\ora81\bin\sqlplus.exe.

BPJ> Do the command-line utilities bypass the NT TNSListener service?

BPJ> Just curious, I am leaving the service up now...

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

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

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

[Jonathan Gennick]

Wednesday, November 21, 2001, 10:56:45 AM, you wrote:
DK> Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75,
DK> 85-86 in particular.

Yeah, but I don't have any experience with the GIOP
presentation. Like Srini pointed out earlier, it allows the
listener to handle the protocol used for CORBA connections.

Now I just have to ask. Is anyone here supporting CORBA
connections in a production environment?

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com

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

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

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

[Jared Still]

Yes, Oracle actually calls it an upgrade.

I think the point everyone wanted to make though was
it's not a good idea to just start your database
with the 8.1 binaries.

Jared

On Wednesday 21 November 2001 16:40, Jeremiah Wilton wrote:
> Correct me if I am wrong, but you don't migrate from 8.0 to 8.1.  You
> just start up on the new binaries and run u080005.sql or something.
> The migration utility is for 7.x to 8.x.  Read the manual.
> Re-creating the database, then exporting and importing will take much
> longer than just running a couple scripts.
>
> If it is reverting that you are worried about, take an online backup
> before you upgrade.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Wed, 21 Nov 2001, Barbara Baker wrote:
> > If you track down the 8i migration manual, here's a comparison chart that
> > shows the benefits of export/import versus migration (using the u
> > scripts).
> >
> > It depends on your database configuration, but yes, the main benefit in
> > using migration is speed.  If your database is relatively small, exp/imp
> > should be no problem.  If it's large, the difference betwen exp/imp and
> > migration will be significant.
> >
> > >From: "Ed" <[EMAIL PROTECTED]>
> > >
> > >Yes, I agree 100%, but people here are concerned that upgrading will
> > >"break"
> > >the database, and we have to QUICKLY move everything over to 8.1.6.
> > > (Long story).  What I was really after in my original question was: why
> > > is the upgrade script a better solution than just recreating the
> > > tablespaces in 8.1.6 and importing from an export of the old database? 
> > > Does it just save time?  Is there a downside to using export/import
> > > this way?
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

RE: Upgrade 8.0.5 to 8.1.6

[Barbara Baker]

Ed:
If you choose to upgrade your database from 8.0.5 to 8.1.6, there's a 
potential difficulty you need to know about.

If you're not aware of the dictionary corruption problem, be sure you read 
the metalink alert (96117.1).  This has something to do with block checking 
enabled in 8.1.6   Essentially, you need to analyze all your system tables 
to insure no corruption has been introduced.

If you have any problem finding the info on metalink, take a look at the Tim 
Gorman's web site (www.evdbt.com).  He has some info about it under 
"downloads".

Barb




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

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

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

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

Re: OT: X Win client

[C.S.Venkata Subramanian]

 Try xwin32 from starnet
--

On Wed, 21 Nov 2001 10:15:25  
 Jared Still wrote:
>
>Yes, Xfree86.
>
>Just do a search on google.  I use it to run Oracle
>installs, so it works well enough.
>
>Jared
>
>On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
>> Hi all!
>>
>> Is there any free (important: free) X client software for NT?
>>
>> Regards,
>> Vladimir Barac
>
>
>Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
>Content-Transfer-Encoding: quoted-printable
>Content-Description: 
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Jared Still
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>


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

RE: Upgrade 8.0.5 to 8.1.6

[Jeremiah Wilton]

Correct me if I am wrong, but you don't migrate from 8.0 to 8.1.  You
just start up on the new binaries and run u080005.sql or something.
The migration utility is for 7.x to 8.x.  Read the manual.
Re-creating the database, then exporting and importing will take much
longer than just running a couple scripts.

If it is reverting that you are worried about, take an online backup
before you upgrade.

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

On Wed, 21 Nov 2001, Barbara Baker wrote:

> If you track down the 8i migration manual, here's a comparison chart that
> shows the benefits of export/import versus migration (using the u
> scripts).
>
> It depends on your database configuration, but yes, the main benefit in
> using migration is speed.  If your database is relatively small, exp/imp
> should be no problem.  If it's large, the difference betwen exp/imp and
> migration will be significant.
>
> >From: "Ed" <[EMAIL PROTECTED]>
> >
> >Yes, I agree 100%, but people here are concerned that upgrading will
> >"break"
> >the database, and we have to QUICKLY move everything over to 8.1.6. (Long
> >story).  What I was really after in my original question was: why is the
> >upgrade script a better solution than just recreating the tablespaces in
> >8.1.6 and importing from an export of the old database?  Does it just save
> >time?  Is there a downside to using export/import this way?

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

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

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

RE: Upgrade 8.0.5 to 8.1.6

[Ed]

Thanks all.

Ed


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

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

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

Re: ftp tools

[Bill Conner]

At 02:10 PM 11/21/2001 -0800, you wrote:
>not free, but ipswitch's ftp is nice and cheap ~$400.
>very easy to admin.
>
>http://www.ipswitch.com/

www.cuteftp.com   only $35


>gene
>
> >>> [EMAIL PROTECTED] 11/21/01 16:55 PM >>>
>Does anyone know a site where one can get a FREE gui ftp tool?
>
>Thanks,
>Terry
>
>Terry Ball, DBA
>Birch Telecom
>Work: 816-300-1335
>FAX:  816-300-1801
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ball, Terry
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Gene Sais
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Bill Conner
  INET: [EMAIL PROTECTED]

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

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

[Barbara Baker]

Ed:
If you track down the 8i migration manual, here's a comparison chart that 
shows the benefits of export/import versus migration (using the u 
scripts).

It depends on your database configuration, but yes, the main benefit in 
using migration is speed.  If your database is relatively small, exp/imp 
should be no problem.  If it's large, the difference betwen exp/imp and 
migration will be significant.

HTH.

Barb


>From: "Ed" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: Upgrade 8.0.5 to 8.1.6
>Date: Wed, 21 Nov 2001 13:15:20 -0800
>
>Yes, I agree 100%, but people here are concerned that upgrading will 
>"break"
>the database, and we have to QUICKLY move everything over to 8.1.6. (Long
>story).  What I was really after in my original question was: why is the
>upgrade script a better solution than just recreating the tablespaces in
>8.1.6 and importing from an export of the old database?  Does it just save
>time?  Is there a downside to using export/import this way?
>
>Best!
>
>Ed
>
>-Original Message-
>Thapliyal
>Sent: Wednesday, November 21, 2001 12:20 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Ed,
>
>the whole point of compatable is to mimick behaviour
>of an older release .. like optimizer plans etc.
>upgrading the db would be the way to go for this..
>like many have already pointed out
>
>Deepak
>
>--- Ed <[EMAIL PROTECTED]> wrote:
> > A DBA here is trying to upgrade several 8.0.5
> > databases to 8.1.6
> > by using export/import.  This will probably work,
> > but wouldn't it be
> > easier to just do a cold backup and open them using
> > the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is
> > there
> > any downside to using export/import? (ie. will it
> > affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible
> > parameter was that
> > it let you open up an older database with no
> > questions asked.
> > Then you could run any of the upgrade .sql scripts
> > at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
>__
>Do You Yahoo!?
>Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
>http://geocities.yahoo.com/ps/info1
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Deepak Thapliyal
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ed
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

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

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

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

RE: ftp tools

[Jamadagni, Rajendra]

If you are using TOAD, there is one in there ...

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

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



*1

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

*1

RE: Upgrade 8.0.5 to 8.1.6

[Deepak Thapliyal]

Yes it will save time as well ..all the upgrade does
is mess the datafile headers so they are 816 format 
also the upgrade script will simply re-initialze the
catalog to 816 is also quite fast and will complete in
a few minutes .. 

if you have a 1TB db for e.g. upgrade would definitely
be a far more faster option .. 

as for upgrade breaking your db .. more chances that
your approach of only setting the compatable flag
might in turn lead to software corruption in the long
run if not immediately .. thing change with ever
release .. and when its oracle .. this REALLY change a
lot .. and hence they recommend the upgrade path .. 

however if your db is small .. then maybe creating an
an 817 db and creating tablespaces and then exp-imp
way will work as well .. 

Deepak


--- Ed <[EMAIL PROTECTED]> wrote:
> Yes, I agree 100%, but people here are concerned
> that upgrading will "break"
> the database, and we have to QUICKLY move everything
> over to 8.1.6. (Long
> story).  What I was really after in my original
> question was: why is the
> upgrade script a better solution than just
> recreating the tablespaces in
> 8.1.6 and importing from an export of the old
> database?  Does it just save
> time?  Is there a downside to using export/import
> this way?
> 
> Best!
> 
> Ed
> 
> -Original Message-
> Thapliyal
> Sent: Wednesday, November 21, 2001 12:20 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Ed,
> 
> the whole point of compatable is to mimick behaviour
> of an older release .. like optimizer plans etc.
> upgrading the db would be the way to go for this..
> like many have already pointed out
> 
> Deepak
> 
> --- Ed <[EMAIL PROTECTED]> wrote:
> > A DBA here is trying to upgrade several 8.0.5
> > databases to 8.1.6
> > by using export/import.  This will probably work,
> > but wouldn't it be
> > easier to just do a cold backup and open them
> using
> > the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is
> > there
> > any downside to using export/import? (ie. will it
> > affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible
> > parameter was that
> > it let you open up an older database with no
> > questions asked.
> > Then you could run any of the upgrade .sql scripts
> > at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051 
> FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
> 
> 
> __
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting,
> just $8.95/month.
> http://geocities.yahoo.com/ps/info1
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Deepak Thapliyal
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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

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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San

RE: Upgrade 8.0.5 to 8.1.6

[Kent Wayson]

When I did this, the migration assistant was much quicker than export/import.


Kent


>Yes, I agree 100%, but people here are concerned that upgrading will "break"
>the database, and we have to QUICKLY move everything over to 8.1.6. (Long
>story).  What I was really after in my original question was: why is the
>upgrade script a better solution than just recreating the tablespaces in
>8.1.6 and importing from an export of the old database?  Does it just save
>time?  Is there a downside to using export/import this way?
>
>Best!
>
>Ed
>
>-Original Message-
>Thapliyal
>Sent: Wednesday, November 21, 2001 12:20 PM
>To: Multiple recipients of list ORACLE-L
>
>
>Ed,
>
>the whole point of compatable is to mimick behaviour
>of an older release .. like optimizer plans etc.
>upgrading the db would be the way to go for this..
>like many have already pointed out
>
>Deepak
>
>--- Ed <[EMAIL PROTECTED]> wrote:
>> A DBA here is trying to upgrade several 8.0.5
>> databases to 8.1.6
>> by using export/import.  This will probably work,
>> but wouldn't it be
>> easier to just do a cold backup and open them using
>> the
>> COMPATIBLE parameter in the 8.1.6 environment?  Is
>> there
>> any downside to using export/import? (ie. will it
>> affect snapshots,
>> db links, etc...).
>>
>> I thought the whole point of the compatible
>> parameter was that
>> it let you open up an older database with no
>> questions asked.
>> Then you could run any of the upgrade .sql scripts
>> at your leisure,
>> yes?
>>
>> Best,
>>
>> Ed
>>
>>
>> --
>> Please see the official ORACLE-L FAQ:
>> http://www.orafaq.com
>> --
>> Author: Ed
>>   INET: [EMAIL PROTECTED]
>>
>> Fat City Network Services-- (858) 538-5051  FAX:
>> (858) 538-5051
>> San Diego, California-- Public Internet
>> access / Mailing Lists
>>
>
>> To REMOVE yourself from this mailing list, send an
>> E-Mail message
>> to: [EMAIL PROTECTED] (note EXACT spelling of
>> 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB
>> ORACLE-L
>> (or the name of mailing list you want to be removed
>> from).  You may
>> also send the HELP command for other information
>> (like subscribing).
>
>
>__
>Do You Yahoo!?
>Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
>http://geocities.yahoo.com/ps/info1
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Deepak Thapliyal
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: Ed
>  INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kent Wayson
  INET: [EMAIL PROTECTED]

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

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

Re: ftp tools

[Gene Sais]

not free, but ipswitch's ftp is nice and cheap ~$400.
very easy to admin.

http://www.ipswitch.com/

gene

>>> [EMAIL PROTECTED] 11/21/01 16:55 PM >>>
Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

ORA-4031 error on one instance but not on other

[Jamadagni, Rajendra]

Hi all,

I have two 9i instances, one of them consistently produces following error,
whereas other doesn't.

SQLException:61000java.sql.SQLException: ORA-04031: unable to allocate
1028736 bytes of shared memory ("shared pool","unknown object","hash-join
subh","kllcqc:kllcqslt") ORA-06512: at "ESPN.INTRANETGAMEINFO", line 412
ORA-06512: at line 1 

I have searched and searched Metalink for this error and its parameters, but
no clues.  This procedure is called from a jdbc client, it is a jsp, which
uses a servlet, which calls a pl/sql package. We identified what portion is
causing the problem, it is a cursor loop. If there are now rows returned by
the cursor, no problem, it works fine. But other wise this error is
returned. The max number of rows returned is about 40, the row size is
pretty small too. One more thing, in the cursor loop user is populating a
varray.

The large pool is set to 0, SGA has enough free space available.
Any ideas are greatly appreciated.
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

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




*1

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

*1

RE: ftp tools

[Suhen Pather]

Terry,

WS_FTP is a freeware

Check www.tucows.com

Regards
Suhen

Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

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

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

[Jared Still]

Ed, 

If your databases are more than a couple of gig, 
upgrading is faster.

If over 10 gig, don't even think about importing it.

Jared

On Wednesday 21 November 2001 13:15, Ed wrote:
> Yes, I agree 100%, but people here are concerned that upgrading will
> "break" the database, and we have to QUICKLY move everything over to 8.1.6.
> (Long story).  What I was really after in my original question was: why is
> the upgrade script a better solution than just recreating the tablespaces
> in 8.1.6 and importing from an export of the old database?  Does it just
> save time?  Is there a downside to using export/import this way?
>
> Best!
>
> Ed
>
> -Original Message-
> Thapliyal
> Sent: Wednesday, November 21, 2001 12:20 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Ed,
>
> the whole point of compatable is to mimick behaviour
> of an older release .. like optimizer plans etc.
> upgrading the db would be the way to go for this..
> like many have already pointed out
>
> Deepak
>
> --- Ed <[EMAIL PROTECTED]> wrote:
> > A DBA here is trying to upgrade several 8.0.5
> > databases to 8.1.6
> > by using export/import.  This will probably work,
> > but wouldn't it be
> > easier to just do a cold backup and open them using
> > the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is
> > there
> > any downside to using export/import? (ie. will it
> > affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible
> > parameter was that
> > it let you open up an older database with no
> > questions asked.
> > Then you could run any of the upgrade .sql scripts
> > at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX:
> > (858) 538-5051
> > San Diego, California-- Public Internet
> > access / Mailing Lists
>
> 
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from).  You may
> > also send the HELP command for other information
> > (like subscribing).
>
> __
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> http://geocities.yahoo.com/ps/info1
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deepak Thapliyal
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

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

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

Re: ftp tools

[Deepak Thapliyal]

Terry, check out www.vandyke.com ..

Deepak

PS: more so check out google.com .. ;)

--- "Ball, Terry" <[EMAIL PROTECTED]> wrote:
> Does anyone know a site where one can get a FREE gui
> ftp tool?
> 
> Thanks,
> Terry
> 
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX:  816-300-1801
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ball, Terry
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re: ftp tools

[Bill Conner]

At 01:10 PM 11/21/2001 -0800, you wrote:
>Does anyone know a site where one can get a FREE gui ftp tool?


Sorry it is http://www.jgaa.com.


How about warftp   i think that it is www.warftp.com.


>Thanks,
>Terry
>
>Terry Ball, DBA
>Birch Telecom
>Work: 816-300-1335
>FAX:  816-300-1801
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ball, Terry
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Bill Conner
  INET: [EMAIL PROTECTED]

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

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

Re: ftp tools

[Bill Conner]

At 01:10 PM 11/21/2001 -0800, you wrote:
>Does anyone know a site where one can get a FREE gui ftp tool?

How about warftp   i think that it is www.warftp.com.


>Thanks,
>Terry
>
>Terry Ball, DBA
>Birch Telecom
>Work: 816-300-1335
>FAX:  816-300-1801
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ball, Terry
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(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: Bill Conner
  INET: [EMAIL PROTECTED]

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

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

[Ed]

Yes, I agree 100%, but people here are concerned that upgrading will "break"
the database, and we have to QUICKLY move everything over to 8.1.6. (Long
story).  What I was really after in my original question was: why is the
upgrade script a better solution than just recreating the tablespaces in
8.1.6 and importing from an export of the old database?  Does it just save
time?  Is there a downside to using export/import this way?

Best!

Ed

-Original Message-
Thapliyal
Sent: Wednesday, November 21, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L


Ed,

the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out

Deepak

--- Ed <[EMAIL PROTECTED]> wrote:
> A DBA here is trying to upgrade several 8.0.5
> databases to 8.1.6
> by using export/import.  This will probably work,
> but wouldn't it be
> easier to just do a cold backup and open them using
> the
> COMPATIBLE parameter in the 8.1.6 environment?  Is
> there
> any downside to using export/import? (ie. will it
> affect snapshots,
> db links, etc...).
>
> I thought the whole point of the compatible
> parameter was that
> it let you open up an older database with no
> questions asked.
> Then you could run any of the upgrade .sql scripts
> at your leisure,
> yes?
>
> Best,
>
> Ed
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ed
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

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

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

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

ftp tools

[Ball, Terry]

Does anyone know a site where one can get a FREE gui ftp tool?

Thanks,
Terry

Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX:  816-300-1801

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

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

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

[Miller, Jay]

The only problem with this technique is that you won't reclaim the space in
the first tablespace that used to be used by the indexes (since the high
water marke will be set).  If this isn't an issue (either lots of storage
space or the data is expected to grow enough to use this space) then I agree
this is the better option.

Jay Miller

-Original Message-
Sent: Wednesday, November 21, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L


Sorry forgot the command in my earlier email

To recap, here are the steps

1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
  alter index . rebuild online tablespace 
;


>From: Ken Janusz <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Fixing a DB
>Date: Wed, 21 Nov 2001 05:25:34 -0800
>
>We have a DB that is currently in more-or-less development mode for a state
>government client.  The DB has been created (11,300 lines of SQL*Plus code)
>with the tables and indexes stored in the permanent tablespace
>(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
>currently holds test data.  I think the process to correct this would be:
>
>1. Determine the size, etc. of the INDEX tablespace, write the script and
>then run it to create the tablespace.
>
>2. Go through the DDL SQL script for OKSOS (state gov. office name
>abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
>tablespace name.
>
>3. Then run the DDL SQL script to create the new DB.
>
>4. Then do and Export of the data from the old DB and Import it into the 
>new
>DB.
>
>5. Then I think I have to regenerate your indexes.  I'm not clear on this
>point. Will the Export/Import process may take care of this?
>
>Is there anything I have missed?  I'm sure there is.
>
>Thanks,
>
>Ken Janusz, CPIM
>Database Conversion Lead
>Sufficient System, 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).


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

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

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

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

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

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

Discoverer 4i FYI

[Seley, Linda]

For those of us struggling with 9iAS and Discoverer  If you've been
using the note (131662.1) to manually install Discoverer 3i or 4i this
note has been pulled from Metalink.  Apparently, if you're lucky the
manual install works.  If you're not lucky you end up with a mess.  All
Discoverer installs should now happen through the 9iAS installer (you
have to have a compatible emulator with pseudo color set correctly).  

Getting the install to work through 9iAS has cleared up my problems with
Viewer not working and accessing both Viewer and Plus from the internet
(on a single network card machine, still working on the multiple network
card install).  Apparently some people are unable to patch Discoverer
after running the manual install as well.

Hope that helps somebody!

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

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

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

Re: OT: X Win client

[Bill Conner]

At 10:15 AM 11/21/2001 -0800, you wrote:

>Yes, Xfree86.

www.cygwin.com


>Just do a search on google.  I use it to run Oracle
>installs, so it works well enough.
>
>Jared
>
>On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
> > Hi all!
> >
> > Is there any free (important: free) X client software for NT?
> >
> > Regards,
> > Vladimir Barac
>
>
>Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
>Content-Transfer-Encoding: quoted-printable
>Content-Description:
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
>San Diego, California-- Public Internet access / Mailing Lists
>
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).


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

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

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

RE: Problem Running DDL SQL Script

[Koivu, Lisa]

Title: RE: Problem Running DDL SQL Script





The larger question is, why are you creating tables as system?


-Original Message-
From:   Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Subject:    Problem Running DDL SQL Script


I have this script that will generate a DB with a number of create table and
create index statements.  When I try to run it in SQL*Plus I get this error:


ORA-00959 tablespace SOS2_TBLSPC does not exist.  
ORA-00942 table or view doesn't exist


Here is a sample of one of the create statements:


DROP TABLE ACCESS_RIGHT CASCADE CONSTRAINTS ; 


CREATE TABLE ACCESS_RIGHT ( 
  ACCESS_RIGHT_ID  NUMBER    NOT NULL, 
  GROUP_ID NUMBER    NOT NULL, 
  MODULE_ID    NUMBER    NOT NULL, 
  CONSTRAINT PK_AR_ALL
  PRIMARY KEY ( ACCESS_RIGHT_ID, GROUP_ID, MODULE_ID ) 
    USING INDEX 
 TABLESPACE SOS2_TBLSPC PCTFREE 10
 STORAGE ( INITIAL 120K NEXT 104K PCTINCREASE 0 ))
   TABLESPACE SOS2_TBLSPC NOLOGGING 
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 30720
   NEXT 8192
   MINEXTENTS 1
   MAXEXTENTS 505
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 


When I check the DB this tablespace exists and is online.  I'm logged in as
system/manager.  The environment is W2000/8.1.7.


Any idea what the problem is?


Thanks,


Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, 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).

RE: Oracle and MQ

[Aponte, Tony]

Title: RE: Oracle and MQ



The VB 
programs have data validation and standard error trapping for exceptions 
returned by the MQ API calls.  As for your question about 
accessing external procs, MQ provides the API to make calls from C which 
you can certainly use to code the external routines.  Another possibility 
is to use the MQ Java API to code Java stored procs.  Then you won't have 
to handle the listener issues related to external procs and other server 
dependencies.  That's what we would implement if the MQ management 
responsibilities are ever transferred to us in the DBA 
group.
 
Tony 
Aponte
 
 
 -Original Message-From: 
YTTRI Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 21, 
2001 10:59 AMTo: Aponte, Tony; 
'[EMAIL PROTECTED]'Subject: RE: Oracle and 
MQ

  Tony 
  - 
   
  Do 
  you have error handling built in to your VB program, or do you just load it 
  into Oracle and then cleanse/validate the data there?
   
  Do 
  you think it would also be possible to access MQ via external stored 
  procedures?
  
-Original Message-From: Aponte, Tony 
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 20, 2001 4:02 
PMTo: [EMAIL PROTECTED]Cc: 
[EMAIL PROTECTED]Subject: RE: Oracle and MQ
I believe Oracle sells an MQ-to-AQ bridge that just moves 
messages between queuing systems.  We use VB to pull messages out of MQ 
and issue SQL to get it into the database.
HTH Tony Aponte 
-Original Message- From: 
YTTRI Lisa [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, November 20, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Subject: OT: Oracle and MQ 
Hi - 
Does anyone have experience with using MQ w/Oracle.  We 
have an application that is using MQ to get data 
from the mainframe into Oracle.  We are trying to determine what our options are for retrieving the data from the 
MQ queues. 
We know one option is to write a Pro*C program to handle 
this, but this means creating all our own error 
logic, etc.  Does AQ fit into this scenario at 
all, or is that primarily for non-middleware queues? 
Any information / insight would be greatly 
appreciated. 
Thanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI  Lisa   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet 
access / Mailing Lists  
To REMOVE yourself from this mailing list, send an E-Mail 
message to: [EMAIL PROTECTED] (note EXACT 
spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (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 8.0.5 to 8.1.6

[Mercadante, Thomas F]

I agree with you Kevin.  This is a recipe for disaster.

While the db may run ok, I can only imagine the recovery nightmare that
*will* occur when  something is eventually lost.  And try calling Oracle
Support with *this* scenario - we will be reading about it under "stupid
upgrade tricks" someplace.

Ed, the migration scripts for moving from 8.0.5 to 8.1.6 run in less than an
hour.  Why do you not want to move your db to 816?

I would *never* do what you are suggesting.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, November 21, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L


I would not do that.   Those migrate scripts change the catalog tables to
support the 8.1.6 engine and do other things.   I would never consider
upgrading a system without doing that step.

-Original Message-
Sent: Wednesday, November 21, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


That's exactly what I was saying I think.  ie. To quickly move 8.0.5 to
8.1.6, set compatible and everything should run without doing anything else
(including the u*.sql script).  You can run migration later if you need
new features of 8.1.6.

Reasonable statement?

Best,

Ed

-Original Message-
Sent: Wednesday, November 21, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment."

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>

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

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

Re: Upgrade 8.0.5 to 8.1.6

[Deepak Thapliyal]

Ed,

the whole point of compatable is to mimick behaviour
of an older release .. like optimizer plans etc.
upgrading the db would be the way to go for this..
like many have already pointed out

Deepak

--- Ed <[EMAIL PROTECTED]> wrote:
> A DBA here is trying to upgrade several 8.0.5
> databases to 8.1.6
> by using export/import.  This will probably work,
> but wouldn't it be
> easier to just do a cold backup and open them using
> the
> COMPATIBLE parameter in the 8.1.6 environment?  Is
> there
> any downside to using export/import? (ie. will it
> affect snapshots,
> db links, etc...).  
> 
> I thought the whole point of the compatible
> parameter was that
> it let you open up an older database with no
> questions asked.
> Then you could run any of the upgrade .sql scripts
> at your leisure,
> yes?
> 
> Best,
> 
> Ed
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Ed
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

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


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

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

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

Re: Fwd: A problem

[Scott Shafer]

Try sumthin' like:

EDATE=$(date +%C%y%m%d)
FILENAME=name${EDATE}.dmp

exp / file=${FILENAME} ...

Do a 'man date' to see the different formatting options.

HTH,

Scott Shafer
San Antonio, TX


Jared Still wrote:
> 
> --  Forwarded Message  --
> Date: Wed, 21 Nov 2001 15:34:27 +0100
> 
> I have created a job to export a user shema
> How can I tell Oracle each time it make the export to use lets say
> .dmp
> I mean for example if today is 21.11.2001
> the exported file whoud have name21112001.dmp or something like this...

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

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

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

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

[dgoulet]

In many a case on the list we don't have the information to fill in to all sql
statements, like in this case the name of the tablespace.  The common way to
indicate that is to frame the variable with a set or '<>' brackets.  What you
need to do is replace the '' with the rean tablespace name, in
your case, from previous posts:

drop tablespace core including contents;


BTW: you should be able to simply startup your database by now.  Tablespace core
should be offline.

Dick Goulet

Reply Separator
Author: Moucka otakar <[EMAIL PROTECTED]>
Date:   11/21/2001 10:10 AM

I have next problem , syntax its ok.

SQL> Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace  including content;
ORACLE instance started.
 
Total System Global Area  178213024 bytes
Fixed Size73888 bytes
Variable Size 161189888 bytes
Database Buffers   16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SQL>
Database altered.
 
SQL>
Database altered.
 
SQL> drop tablespace  including content
*
ERROR at line 1:
ORA-02216: tablespace name expected



Dne st 21. listopad 2001 17:03 jste napsal(a):
> Jaysus, note the date and time. It's a freaking miracle.
>
> ;-)
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 10:54 AM
> To: Mohan; Ross; Multiple recipients of list ORACLE-L
>
>
> OOPS! sorry, your right
>
> Reply Separator
> Author: "Mohan; Ross" <[EMAIL PROTECTED]>
> Date:   11/21/2001 7:40 AM
>
> "cascade"?  probably more abject ignorance on my part, but wasn't it
> "including contents"?
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 10:15 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Startup mount
> alter database datafile '/data/db/database/core.dbf' offline drop;
> alter database open;
> drop tablespace  cascade;
>
>
> Dick Goulet
>
> Reply Separator
> Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
> Date:   11/21/2001 5:40 AM
>
>  Hello
> I need a help with one problem. In the Oracle version 8.1.7 I've deleted
> a "tablespace" in the Linux, but before this I did't use a function "
> Drop".
>  After reboot a database, there was a error:
> ERROR at line 1:
> ORA-01116: error in opening database file 7
> ORA-01110: data file 7: '/data/db/database/core.dbf'
> ORA-27041: unable to open file
> Linux Error: 2: No such file or directory
> Additional information: 3
> Is there a some re-step to drop "tablespace" and then regulary delete
> this object and restart the database ?
>   Thanx a lot for your answer.
>
> Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Moucka otakar
  INET: [EMAIL PROTECTED]

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

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

[Jared Still]

Yes, Xfree86.

Just do a search on google.  I use it to run Oracle
installs, so it works well enough.

Jared

On Wednesday 21 November 2001 01:40, Vladimir Barac - posao wrote:
> Hi all!
>
> Is there any free (important: free) X client software for NT?
>
> Regards,
> Vladimir Barac


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

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

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

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

RE: Odd Listener.ora Stanza

[Mohan, Ross]

"For all this means to me I might as well post it on the OT list."

LOL!!!  yeait makes sense, at least in terms of all of
the acronyms being internally self-consistent.

Yours in Inflating Acronyms, 

Ross 

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 11/21/2001 11:05 AM

Ross,

fecality? Is that the F in RTFM? Well, things are pretty slow here (who
am I
kidding. They have been, no wait. It has been pretty slow here for
months)
so I grabbed my Net8 book. Not that this makes a lot of sense, but this
is
what it says.

PRESENTATIONIdentifies the presentation layer
Default TTC
Values  TTC|GIOP

TTC Two-task Common
GIOP IIOP clients require GIOP. It is an alias
for
either oracle.aurora.server.SGiopServer or
 oracle.aurora.server.GiopServer using
TCP/IP or
TCP/IP with SSL

SESSION Identifies the session layer (oh)
Default NS
Values  NS|RAW

IIOP clients require no session layer (RAW)
Typical Net8 clients use a session layer of
Transparent Network Substrate (TNS) Network Session (NS).

For all this means to me I might as well post it on the OT list.

HB

Henry



-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the "newfangled" features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

[John Kanagaraj]

Matt,
 
I installed the whole HTML/PDF set of manuals that comes with the 11i CD Set
onto my laptop. This then provides an indexed version of the manuals in PDF
from a HTML page. FWIW, I am also one of those who recently (just about >1
year) 'migrated' from a normal DBA to doing Apps stuff, and those manuals
are invaluable (if not a bother to digest all in one go).
 
Have a nice holiday everyone - and safe driving/travelling!
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Kill your killer-commute! Listen to great commercial-free christian music
24x7 (details at www.klove.com)

** The opinions and statements above are entirely my own and not
those of my employer or clients **


-Original Message-
Sent: Wednesday, November 21, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L



I looked in metalink and maybe I'm just blind, 
but I don't find a 'Maintaining Oracle 
Applications' manual. 

URLs would be greatly apprecieated. 

 
Matt Adams - GE Appliances - [EMAIL PROTECTED] 
"Doing linear scans over an associative array is like 
trying to club someone to death with a loaded Uzi." 
- Larry Wall (creator of Perl) 

> -Original Message- 
> From: John Kanagaraj [ mailto:[EMAIL PROTECTED]
 ] 
> Sent: Tuesday, November 20, 2001 7:45 PM 
> To: Multiple recipients of list ORACLE-L 
> Subject: RE: applying patch 2032040 to Oracle Purchasing 
> 
> 
> Matt, 
>  
> I think you should get to read the 'Maintaining Oracle 
> Applications' manual 
> - all the ad utilities are described therein. My 
> understanding is that the 
> install progress is recorded in the FND_INSTALL table and a 
> restart will 
> look up this and decipher what else needs to be done. As far 
> as your error 
> goes, the solution is to open an iTar and sit back until you 
> get called... 
> As I said before, Patching is the bane of an Apps DBA! 
>  
> John Kanagaraj 
> Oracle Applications DBA 
> DBSoft Inc 
> (W): 408-970-7002 
> 
> Kill your killer-commute! Listen to great commercial-free 
> christian music 
> 24x7 (details at www.klove.com) 
> 
> ** The opinions and statements above are entirely my own and not 
> those of my employer or clients ** 
> 
> 
> -Original Message- 
> Sent: Tuesday, November 20, 2001 6:00 AM 
> To: Multiple recipients of list ORACLE-L 
> 
> 
> 
> After applying the c.drv portion of the patch, 
> I'm attempting to apply the d.drv portion of patch 
> the patch above and adwork1 is failing applying the d.drv file. 
> 
> In the adwork1.log file I see, 
> jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail 
> -thin -user "USERNAME/PASSSWORD@host:port:SID" 
> /opt/oracle/testappl/admin/test/out/p01ldjva.jar 
> 
> followed by a ton of 
> ORA-03115 unsupported network/data/type or representation 
> and 
> ORA-29509 incorrectly formed Java binary class definition 
> errors. 
> 
> I suspect that the file 
> /opt/oracle/testappl/admin/test/out/p01ldjva.jar 
> was taken from new xmlparserv2.zip file that is present in 
> the patch. 
> 
> Being the relative newcomer at this, my question is 
> what do I do now?  It's already got part way through 
> applying the d.drv file, which means (if i understand this 
> correctly) that I cannot un-patch.  I have to recover from the 
> backup.  What can I do to try to move this forward rather 
> than recovering and starting over? 
> 
>  
> Matt Adams - GE Appliances - [EMAIL PROTECTED] 
> "Doing linear scans over an associative array is like 
> trying to club someone to death with a loaded Uzi." 
> - Larry Wall (creator of Perl) 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
> -- 
> Author: John Kanagaraj 
>   INET: [EMAIL PROTECTED] 
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051 
> San Diego, California-- Public Internet access / Mailing Lists 
>  
> To REMOVE yourself from this mailing list, send an E-Mail message 
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
> the message BODY, include a line containing: UNSUB ORACLE-L 
> (or the name of mailing list you want to be removed from).  You may 
> also send the HELP command for other information (like subscribing). 
> 

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

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

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

Re: Fwd: A problem

[Dias Costa]

Hi !


May be this will help you (I hope).
This solution is for Windows (X) but 
with some work it will do also in UNIX.



A procedure called BackupOSC is created by 
the DBA in his schema.
A job is created with at command, invoking
the batch command file backup_OSC.cmd wich 
in turn calls SQLPLUSW to run the above procedure.
The outcome is a batch command file called exp_OSC.cmd
wich is invoked by the firts batch file to perform the
real export.

The "secret" is to use the SQL to create the second file
since DOS hasn't the ability to handle strings.


Hope it helps.
Dias Costa


P.S.:   The files are attached.
The file exp_Ora.ftp is a parameter file for 
to FTP the DMP files to other machine.
If you find some strange words in the files,
they are Portuguese.











Jared Still wrote:
> 
> --  Forwarded Message  --
> Date: Wed, 21 Nov 2001 15:34:27 +0100
> 
> I have created a job to export a user shema
> How can I tell Oracle each time it make the export to use lets say
> .dmp
> I mean for example if today is 21.11.2001
> the exported file whoud have name21112001.dmp or something like this...
> 
> ---
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


exp_OSC.cmd
Description: application/unknown-content-type-cmdfile

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact [EMAIL PROTECTED] for clarification.


--  file: backupSmartUser.sql
--  -
set linesize 300
set echo on
set feed off
set serveroutput on size 1
set sqlprompt 'REM '
spool D:\Export_Oracle\exp_OSC.cmd
execute system.BackupOSC;
spool off
exit



--  file: cp_BackupOSC.sql
--  --
--
--  procedure invoked for the backup of schema: OSC
--
--
create or replace procedure BackupOSC as
--
   Linha0 varchar2 (20);
   Linha1 varchar2 (100);
   Linha2 varchar2 (200);
   Linha3 varchar2 (30);
   Linha4 varchar2 (40);
   Linha5 varchar2 (250);
   Linha6 varchar2 (250);
   Linha7 varchar2 (10);

begin
Linha0 := 'ECHO ON';
--
SELECT   'ECHO 
 ' 
into  Linha1
FROM  DUAL;
-- 
SELECT   'ECHO Backing up the OSC user (Instance DC8i)  done on: ' || 
TO_CHAR(SYSDATE,'/MM/DD') || ' starting time ' || TO_CHAR(SYSDATE,'hh:mm:ss') 
into  Linha2
FROM  DUAL;
--
Linha3 := 'SET ORACLE_SID=DC8i';
Linha4 := 'SET ORACLE_HOME=E:\ORACLE\ORA81';
--
SELECT   'exp USERID=system/manager owner=OSC FILE=d:\Export_Oracle\OSC_' || 
TO_CHAR(SYSDATE,'MMDD_HHMI') || ' LOG=d:\Export_Oracle\OSC_' || 
TO_CHAR(SYSDATE,'MMDD_HHMI') || ' BUFFER=40 COMPRESS=y' 
into  Linha5
FROM  DUAL;
--
SELECT   'ECHO Backup finished: ' || TO_CHAR(SYSDATE,'hh:mi:ss') || ' >> 
d:\Export_Oracle\OSC_backups.log' 
into  Linha6
FROM  DUAL;
--
Linha7 := 'EXIT';
--
dbms_output.put_line(linha0);
dbms_output.put_line(linha1);
dbms_output.put_line(linha2);
--dbms_output.put_line(Linha3); not needed
--dbms_output.put_line(Linha4); not needed
dbms_output.put_line(linha5);
dbms_output.put_line(linha6);
--dbms_output.put_line(linha7); will see
end BackupOSC;
/



oracle01
franca4
binary
prompt no
cd /usr/oraexp
mput d:\Export_Oracle\*.DMP
bye




backup_OSC.cmd
Description: application/unknown-content-type-cmdfile

RE: Upgrade 8.0.5 to 8.1.6

[Henry Poras]

You need to move the database to 8.1.6 (upgrade, run catalog et al).
Compatible will just keep certain feature turned off.

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 11:36 AM
To: Multiple recipients of list ORACLE-L


That's exactly what I was saying I think.  ie. To quickly move 8.0.5 to
8.1.6, set compatible and everything should run without doing anything else
(including the u*.sql script).  You can run migration later if you need
new features of 8.1.6.

Reasonable statement?

Best,

Ed

-Original Message-
Sent: Wednesday, November 21, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment."

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>

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

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

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

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

To REMOVE yourself fr

Re: RE:

[Moucka otakar]

I have next problem , syntax its ok.

SQL> Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace  including content;
ORACLE instance started.
 
Total System Global Area  178213024 bytes
Fixed Size73888 bytes
Variable Size 161189888 bytes
Database Buffers   16777216 bytes
Redo Buffers 172032 bytes
Database mounted.
SQL>
Database altered.
 
SQL>
Database altered.
 
SQL> drop tablespace  including content
*
ERROR at line 1:
ORA-02216: tablespace name expected



Dne st 21. listopad 2001 17:03 jste napsal(a):
> Jaysus, note the date and time. It's a freaking miracle.
>
> ;-)
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 10:54 AM
> To: Mohan; Ross; Multiple recipients of list ORACLE-L
>
>
> OOPS! sorry, your right
>
> Reply Separator
> Author: "Mohan; Ross" <[EMAIL PROTECTED]>
> Date:   11/21/2001 7:40 AM
>
> "cascade"?  probably more abject ignorance on my part, but wasn't it
> "including contents"?
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 10:15 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Startup mount
> alter database datafile '/data/db/database/core.dbf' offline drop;
> alter database open;
> drop tablespace  cascade;
>
>
> Dick Goulet
>
> Reply Separator
> Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
> Date:   11/21/2001 5:40 AM
>
>  Hello
> I need a help with one problem. In the Oracle version 8.1.7 I've deleted
> a "tablespace" in the Linux, but before this I did't use a function "
> Drop".
>  After reboot a database, there was a error:
> ERROR at line 1:
> ORA-01116: error in opening database file 7
> ORA-01110: data file 7: '/data/db/database/core.dbf'
> ORA-27041: unable to open file
> Linux Error: 2: No such file or directory
> Additional information: 3
> Is there a some re-step to drop "tablespace" and then regulary delete
> this object and restart the database ?
>   Thanx a lot for your answer.
>
> Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Moucka otakar
  INET: [EMAIL PROTECTED]

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

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

Have a good Thanksgiving--THANKSGIVING_LOAD.SQL

[tday6]

--THANKSGIVING_LOAD.SQL
--T. Day, SAI, 21-NOV-01
--Run on WORLD.UNIVERSE using schema with DEITY role
declare
cursor c_thanksgiving is
  select
PERSON_ID   /* NOT SSN -- generated by sequence generator
(Jared) */
   ,RELATION
   ,CONDITION
  from YOUR.LIFE@WORLD where RELATION is not null;

V_CONDITION   VARCHAR2 := NULL;
--
BEGIN
  For PERSON_ROW in C_thanksgiving  LOOP
V_CONDITION   := NULL;
  BEGIN
IF PERSON_ROW.RELATION = 'FRIEND' THEN
   V_CONDITION := 'CONFIDENCE'
ENDIF;
IF PERSON_ROW.RELATION = 'ENEMY' THEN
   V_CONDITION := 'CONFUSION'
ENDIF;
  UPDATE YOUR.LIFE@WORLD SET CONDITION = V_CONDITION WHERE
PERSON_ID = PERSON_ROW.PERSON_ID;
  END;
COMMIT;
 END LOOP
END;

Does that make it on topic?

-- 
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: Re[2]: Index File Name

[Deshpande, Kirti]

That's precisely what I do..
I have  *_user and _developer role with just what they need.
No more. No less. However, certain developers will have direct access to
tables for coding stored procedures, but those are very limited in number.  
Standard ksh script to add these users to the database, accepting userid,
password, roles etc. So the backup DBA can do this when I am out. 

- Kirti  

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 10:04 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re[2]: Index File Name
> 
> Rachel,
> 
> I create a role called 'developer' in each instance at create time.
> Make it
> look something like resource, but without the unlimited tablespace priv,
> and use
> it in place of resource.  saves a step.
> 
> Dick Goulet
> 
> Reply Separator
> Author: Rachel Carmichael <[EMAIL PROTECTED]>
> Date:   11/21/2001 7:45 AM
> 
> standard create user script for a user who will own objects:
> 
> create user  identifed by 
> default tablespace 
> temporary tablespace 
> quota unlimited on 
> /
> grant connect, resource to 
> /
> revoke unlimited tablespace from 
> /
> 
> 
> I've gotten this drilled into my people's heads... and I check up
> on it :)
> --- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> > Mark Leith wrote:
> > > 
> > > And just to add to that - make sure that the user has the
> > appropriate
> > > privileges on the system, such as CREATE TABLE / INDEX, or the role
> > RESOURCE
> > > or whatever.. :)
> > > 
> > > Just to nitpick :)
> > > 
> > 
> > NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
> > cannot grant it to a role, usually - but Oracle 5 compatibility has
> > its
> > reasons ...). Not that I am paranoid, but the idea of users being
> > able
> > to create their tables in SYSTEM makes me nervous.
> >  I know, someone should tell to the Oracle folks who prepare demo
> > scripts ...
> > -- 
> > Regards,
> > 
> > Stephane Faroult
> > Oriole Corporation
> > Voice:  +44  (0) 7050-696-269 
> > Fax:+44  (0) 7050-696-449 
> > Performance Tools & Free Scripts
> > --
> > http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> > --
> > -- 
> > 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).
> 
> 
> __
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> http://geocities.yahoo.com/ps/info1
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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

RE: Reliable alerting system that is not so costly??

[Kumanan Balasundaram]

Hi,

There is a free monitoring/alerting system with escalation that is commonly
used and is called Netsaint.

We are to try this out.

Thanks to those who responded.
Kumanan



> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: 21 November 2001 15:52
> To:   Kumanan Balasundaram
> Subject:  Re:Reliable alerting system that is not so costly??
> 
> Kumanan,
> 
> Many years ago I wrote a Pro*C program to do the alerting and fixing
> for me.
>  It has grown over the years and become kind of a cornerstone around here.
> If
> your into C programming your welcome to a copy of the source code.
> 
> Dick Goulet
> Oracle Certified 8i DBA
> 
> Reply Separator
> Subject:Reliable alerting system that is not so costly??
> Author: Kumanan Balasundaram <[EMAIL PROTECTED]>
> Date:   11/21/2001 3:50 AM
> 
> Hi  there,
> 
> Any of you using or have come across a reliable alert system that can also
> escalate 
> to different persons based on criteria such as how important that system
> is?
> 
> We are looking to invest in such a software.
> 
> Kumanan Balasundaram
> Database Administrator, IT
> QXL ricardo plc
> www.qxl.com
> P: +44 (0)208 962 7409
> 
> > QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge
> Road,
> > London W6 9EJ
> > Registered in England No 3430894 VAT number - GB 701 8915 43
> > 
> > The information transmitted is intended only for the person or entity to
> > which it is addressed and may contain confidential and/or privileged
> > material.  Any review, retransmission, dissemination or other use of, or
> > taking of any action in reliance upon, this information by persons or
> > entities other than the intended recipient is prohibited.   If you
> > received  this in error, please contact the sender and delete the
> material
> > from any computer
> > 
> 
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> [EMAIL PROTECTED]
> 
> This footnote also confirms that this email message has been swept by
> MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer
> viruses.
> 
> **
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kumanan Balasundaram
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (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: Kumanan Balasundaram
  INET: [EMAIL PROTECTED]

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

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

RE: Oracle 9i and OEM

[Kimberly Smith]

Have you got all your instances defined in the oratab file?
If not, define the missing one and restart the agent and
see if that fixes your problem.

-Original Message-
Sent: Tuesday, November 20, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a problem with Enterprise Manager.

I am trying to refresh a node in order to get information of all instances 
on that machine. I am able to see two of three instances. Why I cannot see 
all of them. Setting up the preferences are ok, I have tested all user-id's 
and passwords.

TIA,

Sepi



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

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

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

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

close_cached_open_cursors "error"

[Denham Eva]

Title: close_cached_open_cursors "error"





Hello Guru's


I hope someone can shed light on this problem, more a nuisance really.
The below Alter Session statement has been appearing in the *alrt.log file.


ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter
ALTER SESSION SET close_cached_open_cursors specifies an obsolete parameter


The system is a Compaq 8500R system, Win2K and Oracle 817.
Does anyone have an idea of what this is as everyone I have approached here at my work claims not to be using it, I suspect a third party product. 

Absolutely any info will be appreciated.


TIA
Denham




This e-mail message has been scanned for Viruses and Content and cleared by 
MailMarshal - 
For more information please visit  
  www.marshalsoftware.com 

Re: Index File Name

[Rachel Carmichael]

heck, I've occasionally logged in as system and forgotten to specify
the tablespace.

power is a dangerous thing

--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Mark Leith wrote:
> > 
> > Yeah but for a tightly controlled schema *owner* - what's the
> problem?
> > Wouldn't you *want* to have unlimited tablespace for the schema
> owner -
> > which the users *should not* have access to anyway?
> > 
> > (no this is not rhetorical - I have no production experience)
> > 
> > Thanks
> > 
> > Mark
> 
> End-users are not the ones to fear. Developers are. Assume you
> control
> as tightly as you want, we all have our bad days and forget someday
> to
> do something we should have - and know we should have. Just imagine a
> user with UNLIMITED TABLESPACE for which you forgot to change the
> default tablespace from SYSTEM. I am ready to bet that before long
> you'll find unique indexes named (good case) TABLENAME_PK or (bad
> case)
> SYS_C12345 in SYSTEM. Don't give people any right they do not
> need.
> -- 
> Regards,
> 
> Stephane Faroult
> Oriole Corporation
> Voice:  +44  (0) 7050-696-269 
> Fax:+44  (0) 7050-696-449 
> Performance Tools & Free Scripts
> --
> http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> --
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Problem Running DDL SQL Script

[Ken Janusz]

I have this script that will generate a DB with a number of create table and
create index statements.  When I try to run it in SQL*Plus I get this error:

ORA-00959 tablespace SOS2_TBLSPC does not exist.  
ORA-00942 table or view doesn't exist

Here is a sample of one of the create statements:

DROP TABLE ACCESS_RIGHT CASCADE CONSTRAINTS ; 

CREATE TABLE ACCESS_RIGHT ( 
  ACCESS_RIGHT_ID  NUMBERNOT NULL, 
  GROUP_ID NUMBERNOT NULL, 
  MODULE_IDNUMBERNOT NULL, 
  CONSTRAINT PK_AR_ALL
  PRIMARY KEY ( ACCESS_RIGHT_ID, GROUP_ID, MODULE_ID ) 
USING INDEX 
 TABLESPACE SOS2_TBLSPC PCTFREE 10
 STORAGE ( INITIAL 120K NEXT 104K PCTINCREASE 0 ))
   TABLESPACE SOS2_TBLSPC NOLOGGING 
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE ( 
   INITIAL 30720
   NEXT 8192
   MINEXTENTS 1
   MAXEXTENTS 505
   FREELISTS 1 FREELIST GROUPS 1 )
   NOCACHE; 

When I check the DB this tablespace exists and is online.  I'm logged in as
system/manager.  The environment is W2000/8.1.7.

Any idea what the problem is?

Thanks,

Ken Janusz, CPIM 
Database Conversion 
Lead Sufficient System, 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).

Re: SQL question

[Stephane Faroult]

"Malik, Fawzia" wrote:
> 
> Hi,
> 
> Can you tell me if its possible to write some sql to change some data.
> Basically I need to run a scritp to change data of column: id from 12345678
> to the last four digits. Is this possible to do in sql/plsql??
> 
> Any advice/hints would be greatly appreciated
> 
> Rgds
> 
> Fawzia
> 

I assume that id is a number.

1) If it happens to be a PK, drop all the FK constraints refering it,
and the PK itself.
2)  Update T
set id = to_number(substr(to_char(number), length(to_char(number)) -
4))

should do the trick (give or take a parenthese).

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
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: Re[2]: Index File Name

[Rachel Carmichael]

yeah that would work too :)


--- [EMAIL PROTECTED] wrote:
> Rachel,
> 
> I create a role called 'developer' in each instance at create
> time.  Make it
> look something like resource, but without the unlimited tablespace
> priv, and use
> it in place of resource.  saves a step.
> 
> Dick Goulet
> 
> Reply Separator
> Subject:Re: Index File Name
> Author: Rachel Carmichael <[EMAIL PROTECTED]>
> Date:   11/21/2001 7:45 AM
> 
> standard create user script for a user who will own objects:
> 
> create user  identifed by 
> default tablespace 
> temporary tablespace 
> quota unlimited on 
> /
> grant connect, resource to 
> /
> revoke unlimited tablespace from 
> /
> 
> 
> I've gotten this drilled into my people's heads... and I check up
> on it :)
> --- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> > Mark Leith wrote:
> > > 
> > > And just to add to that - make sure that the user has the
> > appropriate
> > > privileges on the system, such as CREATE TABLE / INDEX, or the
> role
> > RESOURCE
> > > or whatever.. :)
> > > 
> > > Just to nitpick :)
> > > 
> > 
> > NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if
> you
> > cannot grant it to a role, usually - but Oracle 5 compatibility has
> > its
> > reasons ...). Not that I am paranoid, but the idea of users being
> > able
> > to create their tables in SYSTEM makes me nervous.
> >  I know, someone should tell to the Oracle folks who prepare demo
> > scripts ...
> > -- 
> > Regards,
> > 
> > Stephane Faroult
> > Oriole Corporation
> > Voice:  +44  (0) 7050-696-269 
> > Fax:+44  (0) 7050-696-449 
> > Performance Tools & Free Scripts
> > --
> > http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> > --
> > -- 
> > 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).
> 
> 
> __
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> http://geocities.yahoo.com/ps/info1
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Rachel Carmichael
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: SQL question

[Nicoll, Iain (Calanais)]

Fawzia,

You should be able to use mod(field,1) to get the remainder of the
number divided by 1, which should be the last four digits.

Cheers

Iain Nicoll

-Original Message-
Sent: Wednesday, November 21, 2001 4:04 PM
To: Multiple recipients of list ORACLE-L



Hi,

Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??

Any advice/hints would be greatly appreciated

Rgds

Fawzia 


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

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

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

Re: Odd Listener.ora Stanza

[Rachel Carmichael]

Marlene goes over it in the networking 101 book -- it's a new feature


--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> Anyone seen this fecality in their listener.ora?  It's a new one on
> me, 
> but then again, what with all the "newfangled" features in this here 
> product, I am probably just losing track..
> 
> 
> 
> (DESCRIPTION =
>   (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
>   )
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

Re: SQL question

[Jan Pruner]

Or if id is number
update  table
  set column_name=TO_NUMBER(substr(TO_CHAR(column_name),-4,4))

JP

On Wed 21. November 2001 17:45, you wrote:
> Fawzia
>
> How about:
>
>
>
> update  table
>set column_name=substr(column_name,-4,4)
>
>
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 11:04 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> Hi,
>
> Can you tell me if its possible to write some sql to change some data.
> Basically I need to run a scritp to change data of column: id from 12345678
> to the last four digits. Is this possible to do in sql/plsql??
>
> Any advice/hints would be greatly appreciated
>
> Rgds
>
> Fawzia
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
-- 
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 question

[Mercadante, Thomas F]

Fawzia 

How about:



update  table
   set column_name=substr(column_name,-4,4)



Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, November 21, 2001 11:04 AM
To: Multiple recipients of list ORACLE-L



Hi,

Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??

Any advice/hints would be greatly appreciated

Rgds

Fawzia 


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

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

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

RE: parallize printing reports to different printers

[Kevin Lange]

Title: parallize printing reports to different printers



You 
need to give more information when asking a question like this .   

    1) What are you using for the 
reports
    2) Is this really a database issue ??  Is this some 
report that is coming from an oracle database or something ?
    3) What is the OS that you are working on ?? Different 
ones have different capabilities ?
 
etc.
 
You 
are not the first who has posted a question without giving enough 
info.   Folks need to be clearer with they are asking 
for.
Without this kind of info .  you will probably never get a 
response.

  -Original Message-From: Nirmal Kumar Muthu Kumaran 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 21, 2001 
  10:36 AMTo: Multiple recipients of list ORACLE-LSubject: 
  parallize printing reports to different printers
  Hi all, 
  A report producing multiple 1000 (say 5000) pages 
  producing and we want to print it. However we don't want the user to be idle until it completes. So we plan to reduce the 
  printing time by distributing (say 1000 each) report pages with
  different printers (say 5 printers). 
  Question is, there is anyway i can assign the 
  printer name in the report while printing it, like system parameters ., 
  etc.,
  Pleasae let me get ur ideas aeap. 
  Thanks. 
  Nirmal, 

RE: SQL question

[Nirmal Kumar Muthu Kumaran]

Title: RE: SQL question





update  set id = substr(id,-4);


eg:
[EMAIL PROTECTED]> select substr('48900322',-4) from dual;


SUBS

0322


1 row selected.


Nirmal.

-Original Message-
From:   Malik, Fawzia [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 7:04 PM
To: Multiple recipients of list ORACLE-L
Subject:    SQL question



Hi,


Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??


Any advice/hints would be greatly appreciated


Rgds


Fawzia 



**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**


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


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

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

Oracle Financials DBA Team Leader Needed in Chicago..

[OraStaff]

We are searching for an Oracle Financials DBA Team Leader for a client 
located in downtown Chicago. 
The individual will perform DBA and supervisory duties for Oracle Financials
Systems.

Only candidates who already live in the Greater Chicago area can be considered.

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

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

* Requirements:
We would like someone with 3 or more years of experience
as an Oracle DBA and at least 1 year of recent experience as an Oracle
Financials DBA. This is a senior level position, requiring 6-8 years of
overall IT experience. Person should have experience as a team lead or
supervisor. Should have significant experience working in a Unix
environment. 

Must be current US Citizen or permanent resident.

This positions offer:
   * Stability 
   * The opportunity to become a key member of the team.
   * Base salary-up to 95K + excellent benefits
   
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume as a Word attachment to:
OraStaff, Inc.
Email: [EMAIL PROTECTED]
ph: 1-800 -549-8502
Please use job code: One/Chicago/Fin DBA Leader/Alan

All Submissions are handled in confidence.

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







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

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

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

RE: Upgrade 8.0.5 to 8.1.6

[Kevin Lange]

I would not do that.   Those migrate scripts change the catalog tables to
support the 8.1.6 engine and do other things.   I would never consider
upgrading a system without doing that step.

-Original Message-
Sent: Wednesday, November 21, 2001 10:36 AM
To: Multiple recipients of list ORACLE-L


That's exactly what I was saying I think.  ie. To quickly move 8.0.5 to
8.1.6, set compatible and everything should run without doing anything else
(including the u*.sql script).  You can run migration later if you need
new features of 8.1.6.

Reasonable statement?

Best,

Ed

-Original Message-
Sent: Wednesday, November 21, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment."

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>

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

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

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

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

Oracle Database Group Manager Needed in Boston

[OraStaff]

Boston, MA, Financial services company is looking for an Oracle Database
Group Manager 
who MUST be a senior ORACLE database professional. The selected candidate
will report
to the Manager of Enterprise Technologies/Global Operations.

*Candidates who are in the Greater Boston area only can be considered..
 no relocation assistance is provided.

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

Description:
The Database Group Manager is responsible
for the team which is in turn responsible for the database architecture,
database application support and database administration. These
responsibilities include coordination of implementation, support, and
maintenance of the client's database environments. The Database Group
Manager provides leadership and vision, and direction of the database
environment, ensuring support of business objectives and requirements.
Responsibilities include: The coordination of efforts required in supporting
database centric application development. Monitoring database space usage,
Backup and recovery procedures, Performance tuning and monitoring, Disaster
Recovery, Database Security. 

Requirements:
Potential candidates MUST HAVE a Minimum of 10 years overall experience as a
Oracle Database Administrator with support of
enterprise critical databases. Potential candidate MUST have a minimum of 8
years of management leadership experience in the support of ORACLE in a UNIX
environment. MUST HAVE: Experience with ORACLE development tools. MUST HAVE
a BS in Computer Science or a related discipline, MS preferred. MUST HAVE
experience in end user of vendor experience within the Financial Services
Industry.

U.S. citizenship or permanent residency also required.



This position is with a  company that offers :
* Quality Work Environment
* Salary D.O.E.--85-98K


NO sub contracting positions available.
PLEASE do not send your resume if you are not in the United States.

For  immediate consideration, please send your resume to:

Email: [EMAIL PROTECTED]
Phone: 1-800-549-8502. 
* Please use job code: One/Boston/Oracle Group Mgr/Barbara

All inquires held in confidence.

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







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

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

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

RE: MetaLink Access: Solved (for me at least)

[Jesse, Rich]

Opera is a browser that follows the W3C standards and is available on
multiple platforms, including MS Winders, Linux, Solaris, and Mac.  Unlike
IE (say it like you've just jumped off a cliff), Opera can
render XHTML properly and according to standards.  It's all on their
website.  And if you're a paranoid security-freak DBA like me, you have full
control over cookies with Opera.  The configuration settings for Opera are
like Netscape Gold 3.11 used to be, only the browser itself is much better.
:)

And to keep this message on-topic, the caveats for Oracle DBAs:  Opera 5.12
doesn't handle frame navigation the best.  You'll notice this in Metalink
when doing an advanced search.  The "Back" button takes you back too far. Do
this enough times and Opera may get confused and crash.  The best part is
that when you start it again, it'll ask you if you want to continue surfing
where you left off, in *all* your Opera windows.

There are also some minor Java/JS "problems", but the ones I've seen are
primarily due to @%^@#$%# web"masters" coding for a specific browser.
PLEASE!  We might as well all have 80x24 terminals if we're going back to
that BS.

Also, I've been running Opera6 BETA for a week now.  Impressive.  And the
frame navigation seems to be much better now...

Download it.  Now.  Several times.  Please.  :)

Gobble-gobble.

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

-Original Message-
Sent: Wednesday, November 21, 2001 09:45
To: Multiple recipients of list ORACLE-L


YES, it is a standard browser...follows all the rules. 

and so.


any special tweaks that IE has given you over Netscape or over the browser
standardare not supported..

Try it!  My experience with it was very positive. 

-Original Message-
Sent: Wednesday, November 21, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L


Does this run on NT?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 9:40 AM


> There's an easier fix:
>
> http://www.opera.com
>
> :)
>
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 06:25
> To: Multiple recipients of list ORACLE-L
>
>
> OK, I think I figured it out - had to clear the Internet Cache for IE.
>
> After I did that, I could access MetaLink.
>
> Don't know why though.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: MetaLink Access: Solved (for me at least)

[Boivin, Patrice J]

I trialed it, I am not going to spend $$$ on a browser when there are free
alternatives out there, including IE.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)


-Original Message-
From:   Mohan, Ross [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: MetaLink Access: Solved (for me at least)

huh?

Did you buy it, or just trial it?

there are no "ads" in the regular version, AFAIK


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

parallize printing reports to different printers

[Nirmal Kumar Muthu Kumaran]

Title: parallize printing reports to different printers





Hi all,


A report producing multiple 1000 (say 5000) pages producing and we want to print it. However we don't want the
user to be idle until it completes. So we plan to reduce the printing time by distributing (say 1000 each) report pages with

different printers (say 5 printers).


Question is, there is anyway i can assign the printer name in the report while printing it, like system parameters ., etc.,

Pleasae let me get ur ideas aeap.


Thanks.


Nirmal,

RE: Upgrade 8.0.5 to 8.1.6

[Cherie_Machler]

I think that COMPATIBLE must be associated with whole, big chunks of
functionality like
new features such as function indexes.   I don't think that it works for
smaller revisions to
pre-existing functions.

For instance, we just did an upgrade to 8.1.7.2 and are having TEMP space
issues with
hash joins.   8.1.7.2 just modified/improved the way that hash joins
worked.   However we
had problems and tried to fall back by setting COMPATIBLE to 8.1.7.2.
Didn't make
any difference.

The DBA who did the upgrade is having to restore to a copy of the original
8.1.5 database
instead.

Does anyone have any more detailed insight into the COMPATIBLE parameter?

Thanks,

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
Henry Poras
  
 
tp.com>  cc:   
  
Sent by: Subject: RE: Upgrade 8.0.5 to 8.1.6   
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
11/21/01 09:56 
  
AM 
  
Please respond 
  
to ORACLE-L
  
   
  
   
  




Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment."

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?

Fwd: A problem

[Jared Still]

--  Forwarded Message  --
Date: Wed, 21 Nov 2001 15:34:27 +0100


I have created a job to export a user shema
How can I tell Oracle each time it make the export to use lets say
.dmp
I mean for example if today is 21.11.2001
the exported file whoud have name21112001.dmp or something like this...

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

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

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

RE: Upgrade 8.0.5 to 8.1.6

[Ed]

That's exactly what I was saying I think.  ie. To quickly move 8.0.5 to
8.1.6, set compatible and everything should run without doing anything else
(including the u*.sql script).  You can run migration later if you need
new features of 8.1.6.

Reasonable statement?

Best,

Ed

-Original Message-
Sent: Wednesday, November 21, 2001 9:57 AM
To: Multiple recipients of list ORACLE-L


Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment."

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>

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

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

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

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

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

Re: Odd Listener.ora Stanza

[Srini . Chavali]

Ross,
It's CORBA stuff. See note 69043.1 on Metalink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc




"Mohan, Ross" <[EMAIL PROTECTED]>@fatcity.com on 11/21/2001 10:15:27 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



Anyone seen this fecality in their listener.ora?  It's a new one on me,
but then again, what with all the "newfangled" features in this here
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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



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

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

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

[Mohan, Ross]

huh?

Did you buy it, or just trial it?

there are no "ads" in the regular version, AFAIK

-Original Message-
Sent: Wednesday, November 21, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L


The only thing I don't like about Opera is the ads.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Jesse, Rich [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: MetaLink Access: Solved (for me at least)

There's an easier fix:

http://www.opera.com

:)

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

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

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

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

[Deshpande, Kirti]

Something to do with external procedure calls, Java support, GIOP support in
8.0.x versions ( < 8i)   

Mr. Gennick/Mr.Toledo talk about it in their Oracle Net8 book... Page 75,
85-86 in particular. 

Cheers!

- Kirti

> -Original Message-
> From: Mohan, Ross [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 9:15 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Odd Listener.ora Stanza
> 
> Anyone seen this fecality in their listener.ora?  It's a new one on me, 
> but then again, what with all the "newfangled" features in this here 
> product, I am probably just losing track..
> 
> 
> 
> (DESCRIPTION =
>   (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
>   )
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Mohan, Ross
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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).

SQL question

[Malik, Fawzia]

Hi,

Can you tell me if its possible to write some sql to change some data.
Basically I need to run a scritp to change data of column: id from 12345678
to the last four digits. Is this possible to do in sql/plsql??

Any advice/hints would be greatly appreciated

Rgds

Fawzia 


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

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

RE: Oracle and MQ

[YTTRI Lisa]

Title: RE: Oracle and MQ



Tony - 

 
Do you 
have error handling built in to your VB program, or do you just load it into 
Oracle and then cleanse/validate the data there?
 
Do you 
think it would also be possible to access MQ via external stored 
procedures?

  -Original Message-From: Aponte, Tony 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 20, 2001 4:02 
  PMTo: [EMAIL PROTECTED]Cc: 
  [EMAIL PROTECTED]Subject: RE: Oracle and MQ
  I believe Oracle sells an MQ-to-AQ bridge that just moves 
  messages between queuing systems.  We use VB to pull messages out of MQ 
  and issue SQL to get it into the database.
  HTH Tony Aponte 
  -Original Message- From: YTTRI 
  Lisa [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, November 20, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Subject: OT: Oracle and MQ 
  Hi - 
  Does anyone have experience with using MQ w/Oracle.  We 
  have an application that is using MQ to get data from 
  the mainframe into Oracle.  We are trying to 
  determine what our options are for retrieving the data from the MQ 
  queues. 
  We know one option is to write a Pro*C program to handle this, 
  but this means creating all our own error logic, 
  etc.  Does AQ fit into this scenario at all, or 
  is that primarily for non-middleware queues? 
  Any information / insight would be greatly appreciated. 
  
  Thanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI  Lisa   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing). 

RE: RE:

[Mohan, Ross]

Jaysus, note the date and time. It's a freaking miracle. 

;-)

-Original Message-
Sent: Wednesday, November 21, 2001 10:54 AM
To: Mohan; Ross; Multiple recipients of list ORACLE-L


OOPS! sorry, your right

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   11/21/2001 7:40 AM

"cascade"?  probably more abject ignorance on my part, but wasn't it
"including contents"?

-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace  cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a "tablespace" in the Linux, but before this I did't use a function "
Drop".
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop "tablespace" and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

[Henry Poras]

Ross,

fecality? Is that the F in RTFM? Well, things are pretty slow here (who am I
kidding. They have been, no wait. It has been pretty slow here for months)
so I grabbed my Net8 book. Not that this makes a lot of sense, but this is
what it says.

PRESENTATIONIdentifies the presentation layer
Default TTC
Values  TTC|GIOP

TTC Two-task Common
GIOP IIOP clients require GIOP. It is an alias for
either oracle.aurora.server.SGiopServer or
 oracle.aurora.server.GiopServer using TCP/IP or
TCP/IP with SSL

SESSION Identifies the session layer (oh)
Default NS
Values  NS|RAW

IIOP clients require no session layer (RAW)
Typical Net8 clients use a session layer of
Transparent Network Substrate (TNS) Network Session (NS).

For all this means to me I might as well post it on the OT list.

HB

Henry



-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the "newfangled" features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

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

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

Re[2]: Index File Name

[dgoulet]

Rachel,

I create a role called 'developer' in each instance at create time.  Make it
look something like resource, but without the unlimited tablespace priv, and use
it in place of resource.  saves a step.

Dick Goulet

Reply Separator
Author: Rachel Carmichael <[EMAIL PROTECTED]>
Date:   11/21/2001 7:45 AM

standard create user script for a user who will own objects:

create user  identifed by 
default tablespace 
temporary tablespace 
quota unlimited on 
/
grant connect, resource to 
/
revoke unlimited tablespace from 
/


I've gotten this drilled into my people's heads... and I check up
on it :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Mark Leith wrote:
> > 
> > And just to add to that - make sure that the user has the
> appropriate
> > privileges on the system, such as CREATE TABLE / INDEX, or the role
> RESOURCE
> > or whatever.. :)
> > 
> > Just to nitpick :)
> > 
> 
> NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
> cannot grant it to a role, usually - but Oracle 5 compatibility has
> its
> reasons ...). Not that I am paranoid, but the idea of users being
> able
> to create their tables in SYSTEM makes me nervous.
>  I know, someone should tell to the Oracle folks who prepare demo
> scripts ...
> -- 
> Regards,
> 
> Stephane Faroult
> Oriole Corporation
> Voice:  +44  (0) 7050-696-269 
> Fax:+44  (0) 7050-696-449 
> Performance Tools & Free Scripts
> --
> http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> --
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

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

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

[Stephane Faroult]

Mark Leith wrote:
> 
> Yeah but for a tightly controlled schema *owner* - what's the problem?
> Wouldn't you *want* to have unlimited tablespace for the schema owner -
> which the users *should not* have access to anyway?
> 
> (no this is not rhetorical - I have no production experience)
> 
> Thanks
> 
> Mark

End-users are not the ones to fear. Developers are. Assume you control
as tightly as you want, we all have our bad days and forget someday to
do something we should have - and know we should have. Just imagine a
user with UNLIMITED TABLESPACE for which you forgot to change the
default tablespace from SYSTEM. I am ready to bet that before long
you'll find unique indexes named (good case) TABLENAME_PK or (bad case)
SYS_C12345 in SYSTEM. Don't give people any right they do not need.
-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:+44  (0) 7050-696-449 
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
-- 
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:RE:

[dgoulet]

OOPS! sorry, your right

Reply Separator
Author: "Mohan; Ross" <[EMAIL PROTECTED]>
Date:   11/21/2001 7:40 AM

"cascade"?  probably more abject ignorance on my part, but wasn't it
"including contents"?

-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace  cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a "tablespace" in the Linux, but before this I did't use a function "
Drop".
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop "tablespace" and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

[Rachel Carmichael]

standard create user script for a user who will own objects:

create user  identifed by 
default tablespace 
temporary tablespace 
quota unlimited on 
/
grant connect, resource to 
/
revoke unlimited tablespace from 
/


I've gotten this drilled into my people's heads... and I check up
on it :)
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Mark Leith wrote:
> > 
> > And just to add to that - make sure that the user has the
> appropriate
> > privileges on the system, such as CREATE TABLE / INDEX, or the role
> RESOURCE
> > or whatever.. :)
> > 
> > Just to nitpick :)
> > 
> 
> NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
> cannot grant it to a role, usually - but Oracle 5 compatibility has
> its
> reasons ...). Not that I am paranoid, but the idea of users being
> able
> to create their tables in SYSTEM makes me nervous.
>  I know, someone should tell to the Oracle folks who prepare demo
> scripts ...
> -- 
> Regards,
> 
> Stephane Faroult
> Oriole Corporation
> Voice:  +44  (0) 7050-696-269 
> Fax:+44  (0) 7050-696-449 
> Performance Tools & Free Scripts
> --
> http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
> --
> -- 
> 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).


__
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

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

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

RE: Odd Listener.ora Stanza

[Mohan, Ross]

Never mind, this is an IIOP operability hook. 


-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the "newfangled" features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

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

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

[Cherie_Machler]

OEM does autodiscover based on what method of networking you
told it to used when you configured autodiscovery:   Names Server,
tnsnames.ora, or directory server.   We use tnsnames.ora and
OEM looks to see what the SID names are in tnsnames.ora for
sure.   It may do this in conjunction with the oratab file as well.

What method did you tell OEM you were using for networking?
The OEM documentation has a fairly comprehensive section
on autodiscovery in the section on setting up the Console.

Cherie Machler
Oracle DBA
Gelco Information Network


   
 
"HAWKINS, JAMES W  
 
[IT/1000]"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]> 
  Subject: RE: Oracle 9i and OEM 
 
Sent by:   
 
[EMAIL PROTECTED]   
 
   
 
   
 
11/21/01 08:25 AM  
 
Please respond to  
 
ORACLE-L   
 
   
 
   
 




Sepi,

Just a guess - are all three instances listed in your /etc/oratab file?
I'm
pretty sure OEM looks at that to determine what instances the Agent should
monitor.  I could be wrong on this though - it's been a while since I've
looked at OEM.

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: Tuesday, November 20, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a problem with Enterprise Manager.

I am trying to refresh a node in order to get information of all instances
on that machine. I am able to see two of three instances. Why I cannot see
all of them. Setting up the preferences are ok, I have tested all user-id's

and passwords.

TIA,

Sepi



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

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

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

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




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

RE: Upgrade 8.0.5 to 8.1.6

[Henry Poras]

Ed,
COMPATIBLE is there to allow backwards compatibility. If you upgrade from
8.0.5 to 8.1.6 and set COMPATIBLE=8.0.5 in your init.ora, new features will
not be turned on, allowing an easier port back to 8.0.5 if necessary.
Quoting from Oracle8i Reference Release:
"COMPATIBLE lets you use a new release, while at teh same time guaranteeing
backward compatibility with an earlier release... This parameter specifies
the release with which the Oracle server must maintain compatiibility. It
allows you to take advantage of the maintenance imporvements of a new
release immediately in you production systems without testing the new
functionality in your environment."

Henry

-Original Message-
Sent: Wednesday, November 21, 2001 9:30 AM
To: Multiple recipients of list ORACLE-L


When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>

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

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

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

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

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

RE:

[Mohan, Ross]

"cascade"?  probably more abject ignorance on my part, but wasn't it
"including contents"?

-Original Message-
Sent: Wednesday, November 21, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L


Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace  cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a "tablespace" in the Linux, but before this I did't use a function "
Drop".
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop "tablespace" and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

[Mohan, Ross]

YES, it is a standard browser...follows all the rules. 

and so.


any special tweaks that IE has given you over Netscape or over the browser
standardare not supported..

Try it!  My experience with it was very positive. 

-Original Message-
Sent: Wednesday, November 21, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L


Does this run on NT?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 9:40 AM


> There's an easier fix:
>
> http://www.opera.com
>
> :)
>
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 06:25
> To: Multiple recipients of list ORACLE-L
>
>
> OK, I think I figured it out - had to clear the Internet Cache for IE.
>
> After I did that, I could access MetaLink.
>
> Don't know why though.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: 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: MetaLink Access: Solved (for me at least)

[Mark Leith]

It certainly does!!

I run IE6, Netscape 6 & Opera 5.12 on a Win2K box. Opera is pretty cool!
Though I sometimes have problems with things like DHTML in it.. Has anybody
else seen this problem?

Mark

-Original Message-
Gramolini
Sent: 21 November 2001 15:10
To: Multiple recipients of list ORACLE-L


Does this run on NT?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 9:40 AM


> There's an easier fix:
>
> http://www.opera.com
>
> :)
>
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 06:25
> To: Multiple recipients of list ORACLE-L
>
>
> OK, I think I figured it out - had to clear the Internet Cache for IE.
>
> After I did that, I could access MetaLink.
>
> Don't know why though.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

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

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

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

Re: TNS Listener service question

[Srini . Chavali]

Patrice,
SqlPlus uses the Bequeath protocol to access local databases if the "@" is
omitted in the connect string. If the "@" is present (i.e. connect
scott/tiger@db) then it uses Net8. See Note 118381.1 on Metalink.
HTH
Srini Chavali
Oracle DBA
Cummins Inc




"Boivin, Patrice J" <[EMAIL PROTECTED]>@fatcity.com on 11/21/2001
10:05:21 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



I noticed that if I leave the TNS Listener service stopped on my NT
workstation, I can't access anything using the GUI tools.

But my script that runs command line can successfully login to the remote
databases to verify that they are accessible.  It uses
c:\oracle\ora81\bin\sqlplus.exe.

Do the command-line utilities bypass the NT TNSListener service?

Just curious, I am leaving the service up now...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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



-- 
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: MetaLink Access: Solved (for me at least)

[Boivin, Patrice J]

The only thing I don't like about Opera is the ads.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   Jesse, Rich [SMTP:[EMAIL PROTECTED]]
Sent:   Wednesday, November 21, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Subject:RE: MetaLink Access: Solved (for me at least)

There's an easier fix:

http://www.opera.com

:)

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: Index File Name

[Deshpande, Kirti]

That depends. And you are lucky( no production experience, you say) 
If the production database has more than one 'production' schema owner, then
I would rather keep them restricted to certain tablespaces of their interest
(with unlimited quota). I have worked with many variations. 
Currently working with one App with 3 databases, where Developers have more
control than the DBAs.. Prod Schema owner is widely used by all for n number
of reasons/requirements/needs  with hard coded passwords in all production
jobs,  unlimited tablespace, and privileges similar to 'system' account and
more (drop any table :) Now I have to find an acceptable solution to clean
up this environment as the new Janitor assigned to this WC !!  

Cheers!

- Kirti 

> -Original Message-
> From: Mark Leith [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 8:30 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Index File Name
> 
> Yeah but for a tightly controlled schema *owner* - what's the problem?
> Wouldn't you *want* to have unlimited tablespace for the schema owner -
> which the users *should not* have access to anyway?
> 
> (no this is not rhetorical - I have no production experience)
> 
> Thanks
> 
> Mark
> 
> -Original Message-
> Faroult
> Sent: 21 November 2001 11:40
> To: Multiple recipients of list ORACLE-L
> 
> 
> Mark Leith wrote:
> >
> > And just to add to that - make sure that the user has the appropriate
> > privileges on the system, such as CREATE TABLE / INDEX, or the role
> RESOURCE
> > or whatever.. :)
> >
> > Just to nitpick :)
> >
> 
> NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
> cannot grant it to a role, usually - but Oracle 5 compatibility has its
> reasons ...). Not that I am paranoid, but the idea of users being able
> to create their tables in SYSTEM makes me nervous.
>  I know, someone should tell to the Oracle folks who prepare demo
> scripts ...
> --
> Regards,
> 
> Stephane Faroult
> Oriole Corporation
> Voice:  +44  (0) 7050-696-269
> Fax:+44  (0) 7050-696-449
> Performance Tools & Free Scripts
> --
> 
-- 
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: Reliable alerting system that is not so costly??

[Mark Leith]

Hi Kumanan,

We have a tool that I think will fit you requirements. It's called NORAD
Surveillance Module
(http://www.cool-tools.co.uk/Products/surveillance.html).



The key aspect of NORAD is to provide server based monitoring of the
instances, watching for issues such as space restrictions, blocked
processes, high impact sessions, memory management and service level
agreement compliance.  This relieves the DBA function from the constant
monitoring process and moves them into a more proactive stance, since they
will be alerted in advance of unacceptable problem thresholds.  Notification
mechanisms include email, mobile phone SMS and the interface to
system/network management products such as Openview or Tivoli.  There is
even a facility to run “self-healing” scripts or programs based upon data
returned from the analysis engines.  The monitor also includes the ability
for DBA’s to define and implement their favourite scripts into the
framework, which then allows you to develop coordinated management policies,
which are not dependent on individuals.

The alerting facility is extremely configurable, allowing you to generate
alerts based upon the system/instance/time/scale/priority of the originating
"problem".

For instance you could send an alert to a team based upon a particular
instance. Or you could send an alert to a certain DBA's email during the
day, for a specific alert during "normal" work hours, but send the same
alert to SMS on his mobile or his pager out of work hours should the alert
have a high priority.



If you are interested in taking a further look at NORAD, send me a message
off the list, and I will get in touch with you to arrange it.

Best regards

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance

-Original Message-
Balasundaram
Sent: 21 November 2001 11:50
To: Multiple recipients of list ORACLE-L


Hi  there,

Any of you using or have come across a reliable alert system that can also
escalate
to different persons based on criteria such as how important that system is?

We are looking to invest in such a software.

Kumanan Balasundaram
Database Administrator, IT
QXL ricardo plc
www.qxl.com
P: +44 (0)208 962 7409

> QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road,
> London W6 9EJ
> Registered in England No 3430894 VAT number - GB 701 8915 43
>
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material.  Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited.   If you
> received  this in error, please contact the sender and delete the material
> from any computer
>


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[EMAIL PROTECTED]

This footnote also confirms that this email message has been swept by
MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of computer
viruses.

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

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

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

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

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

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

Odd Listener.ora Stanza

[Mohan, Ross]

Anyone seen this fecality in their listener.ora?  It's a new one on me, 
but then again, what with all the "newfangled" features in this here 
product, I am probably just losing track..



(DESCRIPTION =
  (PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
  )
-- 
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: MetaLink Access: Solved (for me at least)

[Ruth Gramolini]

Does this run on NT?

Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 9:40 AM


> There's an easier fix:
>
> http://www.opera.com
>
> :)
>
> Rich Jesse  System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
USA
>
> -Original Message-
> Sent: Wednesday, November 21, 2001 06:25
> To: Multiple recipients of list ORACLE-L
>
>
> OK, I think I figured it out - had to clear the Internet Cache for IE.
>
> After I did that, I could access MetaLink.
>
> Don't know why though.
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jesse, Rich
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 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: SQL query tuning problem

[Hallas John]

Title: Blank



Henry,
 
I remember reading some reviews of it when 
it came out and thinking I would like it. I presume it includes function based 
indexes (indices?), more on partitioning etc.
I also recall the book being about £40 UK 
whereas other comparable sized books such as Jonathan Lewis's one are normally 
around £33 UK. 
Looking at Amazon now both books are still 
available.
In the review section somebody has commented 
about the tools provided on CD as being pretty non-robust. That reminds me that 
I never managed to get any of them working which was a bit of a shame. Thinggs 
have moved on since then and I have found alternative tools or scripts to do the 
same job.
 
 
 
John

  -Original 
  Message-From: Henry Poras 
  [mailto:[EMAIL PROTECTED]]Sent: 19 November 2001 
  14:25To: Multiple recipients of list ORACLE-LSubject: 
  FW: SQL query tuning problem
  John,
  What has changed? I think we have both 
  versions floating around here somewhere (unless one of the books left with 
  some of our people). I'll try to take a stroll through the Table of 
  Contents.
   
  Henry
  
-Original Message-From: Hallas John 
[mailto:[EMAIL PROTECTED]]Sent: Monday, November 19, 2001 
5:45 AMTo: Multiple recipients of list 
ORACLE-LSubject: RE: SQL query tuning 
problem
I have the first edition which is an 
excellent book but I cannot justify buying the later version - pity 
really

  -Original 
  Message-From: SARKAR, Samir 
  [mailto:[EMAIL PROTECTED]]Sent: 16 November 
  2001 15:50To: Multiple recipients of list 
  ORACLE-LSubject: RE: SQL query tuning 
  problem
  Well Greg..I just 
  ordered the SQL Tuning book by Guy Harrison from 
  Amazon
  hope it is real good as u 
  recommend :) 
  Thanks and Cheers 
  !!
   
  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: Greg Moore 
[mailto:[EMAIL PROTECTED]]Sent: 08 November 2001 
18:28To: SARKAR, SamirSubject: Re: SQL query 
tuning problem
>> syntax for having multiple tables in the hint
 
/*+ full( a b ) */
 
Look in the Oracle documentation, in the Tuning Guide.  There 
is a complete chapter on Hints.  
 
If you are interested in tuning, get Guy Harrison's book.  
It's available on Amazon.  It's one of the best Oracle books ever 
written.

  - Original Message - 
  From: 
  SARKAR, Samir 
  To: 'Greg 
  Moore' 
  Cc: '[EMAIL PROTECTED]' 
  Sent: Thursday, November 08, 2001 
  2:04 AM
  Subject: RE: SQL query tuning 
  problem
  
  Greg,
   
  Thanks a bunch for ur 
  detailed reply. I am trying out all the options enumerated by you and 
  
  I will hopefully get 
  some results.
  I was doing a mistake 
  with the hint to disable indexes.I was using the table name 
  instead of the 
  alias in the hint. 
  
  Could u please tell 
  me the syntax for having multiple tables in the hint ?? Tahat is, if I 
  want 
  the query to run by 
  disabling the indexes in all the joined tables, what would the syntax 
  be ??
   
  Thanks 
  again,
  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: Greg Moore 
[mailto:[EMAIL PROTECTED]]Sent: 07 November 2001 
20:09To: SARKAR, SamirSubject: Re: SQL query 
tuning problem
Samir,
 
To disable an index, use the hint FULL in the SQL.  
 
select /*+ full(e) */ ename, phone, address
from emp e
where ename = 'Smith'
 
This will cause a full table scan on the emp table (instead of 
using an index).  Note you must give the table an alias in the 
FROM clause, and you must use that alias in the hint.  Also, 
the hint must have no errors.  If it contains errors you won't 
get an error message.  So after putting in a hint, be sure to 
run an explain plan to see if your hint worked.  For the FULL 
hint, obviously

Re:

[dgoulet]

Startup mount
alter database datafile '/data/db/database/core.dbf' offline drop;
alter database open;
drop tablespace  cascade;


Dick Goulet

Reply Separator
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?= <[EMAIL PROTECTED]>
Date:   11/21/2001 5:40 AM

 Hello
I need a help with one problem. In the Oracle version 8.1.7 I've deleted
a "tablespace" in the Linux, but before this I did't use a function "
Drop".
 After reboot a database, there was a error:
ERROR at line 1:
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/data/db/database/core.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
Is there a some re-step to drop "tablespace" and then regulary delete
this object and restart the database ?
  Thanx a lot for your answer.

Ota Moucka
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-2?q?Mou=E8ka=20Otakar?=
  INET: [EMAIL PROTECTED]

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

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

[Mark Leith]

Yeah but for a tightly controlled schema *owner* - what's the problem?
Wouldn't you *want* to have unlimited tablespace for the schema owner -
which the users *should not* have access to anyway?

(no this is not rhetorical - I have no production experience)

Thanks

Mark

-Original Message-
Faroult
Sent: 21 November 2001 11:40
To: Multiple recipients of list ORACLE-L


Mark Leith wrote:
>
> And just to add to that - make sure that the user has the appropriate
> privileges on the system, such as CREATE TABLE / INDEX, or the role
RESOURCE
> or whatever.. :)
>
> Just to nitpick :)
>

NEVER give RESOURCE ! UNLIMITED TABLESPACE comes with it (even if you
cannot grant it to a role, usually - but Oracle 5 compatibility has its
reasons ...). Not that I am paranoid, but the idea of users being able
to create their tables in SYSTEM makes me nervous.
 I know, someone should tell to the Oracle folks who prepare demo
scripts ...
--
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269
Fax:+44  (0) 7050-696-449
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
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: Mark Leith
  INET: [EMAIL PROTECTED]

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

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

TNS Listener service question

[Boivin, Patrice J]

I noticed that if I leave the TNS Listener service stopped on my NT
workstation, I can't access anything using the GUI tools.

But my script that runs command line can successfully login to the remote
databases to verify that they are accessible.  It uses
c:\oracle\ora81\bin\sqlplus.exe.

Do the command-line utilities bypass the NT TNSListener service?

Just curious, I am leaving the service up now...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

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

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

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

RE: MetaLink Access: Solved (for me at least)

[Mohan, Ross]

LOL!

*yes* !!

-Original Message-
Sent: Wednesday, November 21, 2001 9:40 AM
To: Multiple recipients of list ORACLE-L


There's an easier fix:

http://www.opera.com

:)

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

-Original Message-
Sent: Wednesday, November 21, 2001 06:25
To: Multiple recipients of list ORACLE-L


OK, I think I figured it out - had to clear the Internet Cache for IE.

After I did that, I could access MetaLink.

Don't know why though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

[Richard Ji]

I have no problem accessing metalink in NYC.  Could this be a local DNS, network 
issues to certain locations?

>>> [EMAIL PROTECTED] 11/21/01 08:35AM >>>
This is strange..I could not log into Metalink using the 
link metalink.oracle.com.
But I could log in using the link oracle.com/support/metalink.

Whats happening here, guysn and gals ??

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-
Sent: 21 November 2001 12:10
To: Multiple recipients of list ORACLE-L


OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.  I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 --> no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
Sent:   Tuesday, November 20, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Metalink gone to sleep ?

I can't get in.




"Farnsworth,

Dave"To: Multiple recipients
of list ORACLE-L  


@Ashleyfurnitcc:

ure.com> Subject: RE: Metalink
gone to sleep ? 
Sent by: root





11/20/2001

10:00 AM

Please

respond to

ORACLE-L









I just connected with no problems.

-Original Message-
Sent: Tuesday, November 20, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can't log in to Metalink today either...am getting the opening
page but
gives the
'Page temporarily unavailable' after that..anybody else sharing
the
same
problem 

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




___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented
are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have
received
this
email in error and that any use, dissemination, forwarding,
printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.

___

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

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

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

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

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

RE: Oracle 9i and OEM

[HAWKINS, JAMES W [IT/1000]]

Sepi,

Just a guess - are all three instances listed in your /etc/oratab file?  I'm
pretty sure OEM looks at that to determine what instances the Agent should
monitor.  I could be wrong on this though - it's been a while since I've
looked at OEM.

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: Tuesday, November 20, 2001 10:50 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have a problem with Enterprise Manager.

I am trying to refresh a node in order to get information of all instances 
on that machine. I am able to see two of three instances. Why I cannot see 
all of them. Setting up the preferences are ok, I have tested all user-id's 
and passwords.

TIA,

Sepi



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

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

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

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

[Mr. Clark]

When I read through Oracle's migration info it looks to me like
all init ora params from 8.0.5 are supported, though obsolete, in
8.1.6.  What is the point of the "compatible" parameter then if you have
to run the conversion script on the database?  Thanks for answering.

Best,

Ed

On Wed, 21 Nov 2001, Adams, Matthew (GEA, 088130) wrote:

> Ed,
>
>   There's more to it than just setting the
> COMPATIBLE parameter.  The basic steps
> are
>
> 1) install new 8.1.6 executables
> 2) copy init.ora file from old 8.0.5 home to 8.1.6 home,
>   making whatever modifications are necessary due to
>   new or obsoleted parameters
> 3) startup database
> 4) run  u0800050.sql as sys.  This modifies internal Oracle objects
> to new forms needed by 8.1.6 software.  Once this is done, NEVER
> open the database using the old version, as it can corrupt the database.
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> > -Original Message-
> > From: Ed [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 20, 2001 6:00 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Upgrade 8.0.5 to 8.1.6
> >
> >
> > A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6
> > by using export/import.  This will probably work, but wouldn't it be
> > easier to just do a cold backup and open them using the
> > COMPATIBLE parameter in the 8.1.6 environment?  Is there
> > any downside to using export/import? (ie. will it affect snapshots,
> > db links, etc...).
> >
> > I thought the whole point of the compatible parameter was that
> > it let you open up an older database with no questions asked.
> > Then you could run any of the upgrade .sql scripts at your leisure,
> > yes?
> >
> > Best,
> >
> > Ed
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ed
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).
> >
>

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

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

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

[Sunny Verghese]

Sorry forgot the command in my earlier email

To recap, here are the steps

1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
  alter index . rebuild online tablespace 
;


>From: Ken Janusz <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Fixing a DB
>Date: Wed, 21 Nov 2001 05:25:34 -0800
>
>We have a DB that is currently in more-or-less development mode for a state
>government client.  The DB has been created (11,300 lines of SQL*Plus code)
>with the tables and indexes stored in the permanent tablespace
>(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
>currently holds test data.  I think the process to correct this would be:
>
>1. Determine the size, etc. of the INDEX tablespace, write the script and
>then run it to create the tablespace.
>
>2. Go through the DDL SQL script for OKSOS (state gov. office name
>abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
>tablespace name.
>
>3. Then run the DDL SQL script to create the new DB.
>
>4. Then do and Export of the data from the old DB and Import it into the 
>new
>DB.
>
>5. Then I think I have to regenerate your indexes.  I'm not clear on this
>point. Will the Export/Import process may take care of this?
>
>Is there anything I have missed?  I'm sure there is.
>
>Thanks,
>
>Ken Janusz, CPIM
>Database Conversion Lead
>Sufficient System, 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).


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

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

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

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

[Ron Rogers]

Bing,
 Please explain your reasoning for backing up the archivelogs when you backup the 
readonly tablespaces. One reason you change a tablespace to read only is to reduce the 
backup needed. After a tablespace is in read only mode no changes are made to the data 
and you only need to back it up once and store the tape. If restoral is needed du to a 
disk failure then the backed up read only tablespace can be restored successfully. If 
you change the tablespace to read write at a future time then you need to perform a 
backup of the tablespace to reflect the change that is noted in the controlfile.
If you "backup controlfile to trace" with a tablespace in read only and then with the 
tablespace in read write you will see the differences that the controlfile tracks.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 11/20/01 02:25PM >>>
When you backup the read-only tablespace, you must backup the archive logs
(if any) as well.



-Original Message-
Sent: Tuesday, November 20, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L


Ya but you don't normally backup a read-only tablespace.  The
whole reason I make them read-only is to ensure that I finish
the backup this century.  

-Original Message-
Sent: Tuesday, November 20, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L


My hot backup is to put one tablespace in backup mode one at a time and copy
that data file to disk and alter it back online.  No problem

Bing


-Original Message-
Sent: Tuesday, November 20, 2001 10:28 AM
To: Multiple recipients of list ORACLE-L


My fault, I should have said copy.  Climbing night last night so I am 
dead tired.

Thanks for the input.

-Original Message-
Sent: Tuesday, November 20, 2001 10:10 AM
To: Multiple recipients of list ORACLE-L


Kimberly,
 You can change a tablespace to read only with no problems and you should
take a backup to capture the change. Your last paragraph stated you wanted
to "move the datafile to the disk that the tape backup picks"
That will cause you problems if you move the datafile. You should copy the
datafile because the Oracle knows that it is located at disk-1 not disk-2.
Your users can still select from the tablespace as usual and if I remember
correctly they can truncate if they have the priviledge but not delete from.
I use the same method every 6 months. Archive older data to a read only
tablespace that contains my archive tables. 
Remember, all of the tablespaces in the datafile have to be read only.
ROR mª¿ªm

>>> [EMAIL PROTECTED] 11/20/01 11:40AM >>>
Just throwing something out cause I am not sure if I am thinking correctly.
I have a database that is not using partitioning so we split each month out
into seperate tables/indexes by month and store them in their own
tablespaces.  These are kinda big so we occasionally put a tablespace into
read-only mode, shutdown the database, perform a cold backup right to tape.


Problem is, we are putting this database into ServiceGuard.  Its kind of a
big pain in the butt to shutdown a database that is running in ServiceGuard
yet still have the disks available.  So I will now have to start handling
this will the hot backup.  NOTE: not using RMAN and really don't want to.
Its not that I don't trust it, just not worth it in this environment.  

I am thinking that everything will be ok if I put the tablespace into
read-only, move the datafile to the disk that the tape backup picks up
during the OS backup along with a backup control file.  I should then be
able to recover this with no issues.  

Sound logical?


Kimberly Smith
GMD Fujitsu
Database Administrator
(503) 669-6050

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

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

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

RE: applying patch 2032040 to Oracle Purchasing

[Srini . Chavali]

Try clicking "Technical Libraries", then "Applications Install & Upgrade"
under ERP Applications, then click "Documentation" link and viola !
HTH
Srini Chavali
Oracle DBA
Cummins Inc




"Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>@fatcity.com on
11/21/2001 08:30:24 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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





I looked in metalink and maybe I'm just blind,
but I don't find a 'Maintaining Oracle
Applications' manual.

URLs would be greatly apprecieated.


Matt Adams - GE Appliances - [EMAIL PROTECTED]
"Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi."
    - Larry Wall (creator of Perl)

> -Original Message-
> From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 20, 2001 7:45 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: applying patch 2032040 to Oracle Purchasing
>
>
> Matt,
>
> I think you should get to read the 'Maintaining Oracle
> Applications' manual
> - all the ad utilities are described therein. My
> understanding is that the
> install progress is recorded in the FND_INSTALL table and a
> restart will
> look up this and decipher what else needs to be done. As far
> as your error
> goes, the solution is to open an iTar and sit back until you
> get called...
> As I said before, Patching is the bane of an Apps DBA!
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> Kill your killer-commute! Listen to great commercial-free
> christian music
> 24x7 (details at www.klove.com)
>
> ** The opinions and statements above are entirely my own and not
> those of my employer or clients **
>
>
> -Original Message-
> Sent: Tuesday, November 20, 2001 6:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> After applying the c.drv portion of the patch,
> I'm attempting to apply the d.drv portion of patch
> the patch above and adwork1 is failing applying the d.drv file.
>
> In the adwork1.log file I see,
> jre -mx128m -nojit oracle.aurora.server.tools.loadjava.LoadJavaMail
> -thin -user "USERNAME/PASSSWORD@host:port:SID"
> /opt/oracle/testappl/admin/test/out/p01ldjva.jar
>
> followed by a ton of
> ORA-03115 unsupported network/data/type or representation
> and
> ORA-29509 incorrectly formed Java binary class definition
> errors.
>
> I suspect that the file
> /opt/oracle/testappl/admin/test/out/p01ldjva.jar
> was taken from new xmlparserv2.zip file that is present in
> the patch.
>
> Being the relative newcomer at this, my question is
> what do I do now?  It's already got part way through
> applying the d.drv file, which means (if i understand this
> correctly) that I cannot un-patch.  I have to recover from the
> backup.  What can I do to try to move this forward rather
> than recovering and starting over?
>
> 
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> "Doing linear scans over an associative array is like
> trying to club someone to death with a loaded Uzi."
> - Larry Wall (creator of Perl)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Kanagaraj
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>




--
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: Fixing a DB

[Srini . Chavali]

Ken,
I don't think you will need steps 2 thru 5. After step 1, just write sql
that will spool out "alter index  rebuild tablespace "
& run the resulting sql.
Will that work ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc




Ken Janusz <[EMAIL PROTECTED]>@fatcity.com on 11/21/2001 08:25:34 AM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


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



We have a DB that is currently in more-or-less development mode for a state
government client.  The DB has been created (11,300 lines of SQL*Plus code)
with the tables and indexes stored in the permanent tablespace
(SOS2_TBLSPC).  There is no separate tablespace for indexes.  The DB
currently holds test data.  I think the process to correct this would be:

1. Determine the size, etc. of the INDEX tablespace, write the script and
then run it to create the tablespace.

2. Go through the DDL SQL script for OKSOS (state gov. office name
abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX
tablespace name.

3. Then run the DDL SQL script to create the new DB.

4. Then do and Export of the data from the old DB and Import it into the
new
DB.

5. Then I think I have to regenerate your indexes.  I'm not clear on this
point. Will the Export/Import process may take care of this?

Is there anything I have missed?  I'm sure there is.

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, 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: 
  INET: [EMAIL PROTECTED]

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

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

[Koivu, Lisa]

Title: RE: Index File Name





Alistair I think you'll find that packages don't get stored in a tablespace per se...  like you are describing below.  They are stored in the data dictionary.  So you don't need to allocate specific storage for them (other than the system tablespace) and for the most part this is negligible.  

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




-Original Message-
From:   Alistair Orchard [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 20, 2001 4:24 PM
To: Multiple recipients of list ORACLE-L
Subject:    Fw: Index File Name


Sorry for the assumption... :o)
I do find it best to specify the tablespace of the index to be different than the table, personally I use have a method of leaving:

DB Object code i.e. packages in the users default tablespace, Tables in one tablespace (i.e. Users_Tables) and indexes in another (User_indexes) over several disks to reduce disk contention. Schemas will require a Temporary Tablespace and you of course will need the rollback tablespace as a non system tablespace cannot use the system rollback... a few public rollback segments, named in the init(SID).ora so they start up automatically with the instance

etc etc.
 
 


- Original Message - 
From: Koivu, Lisa  
To: Multiple recipients of list ORACLE-L  
Sent: Tuesday, November 20, 2001 8:20 PM
Subject: RE: Index File Name



Alistair, 


The  index will be created in the default tablespace of the user, not in the tablespace of the table.  Try it and check the results.  

If you create the index in the same sql statement as the table (like the primary key) then yes it may end up in the same ts as the table.

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



-Original Message-
From:   Alistair Orchard [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 20, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject:    Re: Index File Name 


If you don't specify an index tablespace the index will occupy the same
tablespace as the Table...
It's probably best to have a tablespace for indexes and one for the tables
If you create an index tablespace,  a good name might be 'User_Indexes' ? 



- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 20, 2001 7:25 PM 



I am creating a database from a DDL SQL script.  I have created the primary
and temp tablespaces because their names were referenced in the code.
However, there is no name reference anywhere that I can find for the "index"
tablespace.  Do I need to create one, or will Oracle take care of that for
me?  If I have to create on, what name do I give it, or does it matter? 


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


--
Please see the official ORACLE-L FAQ: 
--
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: 
--
Author: Alistair Orchard
  INET: [EMAIL PROTECTED] 


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

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

[Jesse, Rich]

There's an easier fix:

http://www.opera.com

:)

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

-Original Message-
Sent: Wednesday, November 21, 2001 06:25
To: Multiple recipients of list ORACLE-L


OK, I think I figured it out - had to clear the Internet Cache for IE.

After I did that, I could access MetaLink.

Don't know why though.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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

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

RE: Metalink gone to sleep ?????

[SARKAR, Samir]

This is strange..I could not log into Metalink using the 
link metalink.oracle.com.
But I could log in using the link oracle.com/support/metalink.

Whats happening here, guysn and gals ??

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-
Sent: 21 November 2001 12:10
To: Multiple recipients of list ORACLE-L


OK, Let's do a poll.  Someone else says they have access.

Could it be the browser?

I am using IE 6.0 on my NT Workstation 4.0 SP6a and I can't get in.  I am
going to try from one of the servers (IE 5.0) to see what the result is.

[...]

IE 5.0 SP2 --> no problem accessing MetaLink.

So it could either be my NT Workstation, or MetaLink doesn't support IE6.

Late last week I could access MetaLink, but I don't know if the LAN Services
people here suddenly decided to push IE 6.0 on my workstation without
telling me, will check.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, November 20, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Metalink gone to sleep ?

I can't get in.




"Farnsworth,

Dave"To: Multiple recipients
of list ORACLE-L  


@Ashleyfurnitcc:

ure.com> Subject: RE: Metalink
gone to sleep ? 
Sent by: root





11/20/2001

10:00 AM

Please

respond to

ORACLE-L









I just connected with no problems.

-Original Message-
Sent: Tuesday, November 20, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L


Can't log in to Metalink today either...am getting the opening
page but
gives the
'Page temporarily unavailable' after that..anybody else sharing
the
same
problem 

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




___
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented
are
solely those of the author and do not necessarily represent those of
SchlumbergerSema.
If you are not the intended recipient, be advised that you have
received
this
email in error and that any use, dissemination, forwarding,
printing, or
copying of this email is strictly prohibited.

If you have received this email in error please notify the
SchlumbergerSema
Helpdesk by telephone on +44 (0) 121 627 5600.

___

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

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

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

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

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