Home » RDBMS Server » Server Administration » buffel_pool
buffel_pool [message #279732] Fri, 09 November 2007 16:24 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
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

Re: buffel_pool [message #279820 is a reply to message #279778] Sat, 10 November 2007 15:04 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

where is the table by default ?
Re: buffel_pool [message #279838 is a reply to message #279820] Sun, 11 November 2007 00:16 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The default pool is...(tada) DEFAULT.

Regards
Michel
Previous Topic: Invalid objects and ORA-00942 error
Next Topic: XDB.PATH_View and XDB.Resource_View missing
Goto Forum:
  


Current Time: Wed Dec 07 05:04:35 CST 2016

Total time taken to generate the page: 0.12685 seconds