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

Thread: moving a table to another tbs

  1. #1
    Join Date
    Sep 2006
    Posts
    19

    moving a table to another tbs

    Hi

    We have a user table which is lying in system tbs and there is only one field in that and its type is LONG. Now when we try to move the table to some other tbs i am geting ora-00997 illegal use of long type. . can any one help us to move the table to the respective tbs.


    Thanks

  2. #2
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Please be more specific. What exactly you do to move the table?

  3. #3
    Join Date
    Sep 2006
    Posts
    19
    Hi

    thanks for your reply.

    In 2005 my predecessor by mistake created a table in system tablespace which has only one field and the field type is LONG. now i am trying to move the table to another tablespace by
    " alter table table_name move tablespace tablespace_name " .

    When i execute the above command i am getting the following error

    " ora-00997 illegal use of long type".

    Can you tell me how to move a table having field type LONG to another tablespace.

    Regards

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Metalink Note:147356.1 says:
    "The drawback to using
    this method is the you cannot move a table with a LONG or LONG RAW. You
    must exp that table and imp it into a table. You can do this easily by
    exporting the table with the LONG/LONG RAW, dropping that table
    -- creating an empty version of this table in the new tablespace and
    importing just that table."
    Metalink Note:1012307.6 explains how to move table using exp/imp

    Regards

  5. #5
    Join Date
    Sep 2006
    Posts
    19
    Thanks bore

    I will just check up the metalink and try the same. Thanks a lot

    Regards

  6. #6
    Join Date
    Mar 2007
    Posts
    1
    mvove table tablename to tablespace

  7. #7
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Quote Originally Posted by dba_45
    now i am trying to move the table to another tablespace by
    " alter table table_name move tablespace tablespace_name " .

    When i execute the above command i am getting the following error

    " ora-00997 illegal use of long type".

    Regards
    It is maybe a good idea to read the thread before posting dummy posts

    Regards

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