Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace problem
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.
alter user abc idenitified by 'password'
default tablespace def
QUOTA UNLIMITED ON def;
Received on Thu Dec 06 2001 - 12:21:43 CST