TableSpace Question
From: Rob Panosh <rob_panosh_at_asdsoftware.com>
Date: Thu, 6 Feb 2003 15:04:15 -0600
Message-ID: <3e42d182$1_at_nntp01.splitrock.net>
Date: Thu, 6 Feb 2003 15:04:15 -0600
Message-ID: <3e42d182$1_at_nntp01.splitrock.net>
Hello,
If I have a table that is in let say TableSpace "Test" and I want to change it to be in TableSpace "Production" can this be done using an Alter Table statement? Or do I have to create the table and move the data manually? Also can any of the Physical Options ( tablespace, extents, storage, ... ) be changed using an Alter Table Statement?
If it can be done using an Alter Table statement could somebody please give me an example?
Thanks,
Rob Panosh
Received on Thu Feb 06 2003 - 22:04:15 CET