Re: Moving Table in Tablespace

But keep in mind, that you have to create the table in the new tablespace before you start the import,
otherwise your tables are created in the old tablespace, or if it doesn't exist, the import will fail.

an other way would be "create table xyz as select * from abc" with the correct tablespace and
storage clause. the drawback is that you don't get the constraints, indexes, grants and so on
automatically.

rgds
eugen

Eugene Firyago wrote:

> export/import
>
> Duarte Nuno Sousa <Duarte.Sousa_at_solsuni.pt> wrote in message
> news:38E9E89A.5576F60_at_solsuni.pt...
> >
> > What is the best mode of moving tables, with data, across Tablespaces ?
> >
> > Duarte Nuno de Sousa
> > duarte.sousa_at_solsuni.pt
> >
> >
Received on Tue Apr 04 2000 - 00:00:00 CDT