oracleн¨Óû§£¬ÊÚȨ£¬½¨±í¿Õ¼äÓï¾ä
oracle´´½¨±í¿Õ¼ä£¬´´½¨Óû§(ת)
¹Ø¼ü×Ö: oracle ±í¿Õ¼ä Óû§
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//´´½¨Êý¾Ý±í¿Õ¼ä
create tablespace test_data
logging
datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
create user username identified by password
default tablespace test_data
temporary tablespace test_temp;
//¸øÓû§ÊÚÓèȨÏÞ
grant connect,resource to username;
//ÒÔºóÒÔ¸ÃÓû§µÇ¼£¬´´½¨µÄÈκÎÊý¾Ý¿â¶ÔÏó¶¼ÊôÓÚtest_temp ºÍtest_data±í¿Õ¼ä£¬Õâ¾Í²»ÓÃÔÚÿ´´½¨Ò»¸ö¶ÔÏó¸øÆäÖ¸¶¨±í¿Õ¼äÁË¡£
-----------------------------------------------
´´½¨±í£º
ÓÃÕâ¸öн¨Óû§µÇ¼oracle£¬´´½¨±í£º
Óû§±í ITS_USER
×Ö¶ÎÃèÊö
×Ö¶ÎÃû
ÀàÐÍ
Ö÷¼ü
²»Îª¿Õ
±¸×¢
Óû§´úÂë
USERXH
VARCHAR2(32)
TRUE
TRUE
Óû§ÐÕÃû
USERNAME
VARCHAR2(16)
FALSE
TRUE
ÐÕÃû
Óû§ÃÜÂë
PASSWORD
VARCHAR2(32)
FALSE
FALSE
Óû§ÃÜÂë
ÁªÏµµç»°
TELEPHONE
VARCHAR2(30)
FALSE
FALSE
ÁªÏµµç»°
¹ÜÀí²¿ÃÅ
GLBM
VARCHAR2(10)
FALSE
TRUE
¹ÜÀí²¿ÃÅ£¬its_departmnet.glbm
Óû§µÈ¼¶
YHDJ
VARCHAR2(2)
FALSE
TRUE
Óû§½ÇÉ«
YHJS
VARCHAR2(1)
FALSE
TRUE
‘1’¹ÜÀíÔ±£¬‘2’ÆÕͨÓû§
CREATE TABLE ITS_USER
(USERXH VARCHAR2(32) NOT NULL,
USERNAME VARCHAR2(16),
PASSWORD VARCHAR2(32),
TELEPHONE VARCHAR2(30),
GLBM VARCHAR2(10),
YHDJ VARCHAR2(2),
YHJS VARCHAR2(1),
constraint PK_T_SCORE primary key(USERXH)
);
----------------------------------------------------------
²éѯ£º
select * from ITS_USER
-------------------------------------------------------
²åÈëÊý¾Ý£º
INSERT INTO ITS_USER(USERXH,USERNAME,PASSWORD,
Ïà¹ØÎĵµ£º
ÔÚSQL*PlusÖУº£¨1£©ÈçºÎÌí¼Óɾ³ýÊý¾Ý¿â£¿£¨2£©Êý¾Ý¿â¾ÍÊDZíÂ𣿣¿£¨3£©ÈçºÎ´´½¨±í¿Õ¼ä£¿£¨4£©ÈçºÎ´´½¨Óû§£¿£¨5£©ÊDz»ÊÇÒ»¸ö±í¿Õ¼äÖ»ÄÜ´´½¨Ò»¸öÓû§£¿£¨6£©ÔõÑù´Ó¿Í»§¶Ë·ÃÎÊÊý¾Ý¿â·þÎñÆ÷µÄÅäÖã¿
¡¡¡¡
¡¡¡¡»Ø´ð£º
¡¡¡¡1¡¢ºÎÌí¼Óɾ³ýÊý¾Ý¿â£¿Ã»ÕâÖÖ¸ÅÄ²»¶®¡£
¡¡¡¡2¡¢Êý¾Ý¿â=ËùÓеÄoracleµÄÊý¾ÝÎļþ+¿ØÖÆÎļþ+ÈÕÖ¾Îļ ......
Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí:
rhel4-1->crs_stat -t
Name Type Target State Host
------------ ......
select name from v$datafile;
create dataspace tablespace datafile '/oracle/oradata/orcl/data01.dbf' size 1024m,'/oracle/oradata/orcl/data02.dbf' size 1024m autoextend on next 100m maxsize unlimited;
alter tablespace dataspace add datafile '/oracle/oradata/orcl/da ......
1. ´´½¨ÐµÄÊý¾Ý¿âʵÀý£º
D:\oracle\product\10.2.0\admin\adidb\scripts>dbca
2.Æô¶¯ºÍ¹Ø±ÕʵÀý
D:\oracle\product\10.2.0\admin\adidb\scripts>net start oracleserviceorcl
D:\oracle\product\10.2.0\admin\adidb\scripts>net stop oracleserviceorcl
3.Á¬½ÓÊý¾Ý¿âʵÀý
1> ÉèÖÃoracle_sid (set o ......
ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD" (
ID nvarchar2(20) &n ......