--搜索数字效率更高
--dml语句 数据操作语言(insert delete update)
--表空间 用户
--cascade 级联
--exp导出
1.backup userxx备份
exp
2.create user创建
create user xx identified by xx default tablespace xxx quota(配额) 10M on xxx grant(分配权限)create session, create table,create view to xx;
3.import the data导入
--insert
insert into xx values('xx','xx',...);
insert into xx(xx,xxx) values('xx','xx');
insert into xx select * from xxx;
--roll back回滚
--备份
create table xx as select * from xxx;xx和xxx表内容完全一样