Importing Tables with Partitions

[cchiara]

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...

[slimdave]

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

[cchiara]

Thanks for the prompt reply!