Re: Oracle Import/Export Problem

The LARRY user does not have the right quota on the USERS tablespace. Grant LARRY the proper quota to create objects in this tablespace.

If that doesn't fix the problem, then it just goes to prove that Microsoft and Oracle don't mix.....

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"