Converting multi table tablespaces into uni table tablespace



IBM's flagship relational database management system

Converting multi table tablespaces into uni table tablespace

Postby suresh_48 » Mon Aug 15, 2011 7:06 pm

Hi,

Can u tell me the process of Converting multi table tablespaces into Uni table tablespaces.
Thanks in advance
suresh_48
 
Posts: 1
Joined: Thu May 26, 2011 10:39 am
Has thanked: 0 time
Been thanked: 0 time

Re: Converting multi table tablespaces into uni table tables

Postby dick scherrer » Tue Aug 16, 2011 9:23 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Converting multi table tablespaces into uni table tables

Postby suresh48 » Tue Aug 16, 2011 12:51 pm

thank you very much
suresh48
 
Posts: 5
Joined: Fri Jan 07, 2011 4:50 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post