Realocate Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Realocate Table

  1. #1
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56

    Realocate Table

    Good Afternoon all

    I have some tables I wanna realocate from one to anoter tablespace, but not getting 'cause it has fields with data type LONG , but, I need to do it, 'cause another people created this BD and that table are in SYSTEM tablespace.

    That's my questio: How can I realocate tables with LONG data type.

    I am using Oracle 9i!

    Very sincere thanks to all!!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Hi

    Hi

    I think it is not possible to move a table with LONG column. You need to

    1. Export the table
    2. Re-create the table in the required tablespace or change the default tablespace to the target tablespace
    3. Import the table.

    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56
    I agree that is a good method, but, let's imagine I have already one hundred tables I want to realocate!! Is there another more simple way to do it??
    Anyway, thanks by your answer!!!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    If you are very much comfortable with MOVE try to move all the tables WOTHout LONG column and user export/Import for LONG column tables.

    Or

    You can get the list of tables as follows

    select object_name
    From dba_objects
    where owner not in ('SYS', 'SYSTEM') and
    object_type='TABLE';

    Export all this tables using the TABLE option. So in one step it is over..



    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56
    Good!
    MOVE, I have done. I will try to follow other steps.

    Really thanks!

    Peace to you
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

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