Originally I had created a tablespace for users, and assigned all of the users to that tablespace. couple of weeks later, decided to drop that tablespace and create a new one.
alter user foo default tablespace (new tablespace).
but when I went to do a query on the users and its tablespace name. it still shows the users with the old tablespace.
how do I correct this?
How do you check the tablespace for the user? (SQL Query)
acutally I was checking on the quotas.
thats when I notice that the tablespace_name was from the old one.
select username, tablespace_name, bytes /1024 "MB"
decode(max_bytes,-1,'unlimited', rpad(max_bytes /1024, 9)) "MB"
order by 1, 2;
Ok, that's another history :) Just remember to allocate the tables already created in the olf tablespace to the new tablespace, and to give quotas to the users involved
Click Here to Expand Forum to Full Width