create table aaa(
id number,
name varchar2(100)
);
select decode((select max(id) from aaa),null,'x',(select max(id) from aaa)) from dual;
create tablespace &username  datafile '/oracle/oradata/orcl/&username.dbf'
size 512m
autoextend on
next 100m
maxsize unlimited
minimum extent 25m
default storage
(initial 128k
next 128k
minextents 1
maxextents unlimited
pctincrease 0); create user &username --为数据库用户名,请根据情况修改
identified by &username --为数据库用户密码,请根据情况修改
default tablespace &username --为创建的表空间名
temporary tablespace temp
quota unlimited on &username; grant dba to &username; imp w20170630/[email protected]:1521/wlydb file=E:\ku\数据库备份\20170630223000.dmp ignore=y full=y imp w20170810/w20170810 file=/tmp/20170810.dmp log=/tmp/20170810.log full=y
    1. ip导出方式: exp demo/[email protected]:1521/orcl file=f:/f.dmp full=y
    2. exp demo/demo@orcl file=f:/f.dmp full=y
    3. imp demo/demo@orcl file=f:/f.dmp full=y ignore=y
注意: 如果你的sql语句中 有什么判断语句 where id1 != 1这种   会默认过滤掉id为空的数据,也就是说能查出来id1不为1的数据,但是查不出来id1为空的数据
05-11 05:03