Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Disappearing Triggers!

Disappearing Triggers!

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 10 Sep 2002 08:34:45 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702A0510D@lnewton.leeds.lfs.co.uk>

Hi Daniel,

'quota 0 on system' to me is a must because I once didn't do it - after all, no-one gets quota on system do they ?

Until you import a user with over 2000 tables and someone (me) has forgotten to give them quota on their default tablespace - guess where all theose damned tables went !
This was Oracle 734 at the time, but now, it just types itself automatically when I'm doing a new user :o)

Cheers,
Norman.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


-----Original Message-----
From: Daniel Morgan [mailto:dmorgan_at_exesolutions.com] Posted At: Monday, September 09, 2002 5:47 PM Posted To: server
Conversation: Disappearing Triggers!
Subject: Re: Disappearing Triggers!

>> I like that "quota 0 on SYSTEM" ... Thanks.

Daniel Morgan Received on Tue Sep 10 2002 - 02:34:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US