OraFAQ Forum: Server Administration » buffel

Home » RDBMS Server » Server Administration » buffel_pool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 ..

Report message to a moderator

Re: buffel_pool [message #279778 is a reply to message #279732]

Sat, 10 November 2007 03:48

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

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