Re: Table reorg.. what's the best way?

On Thu, 04 May 2000 16:38:22 GMT, Tom <ray.thomas_at_pmlmail.com> wrote:

Well, to re-create the tables in new tablespaces you have a couple of optons :

export tables first, then ...

1. create table <new table> as select * from <old table> tablespace <new tablespace>;

   drop <old table>;

   rename <new table> to <old table>; -- or something like that

  or ...

2)

     import, using the export dump above, with indexfile=gigo.sql,
     edit gigo.sql, remove REM, change tablespace to reflect new
     tablespace, run script

then ...

import with ignore=y

>Hi all,
>
>I have 2 large tables with many extents. I have been instructed to move
>these tables to their own tablespace and reorg them at the same time. I
>have to create a tablespace, export the two tables and everything
>associated with them and import them into the new tablespace without
>losing any indexes, constraints, grants etc. Can anyone suggest the
>best method to accomplish this without losing anything in the process?
>
>Tom
>Please reply to: ray.thomas_at_pmlmail.com
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu May 04 2000 - 00:00:00 CDT