Pipelined table Functions

From: sushma manjunath <sushmam_at_hotmail.com>
Date: Fri, 26 Mar 2004 17:00:30 +0000
Message-ID: <BAY8-F22PrrljXp2Kxn0000e442@hotmail.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Mar 26 2004 - 10:56:55 CST