conn system/manager
grant connect,resource to a identied by a;
grant connect,resource to b identied 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里面可以看到建表语句
最新评论