Re: Copying schema objects from one user's schema to anothers

Joseph Panico wrote:
>
> Can someone tell me how to copy tables from one user's schema to
> another's?

  You can use export/import, COPY statement of SQL*Plus or CREATE TABLE AS (SELECT...). Each one has its drawbacks and merits. I would like to discuss with you if you want to have more information on it.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.