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

ORA-15053: diskgroup "string" contains existing files

1 Answers  


ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

1 Answers  


NNO-00261: cannot construct configuration checkpoint file name

1 Answers  


ORA-23356: masterdef recognizes a master which does not recognize the masterdef

1 Answers  


ORA-32739: Hang analysis aborted due to failed heap re-grow

1 Answers  


ORA-07616: $CHANGE_CLASS failed in retrieving the specified device label

1 Answers  


ORA-32144: Cannot perform operation on a null interval

1 Answers  


ORA-22278: must update the LOB only through the LOB buffers

1 Answers  


RMAN-06598: conversion between platforms 'string' and 'string' is not needed

1 Answers  


ORA-01212: MAXLOGMEMBERS may not exceed string

1 Answers  


ORA-29553: class in use: string.string

1 Answers  


ORA-31044: Top-level prefix length string exceeds maximum string

1 Answers  


Categories