Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Move schema and tablespace
Check out my pretty printer http://pretoria.sourceforge.net/ ...
http://sourceforge.net/projects/pretoria for indexfiles - it's not perfect
but good enough for the job
"godmann" <allanwtham_at_yahoo.com> wrote in message
news:95cd51c.0202261937.4e5b995b_at_posting.google.com...
> Hi there,
>
> To import into different tablespace,
> do an import blah indexfile=blah.sql
>
> Modify the blah.sql. Change all the Create Table ...Tablespace xxx
> to yyy that you want. Run the blah.sql and import again with ignore=Y
>
>
> Allan W. Tham
> Oracle DBA
Received on Wed Feb 27 2002 - 12:10:03 CST