Re: Moving tables from tablespace
From: Slava Natapov <Slava_Natapov_at_mail.stil.scitex.com>
Date: 1996/10/17
Message-ID: <3266EF94.703_at_mail.stil.scitex.com>#1/1
Date: 1996/10/17
Message-ID: <3266EF94.703_at_mail.stil.scitex.com>#1/1
Patrick Coulier wrote:
>
> Dear Oracle-newsgroupreaders,
>
> As an Oracle-newbee,
>
> this seems to be the place to ask my simple question:
>
> What's the easiest way to move a table from user USER1 and tablespace TS1 to
> another user USER2 and tablespace TS2 ???
>
> Any help is very appreciated.
>
> Pat
try :
COPY FROM SCOTT/TIGER_at_BOSTONDB -
TO TODD/FOX_at_CHICAGODB -
CREATE NEWDEPT (DNUMBER, DNAME, CITY)-
USING SELECT * FROM DEPT
good luck
- Slava
Received on Thu Oct 17 1996 - 00:00:00 CEST