Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1 view
Skip to first unread message

Michael Buresch

unread,
Jul 14, 2001, 12:03:19 PM7/14/01
to
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


Thomas Kyte

unread,
Jul 14, 2001, 1:36:02 PM7/14/01
to
In article <9ipmpq$g6f$07$1...@news.t-online.com>, "Michael says...

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:47812348053

it shows how to in 8i and then in 8.0 and before.

--
Thomas Kyte (tk...@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

Michael Buresch

unread,
Jul 16, 2001, 2:57:17 AM7/16/01
to
Is there a way without IMP/EXP? Can I realize it with PL/SQL Command?

Michael


"Thomas Kyte" <tk...@us.oracle.com> schrieb im Newsbeitrag
news:9ipvu...@drn.newsguy.com...

0 new messages