Johnny must have either the unlimited tablespace privilege (a bad thing) or
a quota on FRANKTBS allowing his objects to be created there. If you don't
allow him to create objects there 'alter user johnny quota 0 on franktbs;'
and import with ignore=y then the objects will get created where you want
them.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"rsdv" <rsdv_at_canisciolti.it> wrote in message
news:bqkd3j$9tv$1_at_fata.cs.interbusiness.it...
> Hello everybody.
> I'm using a Oracle db server 8.1.7 on AIX 5.1L.
> I have a full export performed by system on a total.dmp file.
> I want to duplicate the user JOHNNY whose default tablespace is JOHNNYTBS
on
> the user FRANK that I've created with FRANKTBS default tablespace.
> To do this I use the following command
> imp system/password fromuser=JOHHNY touser=FRANK file=total.dmp
> It happens that JOHNNY objects are imported to FRANK, but phisically still
> in JOHNNYTBS.
> FRANKTBS tablespace is still empty.
> Thank to everybody who can help...
>
>
Received on Wed Dec 03 2003 - 05:03:35 CST
