| buffel_pool [message #279732] |
Fri, 09 November 2007 16:24  |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
hello ,
how do i roll back the statement
alter table a storage(buffer_pool keep);
is it alter table a storage(buffer_pool recycle); ???
please let me know ..
|
|
|
|
| Re: buffel_pool [message #279778 is a reply to message #279732] |
Sat, 10 November 2007 03:48  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ You can't rollback a DDL
2/ You can use another DDL to do the opposite, in this case you have to know in which pool was your table before the first statement in order to put it back there .
Regards
Michel
[Edit: nothing]
[Updated on: Sun, 11 November 2007 00:14] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
