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...
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
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio
Thanks for the prompt reply!