| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> shi li jiang jie Oracle shu ju ku she zhi mo ren biao kong jian wen ti
 

shi li jiang jie Oracle shu ju ku she zhi mo ren biao kong jian wen ti

2008-08-05 07:04:59 编辑來源:互联网 评论
 
本文为【实例讲解Oracle数据库设置默认表空间问题】的拼音翻译版
  DBA men jing chang hui yu dao yi ge zhe yang ling ren tou teng de wen ti : bu zhi dao shui zai Oracle shang chuang jian le yi ge yong hu , chuang jian shi , mei you gei zhe ge yong hu zhi ding mo ren biao kong jian , suo yi zhe ge yong hu jiu hui cai yong mo ren de biao kong jian ——system biao kong jian 。 dao zhi xi tong biao kong jian xun su bei yong hu shu ju zhan man , zhi zhi dang ji 。
  zai 10G zhong ,DBA you ban fa bi mian zhe zhong wen ti le —— zai xian zhi ding xi tong mo ren biao kong jian :
  ALTER DATABASE DEFAULT TABLESPACE ;
  tong guo zhi xing yi shang ming ling , ke yi she ding xi tong de mo ren biao kong jian 。 zhe yang de hua , zai chuang jian xin yong hu shi , ru guo bu zhi ding ta de mo ren biao kong jian , jiu hui cai yong shang mian zhi ding de xi tong mo ren biao kong jian zuo wei zhe ge yong de mo ren biao kong jian 。
  SQL>conn /as sysdba
  SQL> create user test1 identified by test1 default tablespace ringidx;
  yong hu yi chuang jian 。
  SQL> alter database default tablespace ring;
  shu ju ku yi geng gai 。
  SQL> create user test identified by test;
  yong hu yi chuang jian 。
  SQL> select username, default_tablespace defspace from dba_users where
  username=’TEST’;
  USERNAME DEFSPACE
  ————– —————-
  TEST RING
  dan shi yao zhu yi de shi , yi dan jiang xi tong mo ren biao kong jian xiu gai le yi hou , yuan you de suo you pu tong yong hu de mo ren biao kong jian dou hui bei zhi ding wei zhe ge biao kong jian , ru shang li zhong test1, chuang jian shi zhi ding le ta de mo ren biao kong jian wei ringidx, zhi xing le ’alter database default tablespace ring’ hou , ta de mo ren biao kong jian ye bei gai wei le ring。
  SQL> select username, default_tablespace defspace from dba_users where
  username=’TEST1′;
  USERNAME DEFSPACE
  ————– —————-
  TEST1 RING
  wei fei gai xin de xi tong yong hu zhi ding yi ge te shu de mo ren biao kong jian
  zai chuang jian Oracle shi li shi , chu le chuang jian le ru sys、system deng xi tong gai xin de yong hu wai , huan hui chuang jian yi xie zhu ru dbsnmp、odm、perfstat deng fei gai xin de yong hu 。 zhe xie yong hu zai 9i zhong dou shi yi system zuo wei ta men de mo ren biao kong jian 。 zhe xie yong hu yi dan bei shi yong , ye hui chan sheng jiao da de shu ju liang zhan yong system biao kong jian 。
  zai Oracle10G dang zhong , shi yong le yi ge xin de biao kong jian SYSAUX zuo wei zhe xie yong hu de mo ren biao kong jian 。 zhe ge biao kong jian zai shi li chuang jian shi jiu chuang jian le , chu le ta de shu ju wen jian ming ke yi bei xiu gai wai , qi ta dou bu yuan xu bei xiu gai 。
  Oracle de zhe yi gai bian ke yi shi dang system biao kong jian sun huai shi dui shu ju ku zuo quan ku hui fu 。 zai sysaux zhong de dui xiang ke yi hui fu cheng pu tong dui xiang , er shu ju ku neng bao chi zheng chang yun xing 。
  ru guo DBA xiang yao jiang sysaux biao kong jian zhong de yong hu zhuan yi dao qi ta biao kong jian qu gai ru he zuo ne 。 zai 10G zhong , zhuan men wei ci ti gong yi ge shi tu V$SYSAUX_OCCUPANTS lai miao shu ru he zhuan yi zhe xie yong hu de biao kong jian 。
  select * from V$SYSAUX_OCCUPANTS where OCCUPANT_NAME = ‘ODM’
  OCCUPANT_NAME OCCUPANT_DESC SCHEMA_NAME MOVE_PROCEDURE MOVE_PROCEDURE_DESC SPACE_USAGE_KBYTES
  ————- ————- ———– ————– ——————- ——————
  ODM Oracle Data Mining DMSYS MOVE_ODM Move Procedure for Oracle Data Mining 5568
  1 rows selected
  ru shang , ru guo yao jiang gai bian ODM de biao kong jian , ke yi shi yong cun chu guo cheng MOVE_ODM, dang qian ta zhan yong le 5568kb de biao kong jian 。
  wei biao kong jian gai ming
  zhe Oracle10G biao kong jian zeng qiang zhong yi ge ling ren xin dong de gai bian 。
  zhe xiang gong neng yuan xu gai bian shu ju ku zhong chu system he sysaux wai ren yi yi ge biao kong jian de ming zi 。
  ALTER TABLESPACE RENAME TO ;
  you le zhe xiang gong neng , jiang hui rang hen duo shi qing bian de fei chang jian dan 。
  you DBA ke neng hui dan xin , yi dan yi ge biao kong jian de ming zi gai bian le , er qie ta yi jing bei shi yong le hen chang shi jian le , hui bu hui yin qi xi tong de hun luan ? zhe ge bu yong dan xin , zhi xing le shang mian de yu ju hou ,Oracle hui jiang xi tong zhong suo you xiang guan de shu ju zi dian de nei rong quan bu geng xin :
  SQL> alter tablespace ring rename to ring1;
  biao kong jian yi geng gai 。
  SQL> select username, default_tablespace defspace from dba_users where username=’TEST’;
  USERNAME DEFSPACE
  ————– —————-
  TEST RING1【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
DBA men jing chang hui yu dao yi ge zhe yang ling ren tou teng de wen ti : bu zhi dao shui zai Oracle shang chuang jian le yi ge yong hu , chuang jian shi , mei you gei zhe ge yong hu zhi ding mo ren biao kong jian , suo yi zhe ge yong hu jiu hui cai yong mo ren de biao kong jian ——system biao kong jian 。 dao zhi xi tong biao kong jian xun su bei yong hu shu ju zhan man , zhi zhi dang ji 。 zai 10G zhong ,DBA you ban fa bi mian zhe zhong wen ti le —— zai xian zhi ding xi tong mo ren biao kong jian : ALTER DATABASE DEFAULT TABLESPACE ; tong guo zhi xing yi shang ming ling , ke yi she ding xi tong de mo ren biao kong jian 。 zhe yang de hua , zai chuang jian xin yong hu shi , ru guo bu zhi ding ta de mo ren biao kong jian , jiu hui cai yong shang mian zhi ding de xi tong mo ren biao kong jian zuo wei zhe ge yong de mo ren biao kong jian 。 SQL>conn /as sysdba SQL> create user test1 identified by test1 default tablespace ringidx; yong hu yi chuang jian 。 SQL> alter database default tablespace ring; shu ju ku yi geng gai 。 SQL> create user test identified by test; yong hu yi chuang jian 。 SQL> select username, default_tablespace defspace from dba_users where username=’TEST’; USERNAME DEFSPACE ————– —————- TEST RING dan shi yao zhu yi de shi , yi dan jiang xi tong mo ren biao kong jian xiu gai le yi hou , yuan you de suo you pu tong yong hu de mo ren biao kong jian dou hui bei zhi ding wei zhe ge biao kong jian , ru shang li zhong test1, chuang jian shi zhi ding le ta de mo ren biao kong jian wei ringidx, zhi xing le ’alter database default tablespace ring’ hou , ta de mo ren biao kong jian ye bei gai wei le ring。 SQL> select username, default_tablespace defspace from dba_users where username=’TEST1′; USERNAME DEFSPACE ————– —————- TEST1 RING wei fei gai xin de xi tong yong hu zhi ding yi ge te shu de mo ren biao kong jian zai chuang jian Oracle shi li shi , chu le chuang jian le ru sys、system deng xi tong gai xin de yong hu wai , huan hui chuang jian yi xie zhu ru dbsnmp、odm、perfstat deng fei gai xin de yong hu 。 zhe xie yong hu zai 9i zhong dou shi yi system zuo wei ta men de mo ren biao kong jian 。 zhe xie yong hu yi dan bei shi yong , ye hui chan sheng jiao da de shu ju liang zhan yong system biao kong jian 。 zai Oracle10G dang zhong , shi yong le yi ge xin de biao kong jian SYSAUX zuo wei zhe xie yong hu de mo ren biao kong jian 。 zhe ge biao kong jian zai shi li chuang jian shi jiu chuang jian le , chu le ta de shu ju wen jian ming ke yi bei xiu gai wai , qi ta dou bu yuan xu bei xiu gai 。 Oracle de zhe yi gai bian ke yi shi dang system biao kong jian sun huai shi dui shu ju ku zuo quan ku hui fu 。 zai sysaux zhong de dui xiang ke yi hui fu cheng pu tong dui xiang , er shu ju ku neng bao chi zheng chang yun xing 。 ru guo DBA xiang yao jiang sysaux biao kong jian zhong de yong hu zhuan yi dao qi ta biao kong jian qu gai ru he zuo ne 。 zai 10G zhong , zhuan men wei ci ti gong yi ge shi tu V$SYSAUX_OCCUPANTS lai miao shu ru he zhuan yi zhe xie yong hu de biao kong jian 。 select * from V$SYSAUX_OCCUPANTS where OCCUPANT_NAME = ‘ODM’ OCCUPANT_NAME OCCUPANT_DESC SCHEMA_NAME MOVE_PROCEDURE MOVE_PROCEDURE_DESC SPACE_USAGE_KBYTES ————- ————- ———– ————– ——————- —————— ODM Oracle Data Mining DMSYS MOVE_ODM Move Procedure for Oracle Data Mining 5568 1 rows selected ru shang , ru guo yao jiang gai bian ODM de biao kong jian , ke yi shi yong cun chu guo cheng MOVE_ODM, dang qian ta zhan yong le 5568kb de biao kong jian 。 wei biao kong jian gai ming zhe Oracle10G biao kong jian zeng qiang zhong yi ge ling ren xin dong de gai bian 。 zhe xiang gong neng yuan xu gai bian shu ju ku zhong chu system he sysaux wai ren yi yi ge biao kong jian de ming zi 。 ALTER TABLESPACE RENAME TO ; you le zhe xiang gong neng , jiang hui rang hen duo shi qing bian de fei chang jian dan 。 you DBA ke neng hui dan xin , yi dan yi ge biao kong jian de ming zi gai bian le , er qie ta yi jing bei shi yong le hen chang shi jian le , hui bu hui yin qi xi tong de hun luan ? zhe ge bu yong dan xin , zhi xing le shang mian de yu ju hou ,Oracle hui jiang xi tong zhong suo you xiang guan de shu ju zi dian de nei rong quan bu geng xin : SQL> alter tablespace ring rename to ring1; biao kong jian yi geng gai 。 SQL> select username, default_tablespace defspace from dba_users where username=’TEST’; USERNAME DEFSPACE ————– —————- TEST RING1
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
追忆.绯红色的审判
新竹的果子风
热裤女孩
凯宾斯基酒店随拍
金色草原
菜园小品
情人谷
广东惠州—巽寮湾的海景
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有