Space quota exceed--ORA-01536
Dear all,
I had a problem of Space quota exceed--ORA-01536....
Actually it is now solved....it was happening with a single table in that tablesspace(locally managed).....it was not allowing me to insert any record or craeting any index on to it....it was giving same error..Space quota exceed--ORA-01536....
i just drooped it & recreated it....then it was solved..
but b4 that i did the thing like increasing size of tablespace(adding datafile)....but it didn't go so i had to drop it & recreat it....
What was the problem? any one have any idea...
also can u tell me how to move all objects(procedure,triggers etc)of one tablespace to another table?
Thanx in Advance....
Message was edited by:
NIT