Re: Hows to copy data, views, procedures from a tablesapce to another tablespace in ORA 8.0.x

From: Michael Buresch <MBu_at_b-w-computer.de>
Date: Mon, 16 Jul 2001 08:57:17 +0200
Message-ID: <9iu38h$t57$06$1_at_news.t-online.com>


Is there a way without IMP/EXP? Can I realize it with PL/SQL Command?

Michael

"Thomas Kyte" <tkyte_at_us.oracle.com> schrieb im Newsbeitrag news:9ipvu208hr_at_drn.newsguy.com...
> In article <9ipmpq$g6f$07$1_at_news.t-online.com>, "Michael says...
> >
> >Hallo,
> >
> >how can I copy all data, views, procedureces (and so on) that I have in
 one
> >tablespace to another tablespace in ORA 8.0.x?
> >
> >Best regards,
> >Michael
> >
> >
>
> views, procedures and so on do not live in tablespaces -- only things that
> consume storage (tables, indexes, materialized views and the like) live in
> tablespaces.
>
> If you mean "schema" instead of tablesapce, then
>
> exp userid=u/p owner=old_schema
> imp userid=u/p fromuser=old_schema touser=new_schema
>
> If you want to move tables, see
>
>
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:478123480 53
>
> it shows how to in 8i and then in 8.0 and before.
>
> --
> Thomas Kyte (tkyte_at_us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Mon Jul 16 2001 - 08:57:17 CEST

Original text of this message