Re: Oracle Import/Export Problem

Hi,

For an schema import you have to specify full=n. #./imp system/ellison file=bill.dmp FROMUSER=bill TOUSER=larry full=N would be the right command.

regards

   Hartmut Inerle

Hari Om wrote:
> Hi Experts,
>
> I wanted to use Oracle Export and Import utility for my 2 DB Servers
> (both are same version 9.2.0.1)
>
> On one Server, I have an instance "MSFT" with user as "BILL" which has
> around 20 Tables (with data)
>
> On other Server, I have an instance "ORCL" with users as "LARRY".
>
> I would like to COPY, BILL's 20 TABLES to LARRY's Schema.
>
> I tried following:
> #./exp system/gates file=bill.dmp owner=bill
>
> and it showed exported successfully without any ERRORS. The output
> also showed exporting 1000 rows etc....for every table.
>
> Later on different Server, I try to do IMPORT which gives me "
> Privilege Error on TABLESPACE USERS" wonder why?
>
> I tried following...
> #./imp system/ellison file=bill.dmp FROMUSER=bill TOUSER=larry full=y
>
> Any any expert here point out what the Error is?
>
> Thanks!
>
> HARI
Received on Thu Jun 05 2003 - 07:04:26 CDT