Results 1 to 2 of 2

Thread: tablespace

  1. #1
    Join Date
    Feb 2006
    Posts
    59

    Arrow Unanswered: tablespace

    hello
    i was thinking wether is it possible to assign a new tablespace to an already created table . basically my database is getting bigger and bigger and i was just thinking of that is it possibl to pull some tables out from the ovrloaded tablespace into a new one if yes then how will my user be givem access to both the tablespaces

    another option is table partitioning but i cant find any guide to it . could you plz reccomend me one ..

    thanks alot

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    where could you possibly be looking for information and not find it?
    you can rebuild a table to a new tablespace.
    you can also convert it to partitioned and then start partitioning it.
    you could also rebuild your indexes online to seperate tablespaces.

    all this can be searched for here:
    PHP Code:
    http://www.oracle.com/pls/db102/portal.portal_db?selected=2 
    I even did a search on "move table" and the first hit was exactly what someone
    would be looking for:
    PHP Code:
    http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm 
    save all these oracle links to your favorites or whatever. this way you always know where
    to go when looking for information.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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