Oracle database SYS and System password modifications, database data Export Import (DMP) __python

unlock accounts: Alter user account unlock

Login sys User: Sqlplus/as sysdba

Modify SYS User: ALTER user sys identify by password

Modify SYSTEM User: Alter user system identified by

Data export:
 1 completely export database test, user Name System Password Manager exported to D:\daochu.dmp
   exp system/ Manager@test file=d:\daochu.dmp full=y
 2 Export the table of the system user and SYS user in the database
   exp system/ Manager@test file=d:\daochu.dmp owner= (System,sys)
 3 The tables in the database table1, table2 export
   exp  system/manager@test file=d:\daochu.dmp tables= (table1,table2)  
 4 Export the fields in the table table1 in the database filed1 the data that starts with "00"
   exp system/manager@test file=d:\daochu.dmp tables= (table1) query=\ "where filed1 like ' 00% '"
  
above is the common export, for compression I do not care much, use WinZip file can be very good compression.
However, after the above command, add compress=y  to the  

Import of data:
1 Import the data from D:\DAOCHU.DMP into the test database.
Imp system/manager@test file=d:\daochu.dmp
There may be something wrong with it, because some tables already exist, and then it complains, and the table is not imported.
Just add ignore=y to the back.
2 Import the table table1 in D:\daochu.dmp
Imp system/manager@test file=d:\daochu.dmp tables= (table1)

Note: Exporting DMP data requires a user with permission to export the table, otherwise it cannot be exported.