Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Copying tables ?

Re: Copying tables ?

From: Steve Phelan <stevep_at_no-spam.pmcgettigan.demon.co.uk>
Date: 1997/06/09
Message-ID: <339BEE56.553119E4@no-spam.pmcgettigan.demon.co.uk>#1/1

John Duska wrote:

> What's the easiest way to copy an existing table & its data from one
> schema to another?
> thanks
> John
>
>
> -------------------------------------------------------------------------------------------------------------
>
> John Duska <duska_at_srfs.pitt.edu>
> Senior Systems Analyst
> University of Pittsburgh
>
> John Duska
> Senior Systems Analyst <duska_at_srfs.pitt.edu>
> University of Pittsburgh
> USA Netscape Conference Address
> Netscape Conference DLS Server
> Additional Information:
> Last Name Duska
> First Name John

  1. Try using the CREATE TABLE ... AS ... command (SQL).

OR

2. Try the IMPort/EXPort utility.

Steve Phelan. Received on Mon Jun 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US