Re: Questions for DBAs

From: <argosy22_at_my-deja.com>
Date: Mon, 28 Jun 1999 12:28:54 GMT
Message-ID: <7l7pps$fhe$1@nnrp1.deja.com>

HI,

Thanks for responding.

> > - what is the query to find out how much "space"
> > a user currently available to them (or is left for
> > everyone)
> > ??
>
> What you mean "space"?

Well, sometimes when I go to make a temp table, or run other Selects, the SQL command aborts. It will have run out of extents or tablespace. I suppose that it could also have run out of something else, so I left the question to the correct interpretation.

ORA-01652: unable to extend temp segment by 423 in tablespace TEMP
ORA-01562: failed to extend rollback segment number 1
ORA-01628: max # extents (505) reached for rollback segment R01

What country is "KR"?

Regards,

Argosy

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 07:28:54 CDT