DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2001


    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?


  2. #2
    How do you check the tablespace for the user? (SQL Query)
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Feb 2001

    ok, miswored.

    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"
    from dba_ts_quotas
    order by 1, 2;

  4. #4
    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
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.