On Mon, 2006-11-13 at 08:17 -0200, Alexander Burbello wrote: > I have one tablespace with all my objects. > I would like to separate indexes from other. > > How can I select and move with SQL??? > > Thank you for your help.
ALTER INDEX name SET TABLESPACE tablespace_name is the approved way and quicker than re-creating the indexes. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
