What Database are you using?? With Oracle you can run an SQL statement to move the table from one tablespace to another. Other databases should have similar abilities.
ALTER TABLE tablename MOVE TABLESPACE new_tablespace; Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of nsachin Sent: Monday, January 05, 2009 4:02 AM To: [email protected] Subject: archiving in different tablespace Hello All, I am doing archiving of some of the forms.But the data is getting archieved in SYSTEM tablespace rather than ARSYSTEM tablespace.As the number of records in these tables get bigger every now and them,i m getting error that SYSTEM tablespace is almost full. How would i ensure that the data is archived in ARSYSTEM tablespace? Regards, Sachin _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
