Hi all,

Since yesterday, I am having wiered problem.

I am running one script, which has INSERT statement. It consumes 32GB of my diskspace and still needs more and than fails with 'Unable to extend TS' error.

Database is 8173 on Windows platform. TEMP T.S originally was LMT, TEMPORARY but than on Oracle's advise, I dropped it and recreated as DMT and PERMANENT but still gives me same problem.

Foll. is the query on which it fails.

SELECT pra.resource_assignment_id, pra.budget_version_id, pra.project_id,
pra.task_id, pra.resource_list_member_id, pra.last_update_date,
pra.last_updated_by, pra.creation_date, pra.created_by,
pra.last_update_login, pra.unit_of_measure, pra.track_as_labor_flag
FROM pa_budget_types pbt,
gms_awards_all gaa,
pa_budget_versions pbv,
pa_resource_assignments pra
WHERE pbt.budget_type_code = gaa.award_id
AND pbt.award_flag = 'Y'
AND pbt.budget_type_code = pbv.budget_type_code
AND gaa.award_id BETWEEN :b1 AND :b1
+ :b3
- 1
AND pra.budget_version_id = pbv.budget_version_id

Foll. is the explain plan.

Operation Object Name Rows Bytes Cost TQ In/Out PStart PStop

SELECT STATEMENT Hint=CHOOSE 17 K 2700
FILTER
HASH JOIN 17 K 1 M 2700
TABLE ACCESS FULL PA_BUDGET_TYPES 1 10 2
MERGE JOIN 1 M 131 M 2693
SORT JOIN 1 M 110 M 2455
MERGE JOIN CARTESIAN 1 M 110 M 2455
INDEX RANGE SCAN GMS_AWARDS_U1 1 6 1
SORT JOIN 1 M 101 M 2454
TABLE ACCESS FULL PA_RESOURCE_ASSIGNMENTS 1 M 101 M 2454
SORT JOIN 39 K 344 K 238
TABLE ACCESS FULL PA_BUDGET_VERSIONS 39 K 344 K 133


What should I do to complete this INSERT statement without error.

Thanks in Adv.