Oracle script import and export for new project upgrade

During export, there are stored procedures, functions, triggers, tables, and so on in PLSQL: Export: tool -- gt; Export user object -- gt; multiple select the user object you want to export,

During export, there are stored procedures, functions, triggers, tables, and so on in PL/SQL: Export: tool -- gt; Export user object -- gt; select more user objects to export,

Stored Procedures, functions, triggers, tables, etc.

In PL/SQL:

Export:

Tool --> Export user object --> select the user object you want to export, and select the path of the output script file (SQL file) --> export. A. SQL script file is generated.

Import:

(When cleaning up, you only need to delete all the tables in tables, triggers, stored procedures, and so on. If the same table already exists, there will be no conflicts during import)

Tool --> Import table --> SQL insert --> Import file --> Select File Path --> Import

OK.