All,
I am investingating usage of Pipelined Table Functions for
Transformation and Load into the datawarehouse. The source data is about a
million records. I am using a ref cursor to select the data from the source
and perform data transformations and pipe the row. Finally, a bulk insert
from the table function to the database. Question is where is the table data
stored when I pipe it. I need to monitor space usage to determine if this a
feasibility. Also, how does the space assigned to the Table function shrink
later.
Thanks for all your help in advance.
Sushma
_________________________________________________________________
All the action. All the drama. Get NCAA hoops coverage at MSN Sports by
ESPN. http://msn.espn.go.com/index.html?partnersite=espn
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
