Re: Copy data from server to local of oracle

l.yn_at_263.net schrieb in Nachricht <7lflca$bid$1_at_nnrp1.deja.com>...
>Hi:
> I have created a tablespace named 'orders_space' on oracle8 server.
>Now I want to move all tables in 'orders_space' to my local pc with
>personal edition of oracle8 installed. Which command I will use?
>
>Thanks!
>
>John l.yn

Hi John ,
create a database link <dblink> on your personal ORACLE . create a script on the server in a spool-file. ...
spool transfer.sql
select 'create table '||table_name||' as select * from '||owner||'.'||table_name||'@<dblink> ;'   from dba_tables
where tablespace_name='ORDERS_SPACE';
...
execute transfer.sql on the PC

• Bernhard