Re: Copy a table from 1 schema to another

rj wrote:
> Hi all,
>
> What is the statement to copy a table and all content to another
> schema. I dont need a link or any synchronization, just that table.
>
> Thanks in advance..

create <target user>.<table_name>
as select * from <source user>.<table_name> indexes and grants will not be copied automagically, and you'll need CREATE ANY TABLE privilige to complete this action, if you are connected as the source user.

-- 
Sybrand Bakker
Senior Oracle DBA