| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_at_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 !!
> -----Original Message-----
> From: Suri, Deepak [SMTP:DSuri_at_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_at_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
<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 Wallet. --0-631704567-973873729=:18794--
From: Paul Parker <paul_g_parker_at_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
From: Chuck Hamilton <chuck_hamilton_at_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?
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?<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 Wallet. --0-434248626-973874088=:12870--
From: "Allan Davis Sahadeo" <asahadeo_at_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.
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_at_physia.com> on 11/10/2000 10:21:53 AM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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
Fat City Network Services -- (858) 538-5051 FAX: (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_at_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). --
Fat City Network Services -- (858) 538-5051 FAX: (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_at_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
 |
 |