Oracle Database password reset, import Export Library command sample application _oracle

The Reset method is as follows: Open the cmd command prompt, and then enter the following command to reset:

Input Sqlplus/nolog, carriage return

Sql> Conn/as SYSDBA

is connected;

Sql>alter user system identified by "123456"; ---(123456 is the reset password)

Sql>alter user sys identified by "123456";

The following is an example of an import export, which is basically done when you look at an instance of an import export, because importing exports is simple.

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 Exporting a table from the system user in the database to the SYS user
Exp system/manager@test file=d:\daochu.dmp owner= (System,sys)
3 Export the table table1, table2 in the database
Exp system/manager@test file=d:\daochu.dmp tables= (table1,table2)
4 Export the fields in the table table1 in the database filed1 with the data beginning with "00"
Exp system/manager@test file=d:\daochu.dmp tables= (table1) query=\ "where filed1 like ' 0% '"

The above is the common export, for compression I do not care, with WinZip DMP file can be very good compression.
But it's okay to add compress=y to the command behind it.

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)

Basically, the import export above is sufficient. There are a lot of situations where I delete the table completely and import it.

Data export:

Exp hkb/hkb@boss_14 full=y file=c:\orabackup\hkbfull.dmp log=c:\orabackup\hkbfull.log;

Export considerations: Exports the current user's data, and the current user has DBA authority to export all data!

Data import between users with the same name:
Imp hkb/hkb@xe file=c:\orabackup\hkbfull.dmp log=c:\orabackup\hkbimp.log full=y

Data import between different names:
Imp system/test@xe fromuser=hkb touser=hkb_new file=c:\orabackup\hkbfull.dmp

Log=c:\orabackup\hkbimp.log;