hi selva,
is there any query to see first 10 rows & then next 10 & so on like dos command
"Dir *.* |more".
thank you.

-----Original Message-----
From: Selvakumar Palani samy [mailto:selvakumar.[Email Address Removed] Friday, May 31, 2002 10:32 AM
To: Randhir.Singh
Subject: Re: error "space quota exceeded for tablespace 'user_data'.


Hi,
U can Find out the allocated quota againts each user for a given table
space by issuing the following statement
select * from dba_ts_quotas

If the MAX_BYTES and MAX_BLOCKS show '-1' then the user got unlimited qutoa

U can increase the quota by

ALTER USER <<USER_NAME>> QUOTA <<SIZE OR UNLIMITED>> ON <<TABLE SPACE
NAME>>


Regards
selva

----- Original Message -----
From: "Randhir.Singh" <Randhir.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, May 31, 2002 10:06 AM
Subject: error "space quota exceeded for tablespace 'user_data'.


hi all,
pls help.
my problem: i want to create a new table in oracle8.0.
but it shows error "space quota exceeded for tablespace 'user_data'.
how to resolve this problem?
does the solution is to increase the space of tablespace?
if its so, then how to increase the storage size of tablespace?
how can i see the tablespace user_data.
i tried desc,select command but failed to see where it is.
with regards
randhir

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page