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

Preface

For the native installation of the oracle client, the following commands can be executed in dos, and of course the dmp file is exported locally.

But in actual research and development, no one wants to install huge oracle software on this machine, so you need to use Xshell/puTTY...

The remote tool is connected to Linux to operate and import and export dmp files on Linux.

Text

a. Export the user system user table to the specified path D disk

Exp system/password@SID file=d:/daochu.dmp full=y

b. Export the tables of user system and sys users to the specified path D disk

Exp system/password@SID file=d:/daochu.dmp owner= (system,sys)

c. Export the tables table_A and table_B in the user system to disk D of the specified path

Exp system/password@SID file= d:/daochu.dmp tables= (table_A,table_B)

d. Export the field filed1 in the table table1 in the user system with data starting with "00"

Exp system/passwor@SID filed=d:/daochu.dmp tables= (table1) query=/ "where filed1 like'00% customers /"

For compression, you can use winzip to compress the dmp file, or you can add compress=y to the above command.

The exported DMP file is suitable for full migration of large databases, requires the same character set of both server databases before and after migration, and is not friendly to CLOB field support.

For the export of small data, the practical PLSQL can do better, faster, and the exported SQL is also very intuitive.

e. Import the data from D:/daochu.dmp into the TEST database.

Imp system/password@SID file=d:/daochu.dmp imp system/password@HUST full=y file=d:/data/newsmgnt.dmp ignore=y

If there is a problem with the above command, assuming that some table already exists, you don't have to import the table, and then add ignore=y.

f. Import table table1 from d:/daochu.dmp

Imp system/passord@SID file=d:/daochu.dmp tables= (table1)

Summary

The above is the whole content of this article, I hope that the content of this article can bring some help to your study or work, if you have any questions, you can leave a message and exchange, thank you for your support.

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.