Problem with a remote view

We are using multiple instances of Oracle here and I am trying to tune a view we have that has been created on one instance and looks over to another instance. So we have created the view as follows:

CREATE OR REPLACE VIEW The_VIEW ( SSN,
ACCT_NO, CHRG_DATE, BYB_DATE, BILL_QTR,
BILL_YEAR, BWE_DATE, EMP_NAME, BYE_DATE, EMPLR_ACCT_SFX, ORIG_QTR, ORIG_YEAR, PRG_CODE, FUND_CODE, CHRG_CODE, AMOUNT, ODD_YR_IND  ) AS
select "SSN","ACCT_NO","CHRG_DATE","BYB_DATE","BILL_QTR","BILL_YEAR","BW E_DATE","EMP_NAME","BYE_DATE","EMPLR_ACCT_SFX","ORIG_QTR","ORIG_YEAR","P RG_CODE","FUND_CODE","CHRG_CODE","AMOUNT","ODD_YR_IND" from another_view_at_on.the.computer.we.are.trying.to.access

And when we try to do a select * from the_view, we get the following errors: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP and ORA-02063: preceding line from 'the name of the database we are trying to access in the view'. We thought the problem was not having enough space in the TEMP tablespace on the other instance. But we beefed that up and it didn't help. Has anyone encountered something like this or have any suggestions for us? Thanks,
Hardy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT