Oracle 8.0.5.1.1
I am getting the ORA-01630 max number of extents (505) for a temp segment in
my temporary tablespace
message when I do a select count(*)
I have two tables,
1. has 300,000+ rows
2. has 1,200,000 rows
I retrieved the numbers by performing a select count(*) from xx.
I
Message-
From: Browett, Darren [SMTP:[EMAIL PROTECTED]]
Sent: Friday, July 27, 2001 4:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Running out of extents on temporary tablespace
Oracle 8.0.5.1.1
I am getting the ORA-01630 max number of extents (505) for a temp segment