Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Unanswered: Oraganizing tables

    Hi, I need to reorg some tables and I have some doubts...
    I'm using Ora817/Solaris8
    1) Perform an export of the table.
    2) Drop the table.
    3) Import the table and data... but, I want to change the storage parameters of the table (init_extent y next _extent, for example).
    Haw can I do that?
    Thanks
    Manf

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    After you drop the table, recreate it with the new storage parameters.
    Then import with ignore=y

  3. #3
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Originally posted by SkyWriter
    After you drop the table, recreate it with the new storage parameters.
    Then import with ignore=y
    Thanks!

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You can also use alter table move to do the reorg as it allows you to change the storage parameters but dont forget to rebuild any invalid indexes afterwards.

    Alan

Posting Permissions

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