Re: copy one users table and data to another user

Hi there,

    There are two possible ways. Either you should use the import export utility or simply grant dba privilege to the user in which you want to copy tables and use the following command:

  create table table_name as select * from user_name.table_name;

the only problem will be that you will have to manually assign constraints afterwards because using the above command will not copy constraints.

let me know if this works

good luck

Hassan Received on Thu Mar 28 2002 - 16:50:33 CET