The Reset method is as follows: Open the cmd command prompt and enter the following command to reset:
Input Sqlplus/nolog, enter
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 importing and exporting, and seeing an instance of import and export is basically done, because importing and exporting is simple.
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)
Basically, the above import and export is enough. In many cases I have completely removed the table and then imported it.
Data export:
Exp hkb/[email protected]_14 full=y file=c:\orabackup\hkbfull.dmp log=c:\orabackup\hkbfull.log;
Export considerations: Export the current user's data, if the current user has DBA authority, then export all the data!
Data import between users with the same name:
Imp hkb/[email protected] file=c:\orabackup\hkbfull.dmp log=c:\orabackup\hkbimp.log full=y
Data import between different names:
Imp system/[email protected] FROMUSER=HKB touser=hkb_new file=c:\orabackup\hkbfull.dmp
Log=c:\orabackup\hkbimp.log;