DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Assigning tablespace

  1. 06-20-2006, 01:19 AM #1
    dba127
    dba127 is offline Junior Member
    Join Date
    May 2006
    Posts
    41

    Assigning tablespace

    Default tablespace DATA01 of user1 got full,
    now i want to assign another tablespace DATA02
    to the user.

    How can i assign it so that further objects creation will
    take place in DATA02?
    Reply With Quote Reply With Quote
  2. 06-20-2006, 03:04 AM #2
    charlton
    charlton is offline Junior Member
    Join Date
    Jan 2002
    Posts
    96
    Hi

    Just a shot in the dark here. But did you try changing the default tablespace of the user to the new Tablespace (data02). Cos once you change the default tablespace of the user to this it should start creating all new objects in the default TableSpace.
    Reply With Quote Reply With Quote
  3. 06-20-2006, 10:58 AM #3
    ixion
    ixion is offline Senior Member
    Join Date
    Jun 2006
    Posts
    259
    Why not resize the datafile for data01. Or add another datafile?
    Reply With Quote Reply With Quote
  4. 06-20-2006, 12:35 PM #4
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Indeed ... hopefully none of the tables or indexes in data01 will want to extend.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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