Only migrate all Oracle stored procedures or functions to other databases

In exp and imp, there is no syntax for exporting only stored procedures. If a user's data is exported, all objects (tables, views, indexes, sequences, functions, stored procedures, triggers, etc.) of the user will be exported ).

If only all stored procedures are exported. PL/SQL Developer is more convenient and fast.

1. Export the stored procedure to text

In PL/SQL Developer's "Tools"-> "Export User Objects", you can select all the User's stored procedures and Export them into a text file.

2. Import the data to another database. Use @ \ to export the text file in sqlplus.

The above can also be used to export only all views, functions, triggers, and so on.