Re: Moving tables from a tablespace

1. Do export on the user own those tables without the data itself (exp userid=user/pass file=myfile rows=n index=y ).
2. Do import to an indexfile with the following command :

imp73 file=myfile userid=user/pass indexfile=myscript.sql full=y

3. edit the myscript.sql and change the old tablespace name to the wanted one, and remove the tables u dont wanna move to the new tablespace. Also, make sure that the index create commands will be remark for now. We will run the indexes later.

4. Do a full export to the user own the tables without the indexes with the command : exp userid=user/pass file=fullexp rows=y index=n 5. Drop the user's tables.
6. Re-create them (without the indexes) with the script u generated on step 2-3.
7. Import the data taken on step 4 with the command "imp file=fullexp rows=y full=y userid=user/pass ignore=y"
8. Edit the script from step 2 again and this time make sure it will create only the indexes.
9. Your tables and indexes are now on the new tbs. --
Asaf Shoval
Oracle Israel Support Center

<raju_pillai_at_yahoo.com> wrote in message news:7voea8$4og$1_at_nnrp1.deja.com...
> We have a bunch of tables in a single tablespaces and I would like to
> move them to different tablespaces. I have already created the necessary
> tablespaces for those tables including tablespaces for their indexes.
> Now I am ready to move the tables and the data. How can I do this in the
> most efficient way. I also need the indexes and contraints for those.
> Can anybody suggest me the best way to accomplish this.
>
> Any input is greatly appreciated.
> Thanks
>
> Raju
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 03 1999 - 09:03:15 CST