No, just something that will force my global temporary table session segment to stay in memory, instead of going to tempfile. On 1/13/06, Tanel Põder <tanel.poder.003@xxxxxxx> wrote: > Are you talking about materialize hint? > > Tanel. > > ----- Original Message ----- > From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx> > To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>; "oracle-l" > <oracle-l@xxxxxxxxxxxxx> > Sent: Friday, January 13, 2006 10:58 AM > Subject: Hint for in memory temporary table? > > > > Hello, > > > > Do you guys remember what was the hidden/special hint to create a > > global temporary table in memory or to force the data to stay in > > memory? > > -- > //www.freelists.org/webpage/oracle-l > > > -- Christo KutrovskySenior Database/System AdministratorThe Pythian Group -- //www.freelists.org/webpage/oracle-l