Home > database >  Oracle data migration issues
Oracle data migration issues

Time:10-08

1, imp import, if the exported data involving multiple table Spaces, then how I imp Settings,
Is the need to create a lot of you a table space,
2, if there are 2 g exp export, I need to create 2 g table space, the system will create your own

CodePudding user response:

Need to manually create a table space, export import will not automatically export table space create statements, also won't import table space

CodePudding user response:

refer to the original poster young - dba reply:
1, imp import, if the exported data involving multiple table Spaces, then how I imp Settings,
Is the need to create a lot of you a table space,
2, if there are 2 g exp export, I need to create 2 g table space, system will create a

1, all need to manually create a table space;
2, the need to create, but not necessarily accurate is 2 g, system will not create your own,

CodePudding user response:

refer to the original poster young - dba reply:
1, imp import, if the exported data involving multiple table Spaces, then how I imp Settings,
Is the need to create a lot of you a table space,
2, if there are 2 g exp export, I need to create 2 g table space, system will create a


1. The need to manually create in advance before the import
2. Don't need to create a table space is derived, if import need to create the corresponding table space, the size in bytes reference dba_segments,
Export 2 g, it is logical DMP, general space size is greater than this amount,
  • Related