Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: LMT ASSM & next extent
CREATE TABLE tmp_quickie
(mycol VARCHAR2(12)) STORAGE (INITIAL 10240 M);
Whoops, that was supposed to be "K" not "M". Oh well, I'll just delete the table and redo it -- no harm done.
Been there, done that.
Rich
Rich Jesse System/Database Administrator rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
-----Original Message-----
From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
Sent: Wednesday, February 11, 2004 8:25 AM
To: oracle-l_at_freelists.org
Subject: RE: RE: LMT ASSM & next extent
i poll for the size of the file and the total bytes of the segments in each file. I keep repository of past sizes of the data files(its just a table). if it extends i get an email. I work from there.
I find it to be one less thing to have to worry about. Is this approach flawed?
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Feb 11 2004 - 08:48:37 CST
-----------------------------------------------------------------