|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/1/2008 5:58:18 AM
Posts: 9,
Visits: 19
|
|
I would like to create a volatile table "UTS" in a database named "ABC". The syntax used was
CREATE VOLATILE TABLE ABC.UTS
(
Sale_Date DATE
,Sum_Sale DECIMAL(9,2)
,Avg_Sale DECIMAL(7,2)
,Max_Sale DECIMAL(7,2)
,Min_Sale DECIMAL(7,2)
)
ON COMMIT PRESERVE ROWS ;
But when I execute this syntax, i get the following error:
"Database name if specified must be the login user name for a volatile table".
Can anyone explain how this could be solved ?
thanks,
newtera
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 7:30:07 AM
Posts: 197,
Visits: 611
|
|
Hello,
Volatile tables are created in a user's session (user space) not in database. So, removing the "ABC." from the DDL will solve the issue.
Regards,
Adeel
|
|
|
|