Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓëoracleÏà¹ØµÄһЩÃüÁî

1.µÇ½ϵͳÓû§
sqlplus È»ºóÊäÈëϵͳÓû§ÃûºÍÃÜÂë
µÇ½±ðµÄÓû§
conn Óû§Ãû/ÃÜÂë;
2.´´½¨±í¿Õ¼ä
create tablespace ¿Õ¼äÃû
datafile 'c:\¿Õ¼äÃû' size 15M --±í¿Õ¼äµÄ´æ·Å·¾¶,³õʼֵΪ15M
autoExtend on next 10M --¿Õ¼äµÄ×Ô¶¯Ôö³¤µÄÖµÊÇ10M
permanent online; --ÓÀ¾ÃʹÓÃ
3.´´½¨Óû§
create user shi --´´½¨Óû§ÃûΪshi
identified by scj --´´½¨ÃÜÂëΪscj
default tablespace ±í¿Õ¼äÃû --ĬÈϱí¿Õ¼äÃû
temporary tablespace temp --ÁÙʱ±í¿Õ¼äΪtemp
profile default --ÊÜprofileÎļþµÄÏÞÖÆ
quota unlimited on ±í¿Õ¼äÃû; --ÔÚ±í¿Õ¼äÏÂÃæ½¨±í²»ÊÜÏÞÖÆ
4.´´½¨½ÇÉ«
create role ½ÇÉ«Ãû identified by ÃÜÂë;
5.¸ø½ÇÉ«ÊÚȨ
grant create session to ½ÇÉ«Ãû£»--¸ø½ÇÉ«ÊÚÓè´´½¨»á»°µÄȨÏÞ
grant ½ÇÉ«Ãû to Óû§Ãû£» --°Ñ½ÇÉ«ÊÚÓèÓû§
6.¸øÓû§ÊÚÓèȨÏÞ
grant create session,resource to shi;--¸øshiÓû§ÊÚÓèËùÓÐȨÏÞ
grant create table to shi; --¸øshiÓû§ÊÚÓè´´½¨±íµÄȨÏÞ
7.select table_name from user_tables; ²ì¿´µ±Ç°Óû§ÏµÄËùÓбí
8.select tablespace_name from user_tablespaces; ²ì¿´µ±Ç°Óû§Ï嵀 ±í¿Õ¼ä
9.select username from dba_users;²ì¿´ËùÓÐÓû§Ãû³ÆÃüÁî ±ØÐëÓÃsys as sysdbaµÇ½
10.´´½¨±í
create table ±íÃû
(
id int not null,
name varchar2(20) not null
)tablespace ±í¿Õ¼äÃû --ËùÊôµÄ±í¿Õ¼ä
storage
(
initial 64K --±íµÄ³õʼֵ
minextents 1 --×îСÀ©Õ¹Öµ
maxextents unlimited --×î´óÀ©Õ¹Öµ
);
11.--Ϊusrs±íÌí¼ÓÖ÷¼üºÍË÷Òý
alter table users
add constraint pk primary key (ID);
12.ΪÒѾ­´´½¨users±íÌí¼ÓÍâ¼ü
alter table users
add constraint fk_roleid foreign key (roleid)
references role(role_id) on delete cascad; --ϱßдÖ÷±íµÄÁÐ
on delete cascadÊÇ´´½¨¼¶Áª
13.°ÑÁ½¸öÁÐÁ¬½ÓÆðÀ´
select concat(name,id) from ±íÃû£» --°ÑnameºÍidÁ¬½ÓÆðÀ´
14.½ØÈ¡×Ö·û´®
select column(name,'Àî') from ±íÃû£» --°ÑnameÖеġ®Àȥµô
15.ÔËÐÐÊÂÎñ֮ǰ±ØÐëд
set serveroutput on; --´ò¿ªÊäÈëÊä³ö£¨²»Ð´µÄ»°,´òÓ¡²»³öÐÅÏ¢£©
16.whileµÄÓ¦ÓÃ
declare --ÉùÃ÷²¿·Ö
ccc number:=1; --¸´Ö°
a number:=0;
begin --ÊÂÎñµÄ¿ªÊ¼
while ccc


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Ïêϸ½éÉÜORACLE sqlplusÃüÁî

 
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>shutdow ......

ÔÚlinuxÉÏsilent°²×°oracle¼òÖ±ÊÇÒ»³¡Ø¬ÃÎ

 Parsing command line arguments:
    Parameter "silent" = true
java.lang.ArrayIndexOutOfBoundsException: 2
        at oracle.net.ca.CmdlineArgs.parseArgs(Unknown Source)
        at oracle.net.ca.I ......

ORACLEÖØ½¨ËùÓеÄË÷Òý


declare­
  STR VARCHAR2(400);­
begin­
  -- ÖØ½¨ORACLEË÷Òý­
  FOR TMP_IDX IN (SELECT TABLESPACE_NAME, OWNER, TABLE_NAME, INDEX_NAME­
                  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ