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

Thread: moving objects between tablespaces

  1. 10-22-2002, 09:12 AM #1
    DcsoBob
    DcsoBob is offline Junior Member
    Join Date
    Feb 2001
    Posts
    99

    Question

    Hi all,

    I know that under 8i an above, it is very easy to move a table or index from one tablespace to another. However, can this be done in 7.3.4? I cannot use the 8i command.

    So, how to do this? Do I have to drop and recreate the object or can I do an alter table command and change the tablespace name in the storage clause?

    Tks
    Bob
    Reply With Quote Reply With Quote
  2. 10-22-2002, 09:37 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You can't change tablespace parameters with an ALTER TABLE in 7.3.4

    I think your only options here are:

    1. CREATE TABLE xxx AS SELECT * FROM xxx

    2. Export/Import

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 10-22-2002, 04:58 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    ALTER INDEX REBUILD is available in 7.3.4, I think.
    Jeff Hunter
    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