Shulou(Shulou.com)06/01 Report--

Principle: data export through the exp.exe tool of the Oracle BIN directory

2019.01.10 cmd window imports and exports table .sql file

2019.04.30 PL/SQL tool imports and exports table .pde files-this file is the fastest when there is a large amount of data

-

2019.4.30 9:48 Update

-

-

2020.2.21 updated at 17:21

-

Export table .pde

Select tools-"Export table options

two。 Select the PL/SQL Developer bar-- "Save as the file name you want--" to export.

Import table .pde

Select tool-"Import Table option"

two。 Select the PL/SQL Developer column-- "Select .pde file--" Import

-

-

Export table .dmp file

1. Open CMD,cd to the BIN directory in the Oracle database installation directory

two。 Export the emp table from the scott user orcl database to disk D, with the file name emp.dmp

Exp scott/123456@orcl tables= (emp) file=d:\ emp.dmp

Export the data of other users with administrator privileges

Exp userid=system/123456@orcl owner= (scott) tables=SDA file=d:\ emp.dmp

Import table .dmp files

1. Open CMD,cd to the BIN directory in the Oracle database installation directory

two。 Import the file on disk D named emp.dmp table to the scott user orcl database

Imp scott/123456@orcl fromuser=SDA touser=SCOTT file=D:\ emp.dmp log=D:\ emp.log full=y ignore=y

Scott/123456@orcl: username / password @ database name

Fromuser=SDA: user name of the data exported by fromuser=

Touser=SCOTT: to which user the touser= will be imported

File=D:\ emp.dmp: location of the file=dmp file

Log=D:\ emp.log: where to put the information generated when log= imports data (automatically created) [optional]

Full=y: everything in the import file [optional: import all by default]

Ignore = y: equivalent to, if there is no table, create and import data, if you already have a table, ignore the created table, but not ignore the import [optional]

-

Note:

If you are importing on an AIX server, the file needs to write an absolute path, even if cd reaches that path and then imp. Otherwise, an error is reported: IMP-00002: failed to open * * .dmp for read

-

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.