开发者

Backup and restore don't work for me in Oracle

开发者 https://www.devze.com 2023-02-18 19:28 出处:网络
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\';

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

精彩评论

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