导出用户下的表格及其结构命令:
C:\Documents and Settings\Administrator>exp dsp4/dsp4@201 file=d:\dsp4.dmp owner=dsp4
Export: Release 10.2.0.3.0 - Production on 星期三 8月 10 10:22:49 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
导入用户下的表格及其结构命令:
C:\Documents and Settings\Administrator>imp dsp4/dsp4@orcl file=d:\dsp4.dmp from user=dsp4 touser=dsp4
Import: Release 10.2.0.3.0 - Production on 星期三 8月 10 11:01:57 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.