Import and export Oracle table structure data with Plsql

First, export

(1) Export data

Go to PL/SQL, "Tools"----> "Export Tables ...", then select the table to export in the popup dialog and click "Export"

(2) Export table structure

Go to PL/SQL, "Tools"----> "Export User Objects ...", then select the table to export in the popup dialog and click "Export"

Two

(1), create namespaces (see my other blog)

(2), create user and select namespaces

(3), log in PL/SQL with the user created

(4), Import DMP file

1. Go to PL/SQL, "Tools"----> "Import Tables ...", then select the DMP file in the popup dialog and import.

(5), then the non-existent table structure in DMP is imported

1. Go to PL/SQL, "file"----> "Open"----> "command File" to select the file and execute the command

Import and export Oracle table structure data with Plsql