Re: Copy table data from one schema to another scheman

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. Received on Mon Apr 14 2003 - 17:01:20 CDT