Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-01536: space quota exceeded for tablespace 'string'

Answers were Sorted based on User's Feedback



ORA-01536: space quota exceeded for tablespace 'string'..

Answer / guest

Cause: The space quota for the segment owner in the
tablespace has been exhausted and the operation attempted
the creation of a new segment extent in the tablespace.

Action: Either drop unnecessary objects in the tablespace to
reclaim space or have a privileged user increase the quota
on this tablespace for the segment owner.

Please add more information about this Error

Is This Answer Correct ?    5 Yes 0 No

ORA-01536: space quota exceeded for tablespace 'string'..

Answer / chandu

Chandu is online.

you use any of the below sql command.

SQL> Grant connect,dba,resourse to xyz;

OR
SQL> Alter user xyz quota unlimited on tablespace name;

thank you...

Is This Answer Correct ?    5 Yes 0 No

ORA-01536: space quota exceeded for tablespace 'string'..

Answer / naveen kumar s

ORA-01536: space quota exceeded for tablespace 'string'

Cause: The space quota for the segment owner in the
tablespace has been exhausted(overfilled) and the operation
attempted the creation of a new segment extent in the
tablespace.

Action: Either drop unnecessary objects in the tablespace
to reclaim space(To make existing space available) or have
a privileged user increase the quota on this tablespace for
the segment owner.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00160: invalid substitution group affiliation between "~S" and "~S"

1 Answers  


CLSR-00530: Can not get user name

1 Answers  


ORA-38437: The ADT "string" may not contain any user methods.

1 Answers  


ORA-22865: more than one column specified

1 Answers  


PCC-02320: arithmetic expression does not have correct operand types

1 Answers  


O2I-00117: Internal error: No message file for component O2U

1 Answers  


ORA-19570: file number string is outside valid range of 1 through string

1 Answers  


ORA-26529: local store callback term phase failed for 'string.string'

1 Answers  


ORA-06736: TLI Driver: server not running

1 Answers  


NNL-00959: Time until cache dump to trace file: string

1 Answers  


ORA-30558: internal error [string] in function based index

1 Answers  


ORA-07480: snchmod: cannot change permissions on ?/dbs/sgalm.dbf.

1 Answers  


Categories