Message-Id: <10676.121730@fatcity.com>
From: lerobe - Lee Robertson <LEROBE@acxiom.co.uk>
Date: Fri, 10 Nov 2000 16:24:28 -0000
Subject: 3113

This is a bit of a weirdo. Oracle 8.0.5. When doing an alter user fred quota
unlimited on tspace we get a 3113 error. Anyone seen this before. We get
this whether connect ed as sys or system in sqlplus or as internal from
within svrmgr.
 
TIA
 
Lee
 

Lee Robertson 
Acxiom 
Tel:    0191 525 7344 
Fax:    0191 525 7007 
Email: lerobe@acxiom.co.uk 

 


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


------------------------------

 From: "Deshpande, Kirti" <kirti.deshpande@verizon.com>
 Date: Fri, 10 Nov 2000 10:20:11 -0600
 Subject: RE: Index Organized tables: Please explain use?

That's called 'Borrowing' from the next day !! 
 -- (my ex-Damager) 

> -----Original Message-----
> From:	Suri, Deepak [SMTP:DSuri@oxhp.com]
> Sent:	Friday, November 10, 2000 10:02 AM
> 
> Oh and by the way while we are on the topic of lack of time, does anyone
> know of a way to request more than 24 hours in a day ??? :-)
> 
> 


------------------------------

 From: Chuck Hamilton <chuck_hamilton@yahoo.com>
 Date: Fri, 10 Nov 2000 08:28:49 -0800 (PST)
 Subject: Partitioning in 8i

--0-631704567-973873729=:18794
Content-Type: text/plain; charset=us-ascii

  




---------------------------------
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores.  Millions of Products.  All with one Wallet.
--0-631704567-973873729=:18794
Content-Type: text/html; charset=us-ascii

 
 <BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://shopping.yahoo.com/">Yahoo! Shopping</a> - 
Thousands of Stores.  Millions of Products.  All with one <a href="http://wallet.yahoo.com">Wallet</a>.
--0-631704567-973873729=:18794--


------------------------------

 From: Paul Parker <paul_g_parker@yahoo.com>
 Date: Fri, 10 Nov 2000 08:33:08 -0800 (PST)
 Subject: Re: CBO: built-in default selectivity for range scan

Hi Ed, 

Whilst I haven't confirmed this with any tests, 
the doc from an internals course which I took
says that the default selectivity for
bounded/unbounded range scan for bind variables
is 5%.

Let me know if you find anything to the contrary.

Paul


__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/


------------------------------

 From: Chuck Hamilton <chuck_hamilton@yahoo.com>
 Date: Fri, 10 Nov 2000 08:34:48 -0800 (PST)
 Subject: Partitioning in 8i

--0-434248626-973874088=:12870
Content-Type: text/plain; charset=us-ascii

Can someone help with this problem. I have an order table with > 100 million orders. I want to partition it based on the month the order was taken and every month add a new partition and drop the one that's 25 months old. When I do this however it invalidates the PK index which is simply the order's number (a sequential number). I can't locally partition the PK index because it doesn't contain the partition key column (order date). I can't change the PK because that would allow duplicate order numbers if created on different days. What can I do to quickly drop the 25th month without invalidating the PK index which effectively disables the entire table?




---------------------------------
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores.  Millions of Products.  All with one Wallet.
--0-434248626-973874088=:12870
Content-Type: text/html; charset=us-ascii

Can someone help with this problem. I have an order table with &gt; 100 million orders. I want to partition it based on the month the order was taken and every month add a new partition and drop the one that's 25 months old. When I do this however it invalidates the PK index which is simply the order's number (a sequential number). I can't locally partition the PK index because it doesn't contain the partition key column (order date). I can't change the PK because that would allow duplicate order numbers if created on different days. What can I do to quickly drop the 25th month without invalidating the PK index which effectively disables the entire table?<BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://shopping.yahoo.com/">Yahoo! Shopping</a> - 
Thousands of Stores.  Millions of Products.  All with one <a href="http://wallet.yahoo.com">Wallet</a>.
--0-434248626-973874088=:12870--


------------------------------

 From: "Allan Davis Sahadeo" <asahadeo@neal-and-massy.com>
 Date: Fri, 10 Nov 2000 12:33:26 -0400
 Subject: Re: Power Point Prsentation for Oracle training

This is a multi-part message in MIME format.

------=_NextPart_000_03F6_01C04B12.6C4C2D00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

This might sound funny, but click on the sister's mouse will ya.
Allan.
  ----- Original Message -----=20
  From: Hannah.M.Doran@sb.com=20
  To: Multiple recipients of list ORACLE-L=20
  Sent: Friday, November 10, 2000 11:55 AM
  Subject: RE: Power Point Prsentation for Oracle training






  Good!  I'm not the only one.  Got a real kick out of the "Click Away"
  instructions with no place to *click*...


  And here I was just thinking that I didn't have enough coffee this =
morning!

  Hannah







  Alex Hillman <alex_hillman@physia.com> on 11/10/2000 10:21:53 AM

  Please respond to ORACLE-L@fatcity.com

  To:   Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
  cc:




  Looks like I do not have enough imagination because I cannot find how =
to get
  thru the banner page. Help anybody?

  Alex Hillman

  -----Original Message-----
  Sent: Thursday, November 09, 2000 9:15 PM
  To: Multiple recipients of list ORACLE-L


  Hi Muru,

  Have a look at http://www.geocities.com/howardjr2000/.

  @   Regards,
  @   Steve Adams
  @   http://www.ixora.com.au/
  @   http://www.christianity.net.au/


  -----Original Message-----
  Sent: Friday, 10 November 2000 10:55
  To: Multiple recipients of list ORACLE-L


  Hello Lists,

  Can anybody help me in locating a power point / any
  other resource for training a team. It can be from
  basic to expert level. I remember to have seen at some
  site such as orafaq.com. I am unable to relocate it.
  Any help in this aspect would be highly appreciated.

  Thanks in advance,
  Muru

  __________________________________________________
  Do You Yahoo!?
  Thousands of Stores.  Millions of Products.  All in one Place.
  http://shopping.yahoo.com/
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com
  --
  Author: Murugesan Balakrishnan
    INET: mail_oracle@yahoo.com

  Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
  San Diego, California        -- Public Internet access / Mailing Lists
  --------------------------------------------------------------------
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (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: Steve Adams
    INET: steve.adams@ixora.com.au

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




------=_NextPart_000_03F6_01C04B12.6C4C2D00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#a0a0a8>
<DIV><FONT face=3DArial size=3D2>This might sound funny, but click on =
the sister's=20
mouse will ya.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Allan.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
  <A href=3D"mailto:Hannah.M.Doran@sb.com"=20
  title=3DHannah.M.Doran@sb.com>Hannah.M.Doran@sb.com</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L@fatcity.com"=20
  title=3DORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, November 10, 2000 =
11:55=20
  AM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Power Point =
Prsentation for=20
  Oracle training</DIV>
  <DIV><BR></DIV><BR><BR><BR><BR>Good!&nbsp; I'm not the only one.&nbsp; =
Got a=20
  real kick out of the "Click Away"<BR>instructions with no place to=20
  *click*...<BR><BR><BR>And here I was just thinking that I didn't have =
enough=20
  coffee this morning!<BR><BR>Hannah<BR><BR><BR><BR><BR><BR><BR><BR>Alex =
Hillman=20
  &lt;<A =
href=3D"mailto:alex_hillman@physia.com">alex_hillman@physia.com</A>&gt;=20
  on 11/10/2000 10:21:53 AM<BR><BR>Please respond to <A=20
  =
href=3D"mailto:ORACLE-L@fatcity.com">ORACLE-L@fatcity.com</A><BR><BR>To:&=
nbsp;&nbsp;=20
  Multiple recipients of list ORACLE-L=20
  &lt;ORACLE-L@fatcity.com&gt;<BR>cc:<BR><BR><BR><BR><BR>Looks like I do =
not=20
  have enough imagination because I cannot find how to get<BR>thru the =
banner=20
  page. Help anybody?<BR><BR>Alex Hillman<BR><BR>-----Original=20
  Message-----<BR>Sent: Thursday, November 09, 2000 9:15 PM<BR>To: =
Multiple=20
  recipients of list ORACLE-L<BR><BR><BR>Hi Muru,<BR><BR>Have a look at=20
  http://www.geocities.com/howardjr2000/.<BR><BR>@&nbsp;&nbsp;=20
  Regards,<BR>@&nbsp;&nbsp; Steve Adams<BR>@&nbsp;&nbsp;=20
  http://www.ixora.com.au/<BR>@&nbsp;&nbsp;=20
  http://www.christianity.net.au/<BR><BR><BR>-----Original =
Message-----<BR>Sent:=20
  Friday, 10 November 2000 10:55<BR>To: Multiple recipients of list=20
  ORACLE-L<BR><BR><BR>Hello Lists,<BR><BR>Can anybody help me in =
locating a=20
  power point / any<BR>other resource for training a team. It can be=20