开发者

Backup and restore don't work for me in Oracle

i try this for backup:

$ exp scott/tiger FULL=y FILE='d:\demo.dmp';

and this for restore:

$ imp scott/tiger 开发者_开发百科FULL=y FILE='d:\demo.dmp';

and after restore i can't see the data in my tables.

(i work on Oracle 11.2.0 64bit)

thanks in advance


Gali-

Check this out. It's tailored for 10g, but the commands should remain the same.

http://www.oracle-base.com/articles/10g/OracleDataPump10g.php

Pay special attention to the "Getting Started" section where it talks about creating a directory, as well as the section dubbed "Database Exports/Imports." Hope this helps.

-CJ

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜