Page 1 of 1

Converting multi table tablespaces into uni table tablespace

PostPosted: Mon Aug 15, 2011 7:06 pm
by suresh_48
Hi,

Can u tell me the process of Converting multi table tablespaces into Uni table tablespaces.
Thanks in advance

Re: Converting multi table tablespaces into uni table tables

PostPosted: Tue Aug 16, 2011 9:23 am
by dick scherrer
Hello and welcome to the forum,

One way would be to define a new single-table tablespace, unload the multiple tables to sequential files, and then load these into the new table.

Re: Converting multi table tablespaces into uni table tables

PostPosted: Tue Aug 16, 2011 12:51 pm
by suresh48
thank you very much