Archives of the TeradataForum
Message Posted: Wed, 03 Dec 2003 @ 09:13:23 GMT
<-- Anonymously Posted: Wednesday, December 03, 2003 03:53 -->
If I log in as PRODDBA and execute
CREATE GLOBAL multiset TEMPORARY TABLE call_hist ( call_service_no varchar(30) ,call_start_dt date format 'yyyy-mm-dd' ) primary index (call_service_no) on commit preserve rows;
The table gets materialised in user PRODDBA's Temp Space.
But what happens if I say explicitly qualify it with a Database name while creating table. What is the difference between the 2 SQLs and its impact.
CREATE GLOBAL multiset TEMPORARY TABLE DBNAME.call_hist ( call_service_no varchar(30) ,call_start_dt date format 'yyyy-mm-dd' ) primary index (call_service_no) on commit preserve rows;
In the second instance does the table behave as a normal table. Or is it that the table is still a Global Temp table and will be materialised in User Temp Space.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|