I'm creating a report that will be selecting data from a about 7 tables with a bunch of columns. When I run my select query I get this error:
ORA-01652: unable to extend temp segment by 256 in tablespace TEMP
The select statement I'm using is below (sorry about the caps, Reports generated it). I still need to add a few tables to the statemnt and I'm already getting the error. Any ideas?
Justin
SELECT ALL AUDIT_BATCH.AUDIT_ACTION, AUDIT_BATCH.BATCH_ID, AUDIT_BATCH.PRODUCT_ID, AUDIT_BATCH.SPECIES_ID,
AUDIT_BATCH.BATCH_DESC, AUDIT_BATCH.STATUS, AUDIT_BATCH.BATCH_TYPE_ID, AUDIT_BATCH.LAB_ID, AUDIT_BATCH.PLATE_LOT, AUDIT_BATCH.TECHNICIAN, AUDIT_BATCH.CONJUGATE,
AUDIT_BATCH.SUBSTRATE, AUDIT_BATCH.INCUBATION_TIME, AUDIT_BATCH.REDUCTION,
AUDIT_BATCH.START_SEQ, AUDIT_BATCH.SAMPLES, AUDIT_BATCH.SLIDE_LOT,
AUDIT_BATCH.STRIP_LOT, AUDIT_BATCH.BATCH_NOTE, AUDIT_BATCH.TEST_DATE, AUDIT_BATCH.CHANGED_BY, AUDIT_BATCH.CHANGED_DATE, AUDIT_BATCH.CHANGE_REASON, AUDIT_BATCH.CREATED_BY, AUDIT_BATCH.CREATED_DATE, AUDIT_BATCH_SAMPLES.AUDIT_ACTION, AUDIT_BATCH_SAMPLES.BATCH_SAMPLE_ID, AUDIT_BATCH_SAMPLES.BATCH_ID, AUDIT_BATCH_SAMPLES.BATCH_SEQ, AUDIT_BATCH_SAMPLES.SAMPLE_ID,
AUDIT_BATCH_SAMPLES.RESULT, AUDIT_BATCH_SAMPLES.INTERPRET,
AUDIT_BATCH_SAMPLES.RAW1, AUDIT_BATCH_SAMPLES.RAW2, AUDIT_BATCH_SAMPLES.POSITIVE, AUDIT_BATCH_SAMPLES.CHANGED_BY, AUDIT_BATCH_SAMPLES.CHANGED_DATE, AUDIT_BATCH_SAMPLES.CHANGE_REASON, AUDIT_BATCH_SAMPLES.CREATED_BY, AUDIT_BATCH_SAMPLES.CREATED_DATE, AUDIT_SAMPLES.AUDIT_ACTION, AUDIT_SAMPLES.SAMPLE_ID, AUDIT_SAMPLES.ORDER_NUMBER, AUDIT_SAMPLES.SPECIES_ID,
AUDIT_SAMPLES.SAMPLE_TYPE_ID, AUDIT_SAMPLES.CUST_SAMPLE_ID,
AUDIT_SAMPLES.PRINT_GROUP, AUDIT_SAMPLES.CHANGED_BY, AUDIT_SAMPLES.CHANGED_DATE, AUDIT_SAMPLES.CHANGE_REASON, AUDIT_SAMPLES.CREATED_BY, AUDIT_SAMPLES.CREATED_DATE, AUDIT_SAMPLE_PRODUCT.AUDIT_ACTION,
AUDIT_SAMPLE_PRODUCT.SAMPLE_PRODUCT_ID, AUDIT_SAMPLE_PRODUCT.SAMPLE_ID,
AUDIT_SAMPLE_PRODUCT.PRODUCT_SEQ, AUDIT_SAMPLE_PRODUCT.PRODUCT_ID, AUDIT_SAMPLE_PRODUCT.CATALOG_ID, AUDIT_SAMPLE_PRODUCT.BILLABLE, AUDIT_SAMPLE_PRODUCT.BATCH_ID,
AUDIT_SAMPLE_PRODUCT.ON_REPORT, AUDIT_SAMPLE_PRODUCT.ON_PACKSLIP, AUDIT_SAMPLE_PRODUCT.CHANGED_BY, AUDIT_SAMPLE_PRODUCT.CHANGED_DATE, AUDIT_SAMPLE_PRODUCT.CHANGE_REASON, AUDIT_SAMPLE_PRODUCT.CREATED_BY, AUDIT_SAMPLE_PRODUCT.CREATED_DATE, AUDIT_PROFILES.AUDIT_ACTION,
AUDIT_PROFILES.PROFILE_ID, AUDIT_PROFILES.CATALOG_ID, AUDIT_PROFILES.LAB_ID, AUDIT_PROFILES.PROFILE_NAME, AUDIT_PROFILES.STD_PRICE,
AUDIT_PROFILES.PROFILE_DESC, AUDIT_PROFILES.PUBLISH, AUDIT_PROFILES.CHANGED_BY, AUDIT_PROFILES.CHANGED_DATE, AUDIT_PROFILES.CHANGE_REASON, AUDIT_PROFILES.CREATED_BY, AUDIT_PROFILES.CREATED_DATE
FROM AUDIT_BATCH, AUDIT_BATCH_SAMPLES, AUDIT_SAMPLES, AUDIT_SAMPLE_PRODUCT, AUDIT_PROFILES
WHERE ((AUDIT_BATCH_SAMPLES.BATCH_ID = AUDIT_BATCH.BATCH_ID)
AND (AUDIT_SAMPLES.SAMPLE_ID = AUDIT_BATCH_SAMPLES.SAMPLE_ID)
AND (AUDIT_SAMPLE_PRODUCT.SAMPLE_ID = AUDIT_SAMPLES.SAMPLE_ID)
AND (AUDIT_PROFILES.CATALOG_ID = AUDIT_SAMPLE_PRODUCT.CATALOG_ID))
ORA-01652: unable to extend temp segment by 256 in tablespace TEMP
The select statement I'm using is below (sorry about the caps, Reports generated it). I still need to add a few tables to the statemnt and I'm already getting the error. Any ideas?
Justin
SELECT ALL AUDIT_BATCH.AUDIT_ACTION, AUDIT_BATCH.BATCH_ID, AUDIT_BATCH.PRODUCT_ID, AUDIT_BATCH.SPECIES_ID,
AUDIT_BATCH.BATCH_DESC, AUDIT_BATCH.STATUS, AUDIT_BATCH.BATCH_TYPE_ID, AUDIT_BATCH.LAB_ID, AUDIT_BATCH.PLATE_LOT, AUDIT_BATCH.TECHNICIAN, AUDIT_BATCH.CONJUGATE,
AUDIT_BATCH.SUBSTRATE, AUDIT_BATCH.INCUBATION_TIME, AUDIT_BATCH.REDUCTION,
AUDIT_BATCH.START_SEQ, AUDIT_BATCH.SAMPLES, AUDIT_BATCH.SLIDE_LOT,
AUDIT_BATCH.STRIP_LOT, AUDIT_BATCH.BATCH_NOTE, AUDIT_BATCH.TEST_DATE, AUDIT_BATCH.CHANGED_BY, AUDIT_BATCH.CHANGED_DATE, AUDIT_BATCH.CHANGE_REASON, AUDIT_BATCH.CREATED_BY, AUDIT_BATCH.CREATED_DATE, AUDIT_BATCH_SAMPLES.AUDIT_ACTION, AUDIT_BATCH_SAMPLES.BATCH_SAMPLE_ID, AUDIT_BATCH_SAMPLES.BATCH_ID, AUDIT_BATCH_SAMPLES.BATCH_SEQ, AUDIT_BATCH_SAMPLES.SAMPLE_ID,
AUDIT_BATCH_SAMPLES.RESULT, AUDIT_BATCH_SAMPLES.INTERPRET,
AUDIT_BATCH_SAMPLES.RAW1, AUDIT_BATCH_SAMPLES.RAW2, AUDIT_BATCH_SAMPLES.POSITIVE, AUDIT_BATCH_SAMPLES.CHANGED_BY, AUDIT_BATCH_SAMPLES.CHANGED_DATE, AUDIT_BATCH_SAMPLES.CHANGE_REASON, AUDIT_BATCH_SAMPLES.CREATED_BY, AUDIT_BATCH_SAMPLES.CREATED_DATE, AUDIT_SAMPLES.AUDIT_ACTION, AUDIT_SAMPLES.SAMPLE_ID, AUDIT_SAMPLES.ORDER_NUMBER, AUDIT_SAMPLES.SPECIES_ID,
AUDIT_SAMPLES.SAMPLE_TYPE_ID, AUDIT_SAMPLES.CUST_SAMPLE_ID,
AUDIT_SAMPLES.PRINT_GROUP, AUDIT_SAMPLES.CHANGED_BY, AUDIT_SAMPLES.CHANGED_DATE, AUDIT_SAMPLES.CHANGE_REASON, AUDIT_SAMPLES.CREATED_BY, AUDIT_SAMPLES.CREATED_DATE, AUDIT_SAMPLE_PRODUCT.AUDIT_ACTION,
AUDIT_SAMPLE_PRODUCT.SAMPLE_PRODUCT_ID, AUDIT_SAMPLE_PRODUCT.SAMPLE_ID,
AUDIT_SAMPLE_PRODUCT.PRODUCT_SEQ, AUDIT_SAMPLE_PRODUCT.PRODUCT_ID, AUDIT_SAMPLE_PRODUCT.CATALOG_ID, AUDIT_SAMPLE_PRODUCT.BILLABLE, AUDIT_SAMPLE_PRODUCT.BATCH_ID,
AUDIT_SAMPLE_PRODUCT.ON_REPORT, AUDIT_SAMPLE_PRODUCT.ON_PACKSLIP, AUDIT_SAMPLE_PRODUCT.CHANGED_BY, AUDIT_SAMPLE_PRODUCT.CHANGED_DATE, AUDIT_SAMPLE_PRODUCT.CHANGE_REASON, AUDIT_SAMPLE_PRODUCT.CREATED_BY, AUDIT_SAMPLE_PRODUCT.CREATED_DATE, AUDIT_PROFILES.AUDIT_ACTION,
AUDIT_PROFILES.PROFILE_ID, AUDIT_PROFILES.CATALOG_ID, AUDIT_PROFILES.LAB_ID, AUDIT_PROFILES.PROFILE_NAME, AUDIT_PROFILES.STD_PRICE,
AUDIT_PROFILES.PROFILE_DESC, AUDIT_PROFILES.PUBLISH, AUDIT_PROFILES.CHANGED_BY, AUDIT_PROFILES.CHANGED_DATE, AUDIT_PROFILES.CHANGE_REASON, AUDIT_PROFILES.CREATED_BY, AUDIT_PROFILES.CREATED_DATE
FROM AUDIT_BATCH, AUDIT_BATCH_SAMPLES, AUDIT_SAMPLES, AUDIT_SAMPLE_PRODUCT, AUDIT_PROFILES
WHERE ((AUDIT_BATCH_SAMPLES.BATCH_ID = AUDIT_BATCH.BATCH_ID)
AND (AUDIT_SAMPLES.SAMPLE_ID = AUDIT_BATCH_SAMPLES.SAMPLE_ID)
AND (AUDIT_SAMPLE_PRODUCT.SAMPLE_ID = AUDIT_SAMPLES.SAMPLE_ID)
AND (AUDIT_PROFILES.CATALOG_ID = AUDIT_SAMPLE_PRODUCT.CATALOG_ID))