1.创建表空间
create tablespace sales
datafile '/u01/app/oracle/oradate/orcl/orcl/sales01.dbf' size 800M
autoextend on
next 50M
maxsize unlimited
2.oracle复制表
create table nl_mobile_meager_user_tmp as select * from nl_mobile_meager_user
3.导入导出
exp 用户名/密码@tns配置名称 file=导出数据文件名.dmp log=导出数据文件日志名称.log owner=用户
imp 用户名/ 密码 @ tns配置名称 file=数据文件名称.dmp
==============恢复删除数据=============
第一步,先应记住被删除的表中有多少记录
select count(*) from t1;
第二步,delete该表的数据
delete from t1;
commnit;
第三步,获得当前scn
select dbms_flashback.get_system_change_number from dual;
第四步,根据第三步返回的scn不停地尝试查询直到所有记录都存在为止。
select count(*) from t1 as of scn 10670000;--10670000为返回的scn
第五步,当第四步返回的值为所删除的记录数时执行
insert into t1 select * from t1 as of scn 10670000;
commite;
=================================================================
创建触发器
create or replace trigger brand_tri
before insert or update on brand_log
for each row
declare
-- local variables here
begin
insert into brand_log_log values(
:new.ID,
:new.W_INDEX,
:new.CN_NAME,
:new.EN_NAME,
:new.BRAND_COVER,
:new.FATHER_BRAND,
:new.BRAND_LOCATION,
:new.FOUND_TIME,
:new.LOGO,
:new.BRAND_LEVEL,
:new.WEBSITE,
:new.WEIBO,
:new.SHOP_SOURCE,
:new.STATUS,
:new.BRAND_TYPE,
:new.FAV_COUNT,
:new.INTRO,
:new.WARE_COUNT,
:new.RELEASE_STATUS,
:new.WEB_DIS_STATUS,
:new.SHOP_DIS_STATUS2,
:new.COMPANY,
:new.PRODUCT_LINE,
:new.IS_SHOP,
:new.CREATE_TIME,
:new.UPDATE_TIME,
:new.USERNAME,
:new.MEMO1,
:new.MEMO2,
:new.MEMO3,
:new.MEMO4,
:new.MEMO5,
:new.MEMO6,
:new.TMALL_SHOP,
:new.LAST_WARE_TIME,
:new.LAST_WARE_COUNT,
:new.COM_REASON);
end brand_tri;
删除除法器
drop trigger brand_tri