Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Upgrade Express: moving a table to a different tablespace

    Upgrade Express: moving a table to a different tablespace

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20

    Question

    Is it possible to move things around using the file_list or some other mechanism, that is, to condense and combine some tablespaces as part of an upgrade?

    Answer

    The Upgrade Express Data Pump import is done at the library level. The file-03/file-04 (Export/Import) services can be used to export/import an individual table. Prior to running the file-04 import the table's file_list entry could be changed to a different tablespace and the drop/recreate of the table done using util a/17/1. util a/17/1 looks at the file_list to see what tablespace should be used.

    It should be noted that file-03/file-04 take much longer than the Data Pump. Large tables such as the z98 can take 10 hours or more in a million-record database.

    Additional Information

    The following is seen at http://docs.oracle.com/cd/E16655_01/server.121/e17636/transport.htm#ADMIN11396 :

    "You can use the REMAP_TABLESPACE import parameter to import the database objects into a different tablespace."

    But it *seems* that since the Upgrade Express Data Pump import is done at the library level, the whole library would need to be remapped to a different tablespace.

    It may be that the $aleph_proc/oracle_impdp_table or ./oracle_imp_table (for importing an individual table) could be modified to change the tablespace (using REMAP_TABLESPACE?).

    Category: Installation & Upgrades (500)


    • Article last edited: 7/3/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Upgrade Express: Missing directory on server?
      • Upgrade Express: non-data-pump file used when data-pump file exists
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Installation & Upgrades (500)
      4. Prod:Aleph
      5. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved