oracle9i用expdp导出全库,请教expdp或者exp，全库导出可以选择不要数据吗

10g以前版本不支持expdp ，因此楼主这种情况只能使用exp/imp方式

因为源库的9i版本，所以源库和目标库只能使用exp/imp工具

exp system/oracle full=y file=full.dmp rows=n consistent=y

需要注意

imp工具的版本必须与目标库相同

exp工具的版本必须与源库或者目标库中版本较低的相同

exp工具的dmp文件只能用imp工具导入

任何exp的dmp文件可以imp到高版本的oracle database中

Any export dump file can be imported into a later release of the Oracle database.

The Import utility cannot read export dump files created by the Export utility of a later maintenance release. For example, a release 9.2 export dump file cannot be imported by a release 9.0.1 Import utility.

Whenever you are moving data between different releases of the Oracle database, the following basic rules apply:

The Import utility and the database to which data is being imported (the target database) must be the same release. For example, if you try to use the Import utility 9.2.0.7 to import into a 9.2.0.8 database, then you may encounter errors.

The version of the Export utility must be equal to the release of either the source or target database, whichever is earlier.

For example, to create an export file for an import into a later release database, use a version of the Export utility that equals the source database. Conversely, to create an export file for an import into an earlier release database, use a version of the Export utility that equals the release of the target database.

In general, you can use the Export utility from any Oracle8 release to export from an Oracle9i server and create an Oracle8 export file.

Restrictions When Using Different Releases of Export and Import

The following restrictions apply when you are using different releases of Export and Import:

Export dump files can be read only by the Import utility because they are stored in a special binary format.

Any export dump file can be imported into a later release of the Oracle database.

The Import utility cannot read export dump files created by the Export utility of a later maintenance release. For example, a release 9.2 export dump file cannot be imported by a release 9.0.1 Import utility.

Whenever a lower version of the Export utility runs with a later release of the Oracle database, categories of database objects that did not exist in the earlier release are excluded from the export.

Export files generated by Oracle9i Export, either direct path or conventional path, are incompatible with earlier releases of Import and can be imported only with Oracle9i Import. When backward compatibility is an issue, use the earlier release or version of the Export utility against the Oracle9i database.