初始表空间-oracle

作者:talax 日期:2007-05-11 14:55:41

字体大小: 小中大

-- oracle (name)库表空间和用户创建(8i以上含8i)
-- 注意在运行时数据文件需要根据实际情况修改为实际路径
-- 生产表及索引的initial和next均用1m,
-- 而备份表和索引用4M

spool adc_create_tablespace_ora_1.log
--===============================================
-- 生产数据表空间 data_zxin_kf ==
--===============================================
Create Tablespace data_a_adc Datafile
'D:\oracle\a.dat' SIZE 500M
NOLOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT local
uniform size 1M;

--===============================================
-- 临时空间 TEMP_ZXIN_ADC ===
--===============================================
CREATE
TEMPORARY TABLESPACE TEMP_a_ADC TEMPFILE
'D:\oracle\b.ora' SIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

--===============================================
-- 用户创建 ==
--===============================================

CREATE USER mobileadc
IDENTIFIED BY mobileadc
DEFAULT TABLESPACE data_a_adc
TEMPORARY TABLESPACE TEMP_a_ADC
PROFILE DEFAULT;
GRANT DBA TO mobileadc;
ALTER USER mobileadc DEFAULT ROLE ALL;
GRANT UNLIMITED TABLESPACE TO mobileadc;

spool off
exit;

平均得分

(1 次评分)

文章来自: 本站原创

标签:

评论: 398 | 查看次数: 4094

共有 398 条评论

游客 [2008-08-29 16:51:19]

游客 [2008-08-29 15:47:22]

In wow gold,which class do wow gold you hold ?Maybe buy wow gold it is warlocks.Many buy wow gold of the Warlock's cheap wow gold offensive capabilities cheap wow gold are Damage world of warcraft gold Over Time spells (DOT). These spells do fast wow gold not deal direct damage, like sell wow gold a Mage's magic, but age of conan gold rather slowly hurts the Warlocks foes aoc gold over a longer period. While ffxi gil this seems initially weak, the damage they warhammer gold can deal over a long period runescape gold of time out paces any tibia gold character, even the swg credits strongest DPS class in lotro gold the game. Very few 2moons dil creatures can withstand the maple story mesos Warlock's DOTs, demon pet eve isk and their direct damage. Perhaps the lineage 2 adena most valuable eq2 plat ability of the Warlock though, is their fear wow power leveling based spells. Virtually no wow power leveling creature is power leveling immune to their fear, which sends world of warcraft power leveling opponents running in terror wow power level from them. Coupled with their DOTs and wow leveling demon pet, a Warlock's fear wow leveling is often the final kiss of death power leveling for many of the monsters that roam Azeroth's lands.

游客 [2008-08-29 10:22:33]

美容
整容医院
整形医院
整形美容
整形
鼻部整形
韩式整容
怎么样减肥
腰部减肥
疤痕
去疤痕
牙科医院
妇科病症状
妇科医生在线咨询
妇科整形
妇科知识
老年性阴道炎
什么是多囊卵巢
意外怀孕
怎样知道自己怀孕了

游客 [2008-08-29 10:22:12]

怀孕症状
流产手术
慢性宫颈炎
慢性盆腔炎治疗
霉菌性阴道炎
霉菌性阴道炎的治疗
女性不孕
女性尖锐湿疣初期症状
盆腔炎
盆腔炎的症状
人工流产
附件炎
附件炎的症状
妇科检查
妇科炎症
妇科炎症的治疗
妇科咨询
宫颈糜烂
宫颈糜烂的原因
宫颈糜烂如何治疗
宫颈炎
白带带血
白带增多
不孕不育医院
多发性子宫肌瘤
多囊卵巢
多囊卵巢综合征
多囊卵巢综合症
非淋菌性尿道炎

游客 [2008-08-29 10:04:30]

自体脂肪隆胸
自体脂肪移植
自体脂肪丰胸
隆胸失败
医学美容
双眼皮
埋线双眼皮
割双眼皮
双眼皮手术
眼袋
去眼袋
眼袋手术
下睑袋矫正术
眉提升
如何去除眼袋
去眼袋手术
鼻部整形
隆鼻手术
鼻翼肥厚
鼻部综合整形
韩式隆鼻
隆鼻术
隆胸手术
假体隆胸
丰胸手术
假体丰胸

假体隆胸
如何丰胸
注射物取出
垫下巴
怎样瘦脸
瘦脸方法
颧骨
吸脂减肥
吸脂手术
抽脂手术
抽脂
抽脂减肥
隆胸
瘦脸
吸脂
除皱
拉皮
透明质酸
玻尿酸
阴道紧缩
北京最好的整形医院
瘦小腿

游客 [2008-08-28 15:03:38]

帆板赛场将决出男女帆板两枚金牌，目前曾在上届奥运会夺得银牌的中国帆板名将殷剑暂时居于第一位，她在最后一天如果发挥出色，很可能将取得金牌。王爱忱在男子帆板比赛中暂居第八位，他也将力争取得更好的成绩。中文酷站：电表控制器器，地磅遥控器，上海大众搬场，上海大众搬场，上海公兴搬场，除湿机，上海租车，机械表调校器，膜结构。空气呼吸器

游客 [2008-08-28 14:50:30]