Importing Tables with Partitions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Importing Tables with Partitions

  1. #1
    Join Date
    Feb 2002
    Posts
    48

    Wink Importing Tables with Partitions

    Hi,

    I exported a schema with partitions created for some tables. I try to import the exported dump file
    to another user. I wonder will the partitions be automatically created during import or I need to create the partitions manually BEFORE the import.

    Thanks in advance...

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    If the tables do not already exist, then they will be created with partitions, yes.

    You can see the create table statements before hand by importing the file with the "indexfile=my_file.sql" option, and then open my_file.sql to see the create table and create index statements
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Feb 2002
    Posts
    48
    Thanks for the prompt reply!

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