Re: Copy table data from one schema to another scheman

Doggy Daddy <spamhole_at_nospam.org> wrote in message news:<pan.2003.04.14.15.01.19.466406.15885_at_nospam.org>...
> On Mon, 14 Apr 2003 12:34:52 -0700, L1 wrote:
>
> > Hello All,
> >
> > wonder if you know a simple way (sql, or plsql) to copy table data from
> > one schema to another schema for temporary achival purpose.
> >
> > thanks,
> > l1
>
> Grant SELECT on the table to the archive schema, then connect to the
> archive schema and CREATE TABLE archivetable AS SELECT * FROM
> oldschema.tablename.
>
> You could also EXPORT the table, then IMPORT it into another schema (or
> just keep the export file for your archive), but you said you wanted a SQL
> or PL/SQL solution.

So if I have 40 tables in Schema A, and wanna copy all 40 to schema B, does that mean i have to write that CREATE TABLE script for each one of those 40 tables and bundle them in a procedure? Is there any other easy ways?

Thanks,
l1 Received on Mon Apr 14 2003 - 22:02:01 CDT