Oracle Database Import and Export, oracle Import and Export

Oracle Database Import and Export, oracle Import and Export

1. Export Oracle Data

A. Use the command line to export data

Exp username/password @ database file = fullpath (for example, D: \ data. dmp) full = y

B. Use the tool (PLSQL Developer) to export data

2. Import Oracle Data

A. Use command lines to import data

(1) create a tablespace and create a username and password.

(2) Import exported data to the database

Imp username/password @ database file = fullpath (for example, D: \ data. dmp)

B. Use the tool (PLSQL Developer) to import data

(1) create a tablespace and create a username and password.

(2) Import exported data to the database

Personal summary, to be continued

Reference: http://blog.itpub.net/21614165/viewspace-766937/