Re: copy table to another schema programatically
Date: Wed, 09 Jan 2008 06:14:21 -0800
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.orgReceived on Wed Jan 09 2008 - 08:14:21 CST