一般的exp好像能导出标的结构和索引以及其他的东西,我现在只需要的表中的数据记录。
用的数据库为oracle 7.3.4
谢谢先!
7 个解决方案
#1
EXP80 system/manager file=tank log=tank tables=seapark.tank
#2
用
exp user/pass@dbs file=.. tables=.. rows=y log=.. owner=.. indexes=n grants=n;
exp user/pass@dbs file=.. tables=.. rows=y log=.. owner=.. indexes=n grants=n;
#3
同上
#4
好像还是不行啊
$ exp sxgd/sxgd@dbs file=task.dmp tables=task_cmd rows = Y owner=sxgd indexes
=Y grants=Y;
Export: Release 7.3.4.0.0 - Production on Fri Nov 22 17:19:23 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
LCC-00211: unexpected delimiter [rows]
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
$ exp sxgd/sxgd@dbs file=task.dmp tables=task_cmd rows = Y owner=sxgd indexes
=Y grants=Y;
Export: Release 7.3.4.0.0 - Production on Fri Nov 22 17:19:23 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
LCC-00211: unexpected delimiter [rows]
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
#5
exp sxgd/sxgd file=task.dmp tables=task_cmd
#6
自己查查资料不就行了.
#7
在PL/SQL 中的菜单中有EXP 这项,你选择它,然后选择你要导出的表
比写脚本简单
比写脚本简单
#1
EXP80 system/manager file=tank log=tank tables=seapark.tank
#2
用
exp user/pass@dbs file=.. tables=.. rows=y log=.. owner=.. indexes=n grants=n;
exp user/pass@dbs file=.. tables=.. rows=y log=.. owner=.. indexes=n grants=n;
#3
同上
#4
好像还是不行啊
$ exp sxgd/sxgd@dbs file=task.dmp tables=task_cmd rows = Y owner=sxgd indexes
=Y grants=Y;
Export: Release 7.3.4.0.0 - Production on Fri Nov 22 17:19:23 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
LCC-00211: unexpected delimiter [rows]
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
$ exp sxgd/sxgd@dbs file=task.dmp tables=task_cmd rows = Y owner=sxgd indexes
=Y grants=Y;
Export: Release 7.3.4.0.0 - Production on Fri Nov 22 17:19:23 2002
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
LCC-00211: unexpected delimiter [rows]
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
#5
exp sxgd/sxgd file=task.dmp tables=task_cmd
#6
自己查查资料不就行了.
#7
在PL/SQL 中的菜单中有EXP 这项,你选择它,然后选择你要导出的表
比写脚本简单
比写脚本简单