From: eross#@serviceware.ca (Elliot Ross) Subject: Re: Newbie Roles / extents Qustions... Date: 1997/06/06 Message-ID: #1/1 References: <01bc6d3d$ceafed80$cc8e1382@ghm4ws04.comp.pge.com> Organization: Magma Communications Ltd., Ottawa, Ontario, Canada Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools Yes it makes sense & thank you - I apologize for delays in answering this, ISP got new server ! In article <01bc6d3d$ceafed80$cc8e1382@ghm4ws04.comp.pge.com>, ghm4@pge.com says... > Have you given the individual a quota on the tablespace in which they are > attempting the tables? The user needs either unlimited quota or a specific > amount ( so many Kbytes ) before they can create objects in the specified > tablespace. If the tablespace is not explicitly speciified in the create > statement, oracle will try to create in the user's default tablespace. The > user still needs to be given a quota in their default tablespace for them > to be able to create objects. Does this make sense? > > Gerardo > -- My EMail address contains a # to try to thwart mail spamming.