Fine Payment Activity


SELECT PATRON.last_NAME "Name", b.BARCODE "Barcode", c.PATRON_TYPE_ID, PATRON_AUDIT_TRAIL.TRANSACTION_DATE "Date", PATRON_AUDIT_TRAIL.TRANSACTION_TYPE "Transaction Type", PATRON_AUDIT_TRAIL.TRANSACTION_AMOUNT "Amount" FROM DBADMIN.PATRON PATRON, DBADMIN.PATRON_ACCOUNT PATRON_ACCOUNT, DBADMIN.PATRON_AUDIT_TRAIL PATRON_AUDIT_TRAIL, patron_barcode b, patron_type c, institution_patron d WHERE PATRON.PATRON_ID=b.patron_id and d.INSTITUTION_ID=c.INSTITUTION_ID and PATRON.PATRON_ID = PATRON_ACCOUNT.PATRON_ID AND PATRON_ACCOUNT.ASSESSMENT_ID = PATRON_AUDIT_TRAIL.ASSESSMENT_ID AND ((PATRON_AUDIT_TRAIL.TRANSACTION_TYPE=2)) ORDER BY PATRON_AUDIT_TRAIL.TRANSACTION_DATE DESC
                                                                                                                                                                                                                                       *
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP