Import/export will work but you will have to precreate your schema objects
in the appropriate tablespace and import with ignore=y. Alternatively you
could use alter table blah move tablespace x in 8i and above.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"news.worldonline.com" <___frost_at_dds.nl> wrote in message
news:9v9rmt$7r7$1_at_reader1.tiscali.nl...
> does anyone know how to move a schema to another tablespace ?
> i've tried import/export, but the import ends up in another tablespace
even
> when
> the target schema has a different default tablespace ?~?
>
>
> thanks in advance,
> frost
>
>
Received on Thu Dec 13 2001 - 03:58:55 CST
