|
-
Thanks for the response guys!
I do use the cascade option when dropping a user (see below).
drop user wts_test cascade;
commit;
create user wts_test identified by wts_test
default tablespace woodlands_data
temporary tablespace temp
quota unlimited on woodlands_data
quota unlimited on temp
profile default;
grant resource to wts_test;
grant connect to wts_test;
revoke unlimited tablespace from wts_test;
So I am thinking it is the way the table was created - like nagarjuna said...the thing is that this export came from a customer of ours and we need to import it here so we can give them support. If they created a few tables that speecified the USERS tablespace, how can I override this and have all objects go to the users default table space (from above)???
My other concern is that I must have objects in the USERS table space and there shouldn't be - hence the error in the first place.
Thanks again for the quick replies!
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|