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

1. EXPDP must be dierctory

2. EXPDP can export empty tables with no allocated space.

3. During the export of EXPDP, a JOB will be created and a table SYS_EXPORT_SCHEMA_01 will be generated, and then automatically deleted after import, so EXPDP cannot operate in read only mode.

4. EXP exports the table in alphabetical order, while EXPDP randomly exports the table.

5. By default, under the same condition (without such parameters as compression), EXPDP export is faster and the generated files take up less disk space.

6. EXPDP is a server program, which is only available when oracle server is installed, and the exported files are stored on the server; EXP is a client program, oracle client is installed, and EXP is installed because oracle server contains oracle client, and the exported files are stored on the client.

EXPDP can be executed off-machine, as long as you connect to a different server through tnsname.

A server executes as follows

Expdp system/123456@B directory=dumdir dumpfile= hr.dmp schemas=hr

Exp system/123456@B file=/home/oracle/ hr2.dmp owner=hr

Server B corresponds to the directory / home/oracle of tns corresponding to directory=dumdir whose name is Bmaine B server.

Hr.dmp is stored on server B

/ home/oracle/ hr2.dmp is stored on server A

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.