HARI OM wrote:
> SUBJECT: Copying tables form ONE Schema to Another SChema in same
> instance
>
> I am using Oracle 9.2.0.2 on IBM AIX 5.1L System.
> I have a instance names "KHAR" and have 2 SCHEMAS in it namely: "DIN"
> and "MUK".
>
> Schema DIN is in Tablespace DIN and
> Schema MUK is in Tablespace MUK.
>
> I have around 200 populated tables in "Schema DIN" and I took FULL
> Export of this User "DIN" - "din.dmp" last week.
>
> Now, I would like to replicate or copy these DIN Schema Tables to MUK
> Schema's. How can I do that.
>
> I tried doing IMPORT:
> ./imp system/***@khar fromuser=DIN touser=MUK
> and enter the export file as "din.dmp"
>
> It did create these tables under Schema MUK. However, it created it
> under DIN Tablespace and not under MUK Tablespace.....
>
> what is the better way of doing this? what am I doing wrong?
>
> THANKS!
>
> HARI OM
ALTER TABLE MOVE ....
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Oct 04 2004 - 19:44:45 CDT
