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

KUP-04026: field too long for datatype

1 Answers  


PLS-00123: program too large

1 Answers  


TNS-01021: ------------------------

1 Answers  


ORA-24322: unable to delete an initialized mutex

1 Answers  


ORA-16059: Log file is empty or invalid next available block

1 Answers  






DRG-50803: failed to define output

1 Answers  


ORA-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 Answers  


ORA-00366: log string of thread string, checksum error in the file header

1 Answers  


ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

1 Answers  


ORA-16621: Database name for ADD DATABASE must be unique.

1 Answers  


ORA-25403: could not reconnect

1 Answers  


SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

1 Answers  


Categories