Thanks for the reply. But my question is how can I prevent this while importing so I don't have to run another script after that. On Thu, Jan 29, 2009 at 11:31 PM, David Ballester <ballester.david@xxxxxxxxx > wrote: > Alter table .... modify default attributes tablespace <tablespace > > > if this table has partitions, use: > > Alter table ... modify default attributes for partition <partition> > tablespace <tablespace> > > HTH > > D. > > > >