Re: Oracle V7.0.12 import bug

In article <1993May4.210658.2059_at_lgc.com>, frank_at_lgc.com (Michael Frank) writes:
|> Currently the version 7 imp utility parameter touser
|> does not write into that users default tablespace
|> if it does not have permission on the tablespace
|> specified in the exported files. For example I
|> export user1 tables and I wish to import into
|> user2 who has a different tablespace.
|>
|> I am running SunOS 4.1.3.
|>
|> Oracle claims that this will be fixed in release 7.0.13 in
|> mid-June. In the mean time I am left hanging.
|>
|> If anyone knows a workaround or is also having this
|> problem please email me.

I'll follow up as it may be of general interest....

Alter user USERID quota 0 on TABLESPACE;

As the user has no space left on the tablespace, import uses the default instead.

|>
|> Thanks
|>
|> Mike Frank
|> frank_at_lgc.com
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com        Phone: +44 224 242637