Re: copy table to another schema programatically

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.

CREATE TABLE new_table AS
SELECT * FROM schema_name.existing_table;

Why use a tool?

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org