Clone database objects with dynamic SQL

(Scott Stephens) If you want to take a copy of one table and make a copy of it in another schema (under another username), you can use the SQL*Plus COPY command, or a simple "create table foo as select * from other.foo;", as long as you have select privileges on the other user’s table.

Read More - Register for Free Membership