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: Copying schema objects from one user's schema to anothers

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

From: Simon Goland <sg_at_mda.ca>
Date: 1997/02/20
Message-ID: <330CAB53.1121@mda.ca>#1/1

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

One possible way is to use export/import. You export all you need, and when importing, create a parameter file with

FROMUSER=<name of the originator user>
TOUSER=<name of the target user>

-- 
[ Simon Goland       B-)>     sg_at_mda.ca ]
[   Without action there is no change   ]
Received on Thu Feb 20 1997 - 00:00:00 CST

Original text of this message

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