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

Thread: move partitions

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Hi

    I am trying to move a table partition from one tablespace to another but I am hitting error ORA-14020 anyone know why?

    Oracle 8.1.7 on Windows 2K

    SQL> alter table part1 move partition part1_p1 users;
    alter table part1 move partition part1_p1 users
    *
    ERROR at line 1:
    ORA-14020: this physical attribute may not be specified for a table partition


    Table part1 is just a small table with 2 columns, date and number datatypes (in 8.1.6 there was a bug if the column is varray)


    cheers

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try


    alter table table_name move partition partition_name
    tablespace table_space_name NOLOGGING;


    This should work..

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    oops forgot the tablespace in the syntax

    thanx

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