Moving Tables from Tablespace A to Tablespace B 
Author Message
 Moving Tables from Tablespace A to Tablespace B

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.)


you.
Tim



Tue, 23 Nov 1999 03:00:00 GMT
 Moving Tables from Tablespace A to Tablespace B

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)

| 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.)
|

| you.
| Tim

Graham Miller ...
Opinions expressed are mine, they are free, and worth exactly what they cost.



Wed, 24 Nov 1999 03:00:00 GMT
 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,

Oracle 7.3/Netware DBA

Quote:

>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)


>| 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.)
>|

>| you.
>| Tim

>Graham Miller ...
>Opinions expressed are mine, they are free, and worth exactly what they cost.



Fri, 26 Nov 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. moving tables from the system tablespace to a new tablespace

2. moving data from 8.0.5 user_data tablespace to 8.1.7 users tablespace

3. How to Move Tables to Other Tablespaces?

4. Move a table from one tablespace to another

5. alter table move tablespace .... another question

6. alter table move tablespace....

7. Move table to another tablespace

8. Move a table from system to another tablespace

9. Moving a table from one Tablespace to another

10. Move table on an other tablespace

11. move table across tablespace

12. Availability of table or index while moving to a different tablespace


 
Powered by phpBB® Forum Software