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

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

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

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