Roles of catexp. SQL

Roles of catexp. SQL

The view required by export is created by catexp. SQL. These internal views are used to organize dump files in export. Data format. Most views are used to collect and create DDL statements. Others are mainly used by Oracle developers. These views may vary with Oracle versions, and each version may have new features. Therefore, an error occurs when you execute the old dump file in the new version. You can generally execute catexp. SQL to solve these problems, The general steps for solving backward compatibility problems are as follows: When the exported database version is earlier than the target database version: -Execute the old catexp. SQL statement in the target database to be imported. -Use the old export to export the dump file -Use the old import to import data to the database -Execute the new catexp. SQL statement in the database to restore the export view of this version. When the exported database version is newer than the target database version: -Execute the new catexp. SQL statement in the target database to be imported. -Use the new export to export the dump file -Import data to the database using the new import. -Execute the old catexp. SQL statement in the database to restore the export view of this version.