Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hot to copy tables from one oracle user to another

Re: Hot to copy tables from one oracle user to another

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Sat, 31 May 2003 18:49:30 GMT
Message-ID: <3ED8F7C6.4AEC3D1B@telusplanet.net>


Carsten Saager wrote:

> "Hans Forbrich" <forbrich_at_telusplanet.net> schrieb im Newsbeitrag
> news:3ED8E2C1.FCBAB92E_at_telusplanet.net...
> > "Yuri Weinstein (HotMail)" wrote:
> >
> > > and users are on different orcale servers?
> >
> > Many variants - one being exp/imp (export / import)
> >
> or the COPY command of sqlplus ... needs less privileges

True. Totally forgot about that one since I haven't used that in ages. I stopped using it because it tended to miss supporting dictionary features (eg: indexes) and requires database links for the purposes indicated.

So back to OP - need more information on what you are trying to acomplish. Received on Sat May 31 2003 - 13:49:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US