Oracle»ù±¾²Ù×÷

1.´´½¨±í¿Õ¼ä
  create tablespace test datafile'c:\test.dbf' size 10m;  //Ãû×Ö²»ÒªÎªÊý×Ö
2.´´½¨Óû§
create user userName identified by password;  //²»ÒªÎªÊý×Ö
3.¸øÓû§ÊÚȨ
grant dba to userName; --ÊÚÓèDBAȨÏÞ
grant unlimited tablespace to userName;--ÊÚÓè²»ÏÞÖƵıí¿Õ¼ä
grant select any table to userName; --ÊÚÓè²éѯÈκαí
grant select any dictionary to userName;--ÊÚÓè ²éѯ ÈκÎ×Öµä
grant connect,resource,dba,imp_full_database,exp_full_database to sa;
4.²ì¿´µ±Ç°µÄÊý¾Ý¿âÃû
select name from v$database;
5.²ì¿´Êý¾Ý¿â¶ÔÏó
select owner, object_type, status, count(*) count# from all_objects group
by owner, object_type, status;
----------Oracle Óû§ÐÅÏ¢----------------
1. ²éѯoracleÖÐËùÓÐÓû§ÐÅÏ¢
select * from dba_users;
2. ²éѯÓû§ºÍÃÜÂë
select username,password from dba_users;
3. ²éѯµ±Ç°Óû§ÐÅÏ¢
select * from dba_ustats;
4. ²éѯÓû§¿ÉÒÔ·ÃÎʵÄÊÓͼÎı¾
Select * from dba_varrays;
5. ²éѯÊý¾Ý¿âÖÐËùÓÐÊÓͼµÄÎı¾
select * from dba_views;
-----------sql plus--------
1.ÊäÈëÓû§ÃûºÍÃÜÂë(systemΪÓû§Ãû)
2.½¨Á¢±í¿Õ¼ä,½¨Á¢Óû§(test/test),ÊÚȨ
3.ʹÓÃtestÓû§µÇ½
connect test/test        --connect
#sqlplus/nolog
#connect sys/test1234 as sysdba
######  sqlplus "sys/teset1234 as sysdba"
######  sqlplus "myccc/qwe"
4.½¨±í
CREATE TABLE count
(num1 NUMBER(4,2),
num2 NUMBER(5,2),
result NUMBER(6,2));
5.²åÈëÊý¾Ý
INSERT INTO count(num1,num2,result) VALUES(1,1,2);
INSERT INTO count(num1,num2,result) VALUES(1,1,1);
INSERT INTO count(num1,num2,result) VALUES(2,8,10);
INSERT INTO count(num1,num2,result) VALUES(68,90,158);
6.Ìá½»Êý¾Ý
commit;