Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: greatwhite1
- Order by date
-
Selecting Duplicating records
I asked if they would increase the temp space and the reply I received is it was always enough in the past and will will need to improve my query.- greatwhite1
- Post #7
- Forum: Oracle: All versions
-
Selecting Duplicating records
Thanks Bill but I still can't run it. I have never used a statement like this going to read a bit about it. ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_1 01652. 00000 - "unable to extend temp segment by %s in tablespace %s" *Cause: Failed to allocate an extent of...- greatwhite1
- Post #5
- Forum: Oracle: All versions
-
Selecting Duplicating records
I wasn't able to run your script above because I keep running out of temp space and our DBA refuses to increase it. However I did some research and can up with this using a Join it seems to work but I am just not sure as I was expecting a larger set of records, although I don't know for sure...- greatwhite1
- Post #3
- Forum: Oracle: All versions
-
Selecting Duplicating records
Hi new to this site, hoping someone might be able to help me with this SQL question. So I have a table called T_EE_EVALUATIONS that has duplicate records within in it. The table has the following structure below. I need to find the duplicate address where the house_id is not the same as it's...- greatwhite1
- Thread
- Replies: 8
- Forum: Oracle: All versions
