Re: Moving tables from a tablespace

I tried this, but I have a problem. When I executed the step 2(the indexfile step) i found that the primary key and the foreign key contraints are missing in my ddls and also there were some procedures defined and they are also missing. How can I get these also in the indexfile. Any help is appreciated.
thanks in advance

Raju

In article <7vpidd$m26$1_at_news2.inter.net.il>,   "sysdba" <sysdba_at_inter.net.il> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 04 1999 - 16:57:28 CST