Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace problem
Change the default tablespace of the user who runs the import (might
not be user abc) to the tablespace you want to import to. For
example:
ALTER USER import_username DEFAULT TABLESPACE
destination_tablespace;
Make sure the import user has quota in the destination tablespace
I think currently the default tablespace for the import user is
SYSTEM.
Daniel
aadil_at_loveable.com (adil) wrote in message news:<2f4ab398.0112060332.73bb61fa_at_posting.google.com>...
> i took a dmp from 8.1.6 of user abc and trying to import it in user
> abc in 8.1.7
> which is linked with def tablespace. but when i view the user abc it
> shows linking with system tablespace. i have also given quota 0 on
> system How do i connect it to def tablespace.
Received on Thu Dec 06 2001 - 13:09:48 CST