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

question of user and tablespace

From: <leirace_at_my-deja.com>
Date: Mon, 26 Jul 1999 06:57:28 GMT
Message-ID: <7nh0sm$ub0$1@nnrp1.deja.com> 





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.
Received on Mon Jul 26 1999 - 01:57:28 CDT












Original text of this message













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