On Fri, Jan 31, 2014 at 1:24 PM, alexandros_e <alexandros(dot)ef(at)gmail(dot)com> wrote:
> Hello to all,
>
> I have done ALTER DATABASE "[database_name]" SET default_tablespace =
> [new_tablespace]; I am wondering, if I reindex this entire DB would the
> indexes automatically moved into the [new_tablespace] or will they remain in
> the tablespace they were originally created on;
They remain on the tablespace they have been created on. Note as well
that the new value of default_tablespace takes effect only after
reloading the session.
Regards,
--
Michael