Database Administration (MOSC)

MOSC Banner

ORA-01536: space quota exceeded for tablespace

edited Mar 26, 2009 11:24PM in Database Administration (MOSC) 2 commentsAnswered
 Hi all,

i got "ORA-01536: space quota exceeded for tablespace" while i was tring create table.

after, i droped some tables to cleanup tablespace and tried again.  same error.

i did coalesce the tablespace. same error.

why ? what s the  problem ?  how can i see quota of a user on a tablespace ?

Thanks for answers.

Best regards.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center