Re: copy table to another schema programatically

From: DA Morgan <>
Date: Wed, 09 Jan 2008 06:14:21 -0800
Message-ID: <>

Sean Nakasone wrote:
> anyone have code snippets that copy a table from one schema to another?
> i usually use toad to do this but i really would like to find more
> automated way.

SELECT * FROM schema_name.existing_table;

Why use a tool?

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Jan 09 2008 - 08:14:21 CST

Original text of this message