Oracle Import/Export Problems

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 Tue Jun 03 2003 - 23:36:12 CEST