Hi
Before import set quota 0 on user2 to myuser.
>> 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 - 03:12:31 CDT
