Oracle操作笔记

最新推荐文章于 2024-12-13 16:06:12 发布

wulei4

最新推荐文章于 2024-12-13 16:06:12 发布

阅读量91

点赞数

分类专栏： oracle 文章标签： Oracle

oracle 专栏收录该内容

20 篇文章

订阅专栏

1.创建150G的表空间
create tablespace taipinglife datafile
'/backup/oradata/ora10/taipinglife_01.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_02.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_03.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_04.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_05.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_06.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_07.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_08.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_09.dbf' size 15000M ,
'/backup/oradata/ora10/taipinglife_10.dbf' size 15000M;
2.导入150G的数据
写个DEMO
mkfifo fifo_${v_tname}
exp ${v_fromuser}/${v_frompass}@${v_service_name} tables=${v_tname} grants=n file=fifo_${v_tname} triggers=n indexes=n buffer=4096000 &
imp ${v_touser}/${v_topass} fromuser=${v_fromuser} touser=${v_touser} file=fifo_${v_tname} ignore=y
rm fifo_${v_tname}
3.闪回
flashback table abc to before drop;
4.清除
PURGE RECYCLEBIN;
5.查看
show recyclebin;