1. in cmd
C:\Documents and Settings\dun>sqlplus / as sysdba
2. change system user's password even its default value is manager(I don't know why but it works)
SQL> alter user system account unlock identified by manager;
User altered.
3. put your dump file in disk ,like c:\tmp
SQL> create directory my_dir as 'C:\tmp';
Directory created.
4. quit sqlplus, in command mode, run like:
C:\Documents and Settings\dun>impdp system/manager directory=my_dir dumpfile=test.dmp logfile=0315.log
C:\Documents and Settings\dun>sqlplus / as sysdba
2. change system user's password even its default value is manager(I don't know why but it works)
SQL> alter user system account unlock identified by manager;
User altered.
3. put your dump file in disk ,like c:\tmp
SQL> create directory my_dir as 'C:\tmp';
Directory created.
4. quit sqlplus, in command mode, run like:
C:\Documents and Settings\dun>impdp system/manager directory=my_dir dumpfile=test.dmp logfile=0315.log
996
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
