Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace problem

Re: Tablespace problem

From: vk <vijayvk_at_rediffmail.com>
Date: 6 Dec 2001 10:21:43 -0800
Message-ID: <28553be.0112061021.c233691@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US