Two methods of Oracle export table (i.e. DMP file)

Method One: Use the PL/SQL Developer tool to export: Menu bar---->tools---->export Tables, for example, set the relevant parameters: Method Two: Using the cmd Operation command to export, Details are as follows (note: Method Two is reprinted on-line tutorial):

The 1:g:\oracle\product\10.1.0\client_1\network\admin directory has a Tnsname.ora file with the following contents:
Cmstar =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.18.13.200) (PORT = 1521))
)
(Connect_data =
(service_name = Cmstar)
)
)
Where: Cmstar is the database name, host is an IP address, so you can follow the example above to manually add the data record connection.
2: Enter command line with CMD
Input: tnsping Cmstar
is to test if the 172.18.13.200 is connected successfully.
3: Import and Export, as follows:

Data export:
1 full export of database test, user Name System Password Manager exported to D:\daochu.dmp
Exp system/[email protected]File=d:\daochu.dmp full=y
2 Exporting the system user in the database to the SYS user's table
Exp system/[email protected]File=d:\daochu.dmp owner= (System,sys)
3 Exporting Tables Table1, table2 in the database
Exp system/[email protected]File=d:\daochu.dmp tables= (Table1,table2)
4 Export the field filed1 in table table1 in the database with data beginning with "00"
Exp system/[email protected]File=d:\daochu.dmp tables= (table1) query=\ "where filed1 like ' 0% ' \"

The above is a common export, for compression I do not care, with WinZip to the DMP file can be very good compression.
But add compress=y to the upper order.
Import of data
1 Import the data from the D:\DAOCHU.DMP into the test database.
Imp system/[email protected]File=d:\daochu.dmp
There may be a problem, because some tables already exist, and then it is an error, and the table is not imported.
Add Ignore=y to the back.
2 Import the table table1 in D:\daochu.dmp
Imp system/[email protected]File=d:\daochu.dmp tables= (table1)

Note: Users who export the DMP data need to have permission to export the table, otherwise they cannot export.

Two methods of Oracle export table (i.e. DMP file)