conn system/manager
grant connect,resource to a ident
ied by a; grant connect,resource to b ident
ied by b; conn a/a
create table a(a number);
insert
o a values(1); insert
o a values(2); insert
o a values(3); create table b(a number,b varchar2(10));
insert
o b values(1,\'1111\'); insert
o b values(2,\'2222\'); insert
o b values(3,\'3333\'); commit;
2、打开
个DOS窗口、先执行导出 E:\\>exp a/a file=a.dmp log=loga.txt
Export: Release 8.1.6.0.0 - Production _disibledevent=>
E:\\>imp a/a file=a.dmp show=y log=logb.txt
Import: Release 8.1.6.0.0 - Production on 星期 5 12月 1 22:29:49 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
连接到: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
经由常规路径导出由EXPORT:V08.01.06创建
文件 已经完成ZHS16GBK
集和ZHS16GBK NCHAR 集中导入 . 正在将A
对象导入到 A \"CREATE TABLE \"A\" (\"A\" NUMBER) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 25\"
\"5 LOGGING STORAGE(INITIAL 131072 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483\"
\"645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLE\"
\"SPACE \"SYSTEM\"\"
. . 正在跳过表 \"A\"
\"CREATE TABLE \"B\" (\"A\" NUMBER, \"B\" VARCHAR2(10)) PCTFREE 10 PCTUSED 40 INIT\"
\"RANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL 131072 NEXT 65536 MINEXTENTS 1 \"
\"MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P\"
\"OOL DEFAULT) TABLESPACE \"SYSTEM\"\"
. . 正在跳过表 \"B\"
成功终止导入
但出现警告
E:\\>
4、使用编辑器打开logb.txt
里面可以看到建表语句
最新评论