valexena <me*********@dbforums.com> wrote in message news:<35****************@dbforums.com>...
Which clause in a create user statement restricts the number of tables a
user can add to a tablespace?
Well, I don't think there is an explicit way of saying that a user can
create n tables in a tablespace. However, you can set tablespace
quotas for a user. E.g:
ALTER USER fred QUOTA 20M ON USERS;
means user fred cannot consume more that 20M of space within the USERS
tablespace.