Re: Moving Tables from Tablespace A to Tablespace B

Another way ( there's allways another way :-) )

• Export
• Take first tablespace offline ( Or remove TOUSER's rights to it )
• Be sure new tablespace is online and is the TOUSER's default
• Import

[ the old tablespace will be used if it is available and the TOUSER has rights to it, so the second step is needed to insure complete move of all objects. ]

Hope it helps,
John.Greco_at_dot.state.mn.us
Oracle 7.3/Netware DBA

lgmiller_at_elmrd.u-net.com (Graham Miller) wrote:

>Hello,
> I think the following should do it:
>
>1) export table.
>2) Drop it.
>3) Create table with new storage and/or new tablespace.
>4) Import - telling import to ignore errors when trying to create
>existing objects.
>
>No it is not easy.
>
>Another way if you have the room is to Rename and Copy?
>Or rename and create table using as ... (query).
>
>I would go for the export and import.
>
>graham (aka grumpy)
>
>"Tim Romano" <tim_at_ot.com> wrote...
>
>| Is there an easy way to move a table to another tablespace? Such as:
>|
>| MOVE mytable from Tablespace1 to Tablespace2
>|
>| How can one guarantee that objects get created in a particular tablespace
>| when they're imported? (Setting the DefaultTablespace of the TOUSER does
>| not seem to be 100% effective.)
>|
>| Could you please cc: me at tim_at_ot.com if you respond to the list. Thank
>| you.
>| Tim
>
>Graham Miller ...
>Opinions expressed are mine, they are free, and worth exactly what they cost.
Received on Mon Jun 09 1997 - 00:00:00 CDT