Home » RDBMS Server » Server Administration » global temporaray table
global temporaray table [message #163760] Sun, 19 March 2006 11:37 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
I am using oracle 9i on windows 2000, I have created a global temporary table using create as select statement, now I, want to alter it to, on commit preserve rows, can I, do it?

Report message to a moderator

Re: global temporaray table [message #163822 is a reply to message #163760] Mon, 20 March 2006 04:15 Go to previous message
Alien
Messages: 292
Registered: June 1999
Senior Member
No.
You'll have to drop and recreate the temp table.

Regards,

Arian

Report message to a moderator

Previous Topic: Archival has been disabled due to space problem
Next Topic: regarding passwordfile authentication
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 18 18:59:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.