Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

What is Oracle error ORA-01536? -


i got following error on oracle: ora-01536

what problem?

the online documentation includes book explanations , resolutions error messages. of them bit cryptic place start. find out more.

anyhoo, here illustrated solution ora-01536.

a dba creates new user:

sql> create user fox_in_socks identified tweetlebeetle   2      default tablespace users quota 1m on users   3  /  user created.  sql> grant create session, create table fox_in_socks   2  /  grant succeeded.  sql> 

in session our brave user creates table...

sql> conn fox_in_socks/tweetlebeetle connected. sql> create table t23 (col1 varchar2(4000))   2  /  table created.  sql> 

.. , work....

sql> begin   2      in 1..1000 loop   3          insert t23 values (rpad('a', 4000, 'a'));   4          commit;   5      end loop;   6  end;   7  / begin * error @ line 1: ora-01536: space quota exceeded tablespace 'users' ora-06512: @ line 3   sql> 

uh-oh! our user goes tame dba , asks more quota, get:

sql> alter user fox_in_socks   2      quota 10m on users   3  /  user altered.  sql> 

work proceeds:

sql> begin   2      in 1..1000 loop   3          insert t23 values (rpad('a', 4000, 'a'));   4          commit;   5      end loop;   6  end;   7  /  pl/sql procedure completed.  sql> 

if user application owner dba have decided give them unlimited quota (especially if user privileges on tablespace):

alter user fox_in_socks     quota unlimited on users / 

(in real life situation unlikely true users tablespace).

users can check current quota using appropriate view:

sql> select * user_ts_quotas   2  /  tablespace_name                     bytes  max_bytes     blocks max_blocks dro ------------------------------ ---------- ---------- ---------- ---------- --- users                             9437184   10485760       1152       1280 no  sql> 

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -