oracle imp命令 自动生成create table 为什么还有 alter table

The "imp" command in Oracle is used to import database objects from an export dump file. When importing tables, the "create table" statement is used to generate tables in the new database. However, sometimes there may be changes to the table structure in the new database that require alterations to be made. This is where the "alter table" statement comes in - it allows for modifications to be made to an existing table, such as adding or dropping columns, modifying the data type of existing columns, adding constraints, and so on. Therefore, it is not uncommon to see both "create table" and "alter table" statements used in the context of an Oracle "imp" command.