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: question of user and tablespace

Re: question of user and tablespace

From: <dalalbm_at_my-deja.com>
Date: Wed, 28 Jul 1999 19:45:24 GMT
Message-ID: <7nnmki$bv9$1@nnrp1.deja.com>


In article <7nh0sm$ub0$1_at_nnrp1.deja.com>,   leirace_at_my-deja.com wrote:
> Hi all,
> I have a user in oracle, "myuser",
> default tablespace is "user1", but many table use tablespace
"user2"
> I want put all the table data into tablespace "user1".
> So , I export user "myuser", and recreate user "myuser" set default
> tablespace "user1", then import "myuser.dmp", but these table always
> in tablespace "user2".
> Please tell me how put all data into tablespace "user1" from
"user2"?
> leirace
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Set tablespace Quota on user2 to 0 for the above user and try out. ( u can use Enterprise Manager or server manager to do this)

Also make sure you have not specified tablespace name explicitly in the original create table scripts.

Good luck !

-Bipin.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 14:45:24 CDT

Original text of this message

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